Job description

• Candidates with financial background is preferred. Role Overview Defines and validates the HR data layer for the E360 RIF module, mapping Workday and upstream HR data sources to Snowflake datasets that power the E360 roster, list management, and reporting capabilities. Ensures data integrity, entitlement compliance, and reporting-readiness across the full RIF workflow. Key Responsibilities  Define HR data requirements for the E360 RIF module: employee attributes, RIF selection fields, and enrichment data points (selection rationale, severance indicators, role elimination flags, communicator assignment).  Map source HR data (Workday, via DDP) to target Snowflake dataset structures required for E360 RIF roster views and decision support.  Validate Snowflake datasets against business requirements — data completeness, accuracy, row-level security, and entitlement compliance.  Develop and execute data validation test cases for both ingestion (DDP → Snowflake) and consumption (Snowflake → E360) layers.  Collaborate with the Snowflake Developer to define data models, transformation logic, and write-back patterns for RIF data enrichment.  Support design of Adverse Impact / Legal reporting datasets (demographic composition of affected vs. retained populations).  Ensure all data designs comply with firm data governance, privacy, and access-control standards.  Document data dictionaries, lineage maps, and Snowflake dataset specifications for each RIF data domain.  Partner with Business Analyst to ensure data requirements align with business process and workflow specifications. Skills & Experience Required  5+ years as a data-focused BA or data analyst in HR technology or financial services.  Strong knowledge of HR data domains: workforce, compensation, headcount, and talent.  Experience with Snowflake data modeling and dataset validation.  Familiarity with Workday and API-based HR data distribution patterns (DDP / Apigee).  SQL proficiency for data validation, query review, and transformation logic assessment.  Experience with Power BI reporting requirements and semantic layer design.  US EST business-hour availability required; preferred location: NY / Montreal / Alpharetta. Preferred Qualifications  Experience supporting compliance-sensitive data environments (RBAC, row-level security, audit trails).  Familiarity with Adverse Impact analysis and legal/regulatory HR reporting requirements.  Background in workforce reduction or headcount analytics data products.

Requirements

Must-haves

Defines and validates the HR data layer for the E360 RIF module, mapping Workday and upstream HR data
sources to Snowflake datasets that power the E360 roster, list management, and reporting capabilities.
Ensures data integrity, entitlement compliance, and reporting-readiness across the full RIF workflow.
 Define HR data requirements for the E360 RIF module: employee attributes, RIF selection fields, and
enrichment data points (selection rationale, severance indicators, role elimination flags, communicator
assignment).
 Map source HR data (Workday, via DDP) to target Snowflake dataset structures required for E360 RIF
roster views and decision support.
 Validate Snowflake datasets against business requirements — data completeness, accuracy, row-level
security, and entitlement compliance.
 Develop and execute data validation test cases for both ingestion (DDP → Snowflake) and consumption
(Snowflake → E360) layers.
 Collaborate with the Snowflake Developer to define data models, transformation logic, and write-back
patterns for RIF data enrichment.
 Support design of Adverse Impact / Legal reporting datasets (demographic composition of affected vs.
retained populations).
 Ensure all data designs comply with firm data governance, privacy, and access-control standards.
 Document data dictionaries, lineage maps, and Snowflake dataset specifications for each RIF data
 Partner with Business Analyst to ensure data requirements align with business process and workflow

Nice-to-haves

Candidates with financial background is preferred.
 US EST business-hour availability required; preferred location: NY / Montreal / Alpharetta.
 Experience supporting compliance-sensitive data environments (RBAC, row-level security, audit trails).
 Familiarity with Adverse Impact analysis and legal/regulatory HR reporting requirements.
 Background in workforce reduction or headcount analytics data products.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

apisql

Platform: careers-browser
Effort: medium