Data Integration, ETL - Analyst

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.

• Demonstrate a strong interest in enterprise business data and processes—preferably across HR, Corporate Communications, Legal, Project Portfolio Management, and Compliance—by asking thoughtful questions to understand business needs and translating them into clear data and technology requirements.
• Design, develop, and support ETL and data integration solutions in a production environment, including batch scheduling, monitoring, and incident response.
• Perform data validation and reconciliation using SQL; analyze data quality issues and partner with upstream and downstream teams to resolve source‑to‑target discrepancies.
• Create and maintain knowledge articles, operating standards, runbooks, and technical documentation to support ongoing operations, audits, and compliance reviews.
• Translate technical and architectural concepts into clear, concise updates and materials for internal business and technology stakeholders.
• Troubleshoot application, integration, and data issues; perform root‑cause analysis; and coordinate resolution with internal teams and external vendors.
• Coordinate work across U.S.‑ and India‑based partners (such as service desk, engineering, and vendor support teams), tracking progress, risks, dependencies, and delivery milestones.
• Support SaaS vendor evaluations and demonstrations by gathering requirements, documenting findings, and assisting with fit‑gap analysis across business needs, technology capabilities, security posture, and compliance requirements.
• Assist with build‑versus‑buy analysis by documenting requirements and supporting proof‑of‑concept efforts to replace select vendor‑hosted (SaaS) capabilities with in‑house solutions, under guidance from senior engineers.
• Contribute to internal data and workflow tools by writing and maintaining code, unit tests, and documentation using GitHub and GitHub Copilot, following established development patterns, peer‑review processes, and secure coding standards.
• Support the responsible adoption of AI‑enabled solutions by documenting use cases, assisting with governance requirements, and helping evaluate opportunities to improve business and technology processes.
• Assist in assessing AI capabilities within existing applications compared to enterprise‑provided Microsoft Copilot capabilities; document vendor security controls and guardrails, and escalate potential risks for appropriate review.

• Bachelor’s degree in Information Systems, Computer Science, or a related field, or equivalent professional experience.
• 1–2 years of experience in the financial services industry (preferred).
• Experience as an ETL Analyst with hands‑on exposure to ETL development, Python scripting, and relational databases.
• Solid understanding of data warehousing and ETL concepts, including fact and dimension tables, star and snowflake schemas, full versus incremental loads, and Slowly Changing Dimensions (SCDs).
• 1–2 years of hands‑on experience using SQL and relational databases for ETL development, data analysis, validation, and troubleshooting.
• Proven exposure to data security principles, technology controls, and regulatory or compliance imperatives within a production environment.
• Familiarity with Microsoft Copilot and prompt‑based AI capabilities; hands‑on experience is preferred.
• Ability to create and interpret system interface specifications, data mappings, and end‑to‑end process designs.
• Basic understanding of software architecture concepts, including APIs and services, data stores, authentication and authorization mechanisms, and logging and monitoring, and how these components interact within a production system.
• Exposure to common application patterns such as RESTful APIs, authentication fundamentals, and SQL query patterns used by Java‑ and Python‑based services.
• Familiarity with a modern product stack, including Java and/or Python for back‑end services and APIs, React for front‑end user interfaces, and SQL for data access; understanding the typical artifacts required to build and deploy internal products (source code, configuration, CI/CD pipelines, and automated tests).
• Working knowledge of Git‑based version control systems (GitHub) and comfort using developer tools such as IDEs and command‑line interfaces; ability to use GitHub Copilot to assist with Java, Python, React, and SQL development while validating outputs through testing, peer review, and secure coding and compliance standards.
• Strong analytical, problem‑solving, and decision‑making skills, with close attention to detail.
• Strong verbal, written, and presentation skills, with the ability to communicate effectively with both technical and non‑technical audiences.