Data BA (HR) - - Supporting / Migrating / Transforming HR Project

Data BA (HR) - - Supporting / Migrating / Transforming HR Project

Location: NY / Alpharetta – Hybrid

Role Overview

Defines HR data requirements and validates Snowflake dataset designs across all prioritized Snowflake initiatives — PRISM Historical Data Integration, ER Case Management, Talent Program Nominations, BO Decommission, and AskHR Data Operations — mapping source systems to Snowflake and ensuring governance compliance.

Key Responsibilities

• Define data requirements and acceptance criteria for each prioritized

Snowflake initiative

PRISM Historical Data Integration, ER Case Management, Talent Program Nominations, BO Decommission, and AskHR Data Operations.

• Map source HR data systems (Workday, Dynamics 365/D365, Adobe AEM, Taleo/RDW) to target Snowflake dataset structures for each initiative.

Validate Snowflake datasets against business requirements

data completeness, accuracy, transformation correctness, and entitlement compliance.

• Develop data validation test scenarios for ingestion and integration layers across all five initiatives.
• Support design of Power BI reporting requirements on top of Snowflake datasets for each initiative.
• Collaborate with Snowflake Developers and Java Developer on data integration design and API ingestion patterns.
• Document data dictionaries, lineage maps, and dataset specifications per initiative.
• Ensure all data designs comply with firm data governance, privacy, and access-control standards.
• Manage requirements across multiple parallel data initiatives, maintaining clear prioritization and traceability.

Skills & Experience Required

• 5+ years as a data BA or data analyst in HR data platforms or financial services.

Familiarity with multiple HR data sources

Workday, Dynamics 365, Adobe AEM, Taleo.

• SQL proficiency for data validation, query review, and transformation logic assessment.
• Power BI reporting requirements and semantic layer design experience.
• Ability to manage requirements across multiple parallel data initiatives simultaneously.
• US EST business-hour availability required.

Preferred Qualifications

• Experience with Snowflake data modeling patterns and RBAC security design.
• Background in HR analytics, headcount reporting, or workforce data products.
• Familiarity with BO reporting migration and data lineage analysis.