- Senior
- Optionales Büro in London
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 150,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 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 modelling (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 modelling 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:
- Excellent communication skills
- Results driven, with a strong sense of accountability
- A proactive, motivated approach.
- The ability to operate with urgency and prioritise work accordingly
- Strong decision making skills, the ability to demonstrate sound judgement
- A structured and logical approach to work
- Strong problem solving skills
- A creative and innovative approach to work
- Excellent interpersonal skills
- The ability to manage large workloads and tight deadlines
- Excellent attention to detail and accuracy
- A calm approach, with the ability to perform well in a pressurised environment
- Strong numerical skills
We are open to considering flexible working requests in line with organisational requirements.
MUFG is committed to embracing diversity and building an inclusive culture where all employees are valued, respected and their opinions count. We support the principles of equality, diversity and inclusion in recruitment and employment, and oppose all forms of discrimination on the grounds of age, sex, gender, sexual orientation, disability, pregnancy and maternity, race, gender reassignment, religion or belief and marriage or civil partnership.
We make our recruitment decisions in a non-discriminatory manner in accordance with our commitment to identifying the right skills for the right role and our obligations under the law.
Jetzt bewerben