Data Integration Analyst

Summary: MUFG is one of the world’s leading financial groups, committed to making a difference for every client and community served. The Data Integration Analyst will design, build, and support ETL/data integration solutions, partnering with stakeholders to address data needs and ensure data quality across enterprise HR and related business data. Responsibilities: - 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 Required Qualifications: - 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 - Bachelor's degree in Computer Science or a closely-related discipline, or an equivalent combination of formal education and experience Required Skills: ETL Development, Python Scripting, SQL, Relational Databases, Data Warehousing, Slowly Changing Dimensions (SCDs), Data Security Principles, Microsoft Copilot, System Interface Specifications, APIs, RESTful APIs, Java, React, GitHub, CI/CD Pipelines, Automated Testing Benefits: 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, Paid vacation, Sick days, Holidays