Data Integration Analyst

MUFG•Tempe, AZ

17h•Hybrid

About The Position

The HR Technology Data Integration Analyst designs, builds, and supports production ETL/data integration solutions that move and validate enterprise HR and adjacent business data. The role partners with stakeholders to translate needs into data requirements, troubleshoot integration and data-quality issues, and maintain runbooks and technical documentation while supporting security, compliance, and vendor/AI evaluations. The selected colleague will work at an MUFG office or client sites four days per week and work remotely one day. A member of our recruitment team will provide more details.

Requirements

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 processes, 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.

Nice To Haves

Hands-on experience with Microsoft Copilot and prompt-based AI capabilities.
Experience in the financial services industry.

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.