Overview
Skills
Job Details
Role: Data Architect - HR Data & Analytics
Location: Boston, MA. [Hybrid - 3 days/week to onsite is must and in-person interview is mandatory]
Job Duties:
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. Minimum Skills Required:
At least 12 years Hands-on experience with Slowly Changing Dimensions (SCD Type 2) and historical data management.
At least 10 years Proficiency with data visualization tools such as Tableau or Power BI.
At least 15 years Experience with ELT frameworks (e.g., dbt) and modern data architecture patterns (e.g., Data Vault, Medallion Architecture).
At least 10 years Familiarity with HR processes, compliance standards, and industry best practices related to HR data management and reporting.
At least 10 years Experience working in an enterprise environment with cross-functional collaboration between HR, Finance, and Technology teams
Experience building and supporting data warehouses specifically for HR and People Analytics domains.
Strong experience in Data Architecture, SQL and Python