Senior Snowflake / Power BI Developer

Do you want your voice heard and your actions to count?

Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), one of the world’s leading financial groups. Across the globe, we’re 120,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.

The selected colleague will work at an MUFG office or client sites four days per week and work remotely one day. A member of our recruitment team will provide more details.

Job Profile:
Application Support/ Vice President

Job Code:

Job Title:

Sr.  Snowflake / Power BI Developer – Vice President

Job Summary:

The Risk Technology team is responsible for designing, integrating, and supporting Middle Office Risk systems within the organization, covering Market and Credit Risk management across EMEA, North America, and Asia Pacific regions. Our focus is on delivering robust platforms for analyzing and visualizing risk data, ultimately supporting critical decision-making and regulatory compliance.

Risk Technology is undergoing a significant transformation, driven by evolving regulatory demands and the need for enhanced data capabilities. This includes migrating legacy systems and expanding our existing platforms to leverage modern cloud-based solutions. The team is dedicated to consolidating and optimizing risk systems globally, embracing technologies like cloud for efficiency and standardization.

The successful candidate will play a pivotal role in enhancing the Market Risk platform, which utilizes Snowflake for data storage (including VaR, sensitivities, and stress data) and Power BI for reporting and analysis via both the Power BI Service and Excel. They will also be instrumental in migrating our legacy Credit Risk platform (SQL Server, SSIS, SSAS, SSRS) to this modern Snowflake/Power BI architecture. The role requires working directly with risk managers to capture requirements, manage expectations, and deliver impactful data solutions. This includes contributing to the expansion of our platform to support additional bank entities and potentially reverse engineering Excel EUCs into robust ELT processes. The ideal candidate will be adept at estimating projects of varying scales and thrive in a collaborative environment with a large international team.

Key Responsibilities:

• Design, develop, and implement data solutions using Snowflake and Power BI for the market risk platform, which includes VaR (Value-at-Risk), sensitivities, and stress testing data.
• Enhance and maintain existing Power BI models and cubes to ensure data accuracy, performance, and user accessibility (via Excel and Power BI Service).
• Contribute to migrating the legacy credit risk platform (SQL Server, SSIS, SSAS, and SSRS) to the new Snowflake/Power BI architecture.
• Develop and optimize ELT/ETL pipelines to ingest, transform, and load data into Snowflake, ensuring data quality and performance.
• Collaborate with risk managers and other stakeholders to gather requirements, estimate project scope, and translate business needs into technical specifications.
• Employ dbt (data build tool) for data modeling and transformation within Snowflake, ensuring data quality, lineage, and version control.
• Develop custom solutions using Python for data analysis, transformation, and integration tasks.
• Implement and maintain CI/CD pipelines for automated testing, deployment and monitoring of data solutions.
• Participate in troubleshooting and resolving data-related issues, performance bottlenecks, and system errors within the Snowflake and Power BI environment.
• Stay informed about industry trends and best practices in data warehousing, BI, and financial risk management.
• Communicate effectively with non-technical stakeholders and manage expectations regarding project deliverables and timelines.
• The capacity to plan, manage, and mentor junior developers, fostering their growth within the team.

Functional / Technical Competencies:

Essential:

• Experience as a BI Developer or Data Engineer with a focus on Snowflake and Power BI.
• Expertise in Snowflake, including data modeling (star/snowflake schemas), query optimization, and Snowflake-specific features (e.g., virtual warehouses, time travel).
• Experience designing and developing data pipelines using ADF (Azure Data Factory).
• Practical experience with dbt (data build tool) for data transformation and modeling in Snowflake.
• Proficiency in Power BI, including dashboard and report creation, data visualization best practices, and DAX (Data Analysis Expressions).
• Excellent SQL skills for data extraction, manipulation, and optimization.
• Hands-on experience with Python for data processing, scripting, and automation.
• Experience in the financial services industry, particularly with market risk concepts (VaR, sensitivities, stress testing).
• Proficiency in writing high-quality Technical Scope documents and Test Plans.

Preferred:

• Experience with Control-M or other job scheduling tools for orchestrating data pipelines.
• Experience with Streamlit for building interactive web applications for data visualization.
• Experience with migrating legacy data platforms (SQL Server, SSIS, SSAS, SSRS) to cloud-based solutions like Snowflake/Power BI.
• Experience reverse engineering Excel EUCs and implementing robust ELT processes to replace them.
• Experience with Azure containers (e.g., Blob Storage) and Azure Data Lake Storage (Gen2).

Personal Requirements:

• Strong analytical and problem-solving skills, coupled with meticulous attention to detail and a commitment to accuracy.
• Exceptional communication and interpersonal skills, enabling effective collaboration within a large, international team and with diverse stakeholders.
• A proactive and results-driven approach, taking full responsibility for development tasks, testing, and debugging, and consistently delivering high-quality results in a fast-paced environment.
• Excellent organizational skills and a disciplined, structured approach to working independently and under tight deadlines.
• The ability to manage expectations and thrive in a dynamic environment, adapting quickly to change and prioritizing workload effectively.
• Strong decision-making capabilities, consistently demonstrating sound judgment.
• A fast-learning aptitude, quickly grasping and applying new information in a complex domain.
• Strong English language speaking and writing skills for clear and effective communication.

Education

A Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field, or equivalent practical experience.

Other Qualifications: 

As per MUFG’s work policy for all personnel, candidates must work onsite for 4 days and 1 day remotely out of 1251 Avenue of the Americas, New York, NY office

The typical base pay range for this role is between $134K - $165K 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

We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws (including (i) the San Francisco Fair Chance Ordinance, (ii) the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, (iii) the Los Angeles County Fair Chance Ordinance, and (iv) the California Fair Chance Act) to the extent that (a) an applicant is not subject to a statutory disqualification pursuant to Section 3(a)(39) of the Securities and Exchange Act of 1934 or Section 8a(2) or 8a(3) of the Commodity Exchange Act, and (b) they do not conflict with the background screening requirements of the Financial Industry Regulatory Authority (FINRA) and the National Futures Association (NFA). The major responsibilities listed above are the material job duties of this role for which the Company reasonably believes that criminal history may have a direct, adverse and negative relationship potentially resulting in the withdrawal of conditional offer of employment, if any.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 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.