HR Data Analytics Architect

Key Responsibilities

• Architect & Model :
Design and implement scalable, efficient Snowflake data models to support HR analytics, workforce planning, and KPI reporting.

• Data Integration :
Develop and optimize integrations between Workday, Snowflake, and downstream analytics platforms; ensure seamless, accurate data flow across systems.

• Governance & Quality :
Define and enforce data governance, quality, and metadata management standards to ensure data consistency and compliance.

• Documentation & Metadata :
Maintain comprehensive technical documentation and data dictionaries for warehouse structures, transformations, and integrations.

• Performance Optimization :
Monitor and tune ETL / ELT pipelines, ensuring high-performance data transformation and loading processes.

• Collaboration :
Partner with HR, Data Engineering, and Analytics teams to translate business logic into reusable and governed data assets.

• Testing & Validation :
Participate in unit, integration, and regression testing to validate data pipelines and ensure data accuracy.

• Lifecycle Support :
Support data analysis and troubleshooting across the full implementation and operational lifecycle of HR data solutions.

Required Experience & Skills

• Proven experience architecting and implementing solutions on Snowflake or similar cloud data warehouse platforms.

• Advanced SQL skills and hands-on experience with data transformation and pipeline optimization tools.

• Strong understanding of ETL / ELT frameworks, data validation, and reconciliation techniques.

• Demonstrated experience working with HR data structures, Workday, or other HRIS systems.

• Strong analytical mindset and problem-solving ability, with attention to data integrity and business context.

• Experience with Python for data engineering, automation, or orchestration tasks.

• Track record of designing data warehouses or analytical platforms leveraging HR data to drive insights and advanced reporting.

Preferred Experience & Skills

• Experience building and supporting data warehouses specifically for HR and People Analytics domains.

• Hands-on experience with Slowly Changing Dimensions (SCD Type
2) and historical data management.

• Proficiency with data visualization tools such as Tableau or Power BI.

• Experience with ELT frameworks (e.g., dbt) and modern data architecture patterns (e.g., Data Vault, Medallion Architecture).

• Familiarity with HR processes, compliance standards, and industry best practices related to HR data management and reporting.

• Experience working in an enterprise environment with cross-functional collaboration between HR, Finance, and Technology teams.

#JLjbffr