HR Data Analytics Architect Job at SRI Tech Solutions Inc. in Boston

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.