Data Integration Analyst

Job Summary

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.

• 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 Git Hub and Git Hub 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 elevate potential risks for appropriate review.

• 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.