MUFG Data warehouse Developer in New York, New York
Do you want your voice heard and your actions to count?
Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we’re 160,000 colleagues, striving to make a difference for every client, organization, and community we serve. We stand for our values, building long-term relationships, serving society, and fostering shared and sustainable growth for a better world.
With a vision to be the world’s most trusted financial group, it’s part of our culture to put people first, listen to new and diverse ideas and collaborate toward greater innovation, speed and agility. This means investing in talent, technologies, and tools that empower you to own your career.
Join MUFG, where being inspired is expected and making a meaningful impact is rewarded.
This is a hybrid position. The selected colleague will work at an MUFG office or client sites up to four days per week and work remotely the remaining day(s). A member of our Talent Acquisition team will provide more details.
The successful candidate’s primary role as part of the BI TEC team will be to support a new multi-million dollar infrastructure which spans multiple regions (NY, LON & Asia). The infrastructure uses a combination of technologies including Snowflake, Python, MS SQL Server and Oracle database. Candidate would help in migrating/rewriting pl/sql code to Snowflake.
The candidate will work closely with various development teams and Business managers to enhance the data warehouse and reporting elements of the platform. Must have worked on Snowflake and used Python to some extent. Good technical knowledge of the SQL Server stack with strong core PL/SQL along with a solid understanding of data warehousing design principles. SSIS skills are desired but not essential. The candidate would be on Production support and have to manage control M batch and fix issues that might occur.
The role would suit a candidate with at least 5 years’ experience of working within capital market domain.
Previous experience working within Risk, Finance or Product Control areas is desirable although a strong track record of comparable experience on large scale data warehousing implementations is also acceptable.
•Define solutions paying particular attention to ensuring technical requirements have been factored in
•Work with the overnight batch processes using scheduling software, Control-M
•Work with wider Technology teams to ensure development and testing is coordinated and best practices are followed
•Help define test cases and work closely with users assisting them with testing bug fixes or new features and functions
•Collaborate with end users and help with BAU
•Develop efficient ELT routines using Snowflake.
•Need to understand Oracle PL/SQL to migrate to Snowflake
•Report to the Technology team lead and keep management abreast of status and progress on in-flight issues
•Ensure due diligence has been carried out on all software changes, paying particular attention to detail on unit, component and systems integration testing
•Package up artefacts using industry standard tools such as Subversion, SDA & TeamCity
•Work with BAU teams to ensure project changes are released to live in a coordinated manner
•Comply with the standard release cycle and deployment controls
•Understanding of products related to Securities trading / Capital Markets.
•Support requirements and design of future reporting needs (regulatory and internal).
•Will be responsible for production support.
•Must adhere to all internal IT policies and controls while handling sensitive financial production data
Skills & Experience:
•Solid Snowflake ad Python Skills
•Solid SQL Server Development skills with version 2019 or later
•Oracle Development skills with 11g or later
•Experience of writing ETL Packages using SSIS is desired but not mandatory
•Data Warehousing Design Experience and Kimball Methodologies
•Experience of working within a large database development project team
•Hands on Snowflake experience on live projects is a must
•Preferred candidate would have Snowflake Certification.
The typical base pay range for this role is between $110K - $135K depending on job-related knowledge, skills, experience and location. This role may also be eligible for certain discretionary performance-based bonus and/or incentive compensation. Additionally, our Total Rewards program provides colleagues with a competitive benefits package (in accordance with the eligibility requirements and respective terms of each) that includes comprehensive health and wellness benefits, retirement plans, educational assistance and training programs, income replacement for qualified employees with disabilities, paid maternity and parental bonding leave, and paid vacation, sick days, and holidays. For more information on our Total Rewards package, please click the link below.
MUFG Benefits Summary (https://careers.mufgamericas.com/sites/default/files/document/2023-01/mb-live-well-work-well.pdf)
The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required of personnel so classified.
We are proud to be an Equal Opportunity/Affirmative Action Employer and committed to leveraging the diverse backgrounds, perspectives and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate on the basis of race, color, national origin, religion, gender expression, gender identity, sex, age, ancestry, marital status, protected veteran and military status, disability, medical condition, sexual orientation, genetic information, or any other status of an individual or that individual’s associates or relatives that is protected under applicable federal, state, or local law.
At MUFG, our colleagues are our greatest assets. Our Culture Principles provide a roadmap for how each of our colleagues must think and act to become more client-obsessed, inclusive and innovative. They reflect who we are, who we want to be and what we expect from one another. We are excited to see you take the next step in exploring a career with us and encourage you to spend more time reviewing them!
Our Culture Principles
Listen Up. Speak Up.
Innovate & Simplify
Own & Execute