Data Architect - HRIS

Job Title: Sr. Data Architect- HR Data & Analytics Location: Boston – Hybrid (4 days from office) Duration: 6 - 12+ Months Notes : Snowflake,ETL/ELT, HRIS, SQL, Python. Role Overview The Data Architect will play a key role in designing and implementing the enterprise HR data architecture to support HR analytics, KPIs, and reporting initiatives. This role involves translating complex business requirements into scalable, governed data solutions built on Snowflake and integrated with Workday and other HR systems. The ideal candidate will combine deep technical expertise with a strong understanding of HR data domains, ensuring data integrity, accessibility, and analytical value across the organization. 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.