Data Architect HR Data & HRIS Analytics (Onsite)

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.