BI developer (AVP) at Mitsubishi UFG in Bengaluru, Karnataka, India

BI developer (AVP)
Location: MUFG Global Service Private Ltd. - Bengaluru (BCIT)
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.
Position details
The Risk Reporting team is responsible for designing & developing the technologies that support data warehousing, data mining, Business Intelligence (BI) and reporting for the Group. To enhance the existing risk reporting data warehouses, tools and technologies.
Roles and Responsibilities
Contribute to the design and and development of efficient data models, schemas and pipelines
Develop data ingestion and processing solutions using existing framework
Write complex SQL queries, stored procedures and functions to extract, transform and load data
Optimize query performance to ensure data integrity and consistency
Providing BI technology subject matter expertise, collaborating with risk stakeholders to
understand business requirements and translate them into technical solutions
Implement data security measures and access controls aligned with firm’s governance policies
Monitor and troubleshoot data pipelines; identify performance bottlenecks and implement solutions
Participate in code reviews and document change made in the required format
Implement and maintain CI/CD pipelines for automated testing, deployment and monitoring of data solutions
Job Requirements:
-Essential
·       Strong proficiency in SQL, with an in-depth understanding of advanced SQL concepts and
·       techniques
·       Experience working with large scale, multi-terabyte data warehouses
·       Solid knowledge of data warehousing principles, dimensional modelling and star schema design
·       Hands-on experience with Snowflake, including their architecture, features and best practices
·       Familiarity with data integration tools and techniques (ELT, ETL)
·       Expert level PowerBI experience
·       Familiarity with scripting languages (e.g. Python, Powershell) for data processing and automation
·       Experience with dbt (data build tool) for data transformation and modelling
Preferred
·       Experience of working with risk systems within a financial institution
·       Experience of using Control-M or similar orchestration tools
·       Familiarity with Agile methodologies and DevOps practices
Mitsubishi UFJ Financial Group (MUFG) is an equal opportunity employer. We view our employees as our key assets as they are fundamental to our long-term growth and success. MUFG is committed to hiring based on merit and organsational fit, regardless of race, religion or gender.