Job Description

About MUFG Global Service (MGS)
MUFG Bank, Ltd. is Japan's premier bank, with a global network spanning in more than 40 markets. Outside of Japan, the bank offers an extensive scope of commercial and investment banking products and services to businesses, governments, and individuals worldwide. MUFG Bank's parent, Mitsubishi UFJ Financial Group, Inc. (MUFG) is one of the world's leading financial groups. Headquartered in Tokyo and with over 360 years of history, the Group has about 120,000 employees and offers services including commercial banking, trust banking, securities, credit cards, consumer finance, asset management, and leasing.The Group aims to be the world's most trusted financial group through close collaboration among our operating companies and flexibly respond to all the financial needs of our customers, serving society, and fostering shared and sustainable growth for a better world. MUFG's shares trade on the Tokyo, Nagoya, and New York stock exchanges.For more informat

About Us:
MUFG Bank, Ltd. is Japans premier bank, with a global network spanning in more than 40 markets. Outside of Japan, the bank offers an extensive scope of commercial and investment banking products and services to businesses, governments, and individuals worldwide. MUFG Banks parent, Mitsubishi UFJ Financial Group, Inc. (MUFG) is one of the worlds leading financial groups. Headquartered in Tokyo and with over 360 years of history, the Group has about 120,000 employees and offers services including commercial banking, trust banking, securities, credit cards, consumer finance, asset management, and leasing. The Group aims to be the worlds most trusted financial group through close collaboration among our operating companies and flexibly respond to all the financial needs of our customers, serving society, and fostering shared and sustainable growth for a better world. MUFGs shares trade on the Tokyo, Nagoya, and New York stock exchanges.
MUFG Global Service Private Limited:
Established in 2020, MUFG Global Service Private Limited (MGS) is 100% subsidiary of MUFG having offices in Bengaluru and Mumbai. MGS India has been set up as a Global Capability Centre / Centre of Excellence to provide support services across various functions such as IT, KYC/ AML, Credit, Operations etc. to MUFG Bank offices globally. MGS India has plans to significantly ramp-up its growth over the next 18-24 months while servicing MUFGs global network across Americas, EMEA and Asia Pacific.
About the Role:
Position Title:Assistant Vice President
Corporate Title: Assistant Vice President
Reporting to: Vice President
Location: MESI -Bengaluru
Job Profile:
Data Services Layer Engineer who will lead, plan, design and implement data integration solutions for On-prem data warehouses / data marts and cloud data platform including subject area marts and interfaces to downstream applications. The ideal candidate will be an adaptable project lead who will have a technical background coupled with proficient business acumen to enable them to draw and effectively communicate meaningful business conclusions and insights from a wide variety of data sources and structures. In this role you will lead/support the delivery of Enterprise Data Services related projects focused on enabling data aggregation from disparate sources or systems, reconciliations, and adjustments. Responsibilities include owning the development, roll out, and testing of data integration solutions by working closely with ETL and BI development teams, project, and product managers to manage IT stakeholder relationships, set and execute against project milestones, and manage quality, client satisfaction, and engagement throughout the implementation life cycle.
Position details:
Roles and Responsibilities:

• Manage data analysis and data integration of disparate systems.
• Create a semantic layer for data virtualization that connects to heterogeneous data repositories.
• Develop reports and dashboards using Tableau, Power BI, or similar BI tools as assigned.
• Assist Data Management Engineering Team (either for Data Pipelines Engineering or Data Service & Data Access Engineering) for ETL or BI Design and other framework related items.
• Work with business users to translate functional specifications into technical designs for implementation and deployment.
• Extract, transform, and load large volumes of structured and unstructured data from various sources into AWS data lakes or modern data platforms like Snowflake.
• Assist with Data Quality Controls as assigned.
• Work with cross functional team members to develop prototypes, produce design artifacts, develop components, perform, and support SIT and UAT testing, triaging and bug fixing.
• Resolve issues and defects in a timely manner and ensure quality deliverables.
• Optimize data integration platform to provide optimal performance under increasing data volumes.
• Develop data integration standards according to the organizations information services policies as well as best practices.
• Conduct review of other integration developers development efforts to ensure consistent methodologies are followed and to make recommendations where necessary.
• Experience working with Agile teams and JIRA.
• Ensure high quality and optimum performance of data integration systems to meet business solutions.

• Bachelors Degree (or foreign equivalent degree) in Information Technology, Information Systems, Computer Science, Software Engineering, or a related field. Experience in the financial services or banking industry is preferred.
• 8+ years of experience with leading design, development, and optimization of dashboards and reports using Power BI, Tableau, and other reporting platforms.
• 5+ years of experience with integration of BI tools with data warehouses / lakes (e.g. Snowflake), along with strong knowledge of Data Modelling, UX/UI for Dashboards.
• 3+ years of experience with migration of reports from legacy platforms.
• 5+ years of experience with data virtualization, data mesh, data fabric, and federated querying platforms such as Denodo, Starburst or OSS platforms are highly desirable.
• 3+ Years of experience working as a Data Engineer, with a focus on building data pipelines and processing large datasets.
• 5+ Years of strong proficiency in AWS services, including AWS Glue, Redshift, EMR, RDS, Kinesis, S3, Athena, DynamoDB, Step Functions and Lambda.
• 2+ Years of Expertise in dealing with data pipelines associated with modern data platforms such as snowflake.
• Solid understanding of data modeling, database design, and ETL principles.
• Experience working with data lakes, data warehouses, and distributed computing systems.
• Familiarity with data governance, data security, and compliance practices in cloud environments.
• Exposure to Data Virtualization tools such as Starburst, Dremio or Denodo is a plus.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
• AWS / Snowflake / Power BI / Tableau certifications are a plus.
• Business Acumen: 15%: Knowledge of Banking & Financial Services Products (such as Loans, Deposits, Forex, etc.). Knowledge of Operational / MIS Reports, Risk and Regulatory Reporting for a US Bank is a plus.
• Data Skills:25%: Must have proficiency in Data Warehousing concepts, Data Lake & Data Mesh concepts, Data Modeling, Databases, Data Governance, Data Security / Protection, and Data Access.
• Tech Skills: 50%: See above
• Human Skills:10%: Excellent communication and collaboration skills, with the ability to work effectively in a team environment.

• BI Tools: Power BI (Desktop, Service), Tableau (Desktop, Server, Online, Prep).

• Data Modelling: Star & Snowflake Schema, Composite Models, RLS, Data Blending
• Cloud Technology: AWS (Redshift, S3, Athena) , Storage S3 Buckets
• Virtualization Layer: Denodo, Dremio, Starburst
• AWS Cloud technology stack (EMR, Redshift, HiveQL, Glue, RDS, etc.)
• Databases: SQL Server , Oracle