Hybrid HR Data Warehouse Analyst (SQL/Snowflake)

Atrium; Boston (MA); Hybrid; USD 68,000 - 73,000; Full time

Job summary

Atrium is seeking a Business Analyst - HR Data & Data Warehouse to translate business needs into data requirements, design and validate HR metrics within our enterprise data warehouse. The role will collaborate cross-functionally to enhance data quality, governance, and analytics supporting organizational goals.

This hybrid W2 role requires 3–5 years of BA/Data Analyst experience, strong SQL and Snowflake skills, and proficiency in PowerBI/Tableau.

Qualifications

• 3–5 years of experience as a Business Analyst or Data Analyst (or equivalent education/experience).
• Experience with HR systems, HR data models, or enterprise data platforms preferred.
• Prior experience supporting data warehouse, data governance, or metadata initiatives desirable.

Responsibilities

• Support people analytics work streams for workforce data collection, validation, analysis, and reporting.
• Collaborate with HR, IT, and Data Engineering to translate requirements for HR data in the enterprise data warehouse.
• Analyze current data flows and define future-state data flows aligned with HR data governance.
• Translate business needs into technical specs for data modeling, ETL, and data validation.
• Support Snowflake-based data warehouse development with SQL for exploration, profiling and testing.
• Conduct data quality assessments and facilitate issue resolution to ensure HR data integrity.
• Collaborate with HR Data Governance to operationalize data standards and controls.
• Document data mappings and functional specs for clarity and maintainability.
• Assist in evaluating data cataloging/metadata tools to improve discoverability and governance.
• Provide analytical support to HR partners using validated datasets.

Skills

SQL

Snowflake

PowerBI

Tableau

Data analysis

Data validation

Data profiling

Requirements gathering

Communication

Metadata management

Tools

Snowflake

PowerBI

Tableau

Alation

Collibra

Job description

Atrium is seeking a Business Analyst - HR Data & Data Warehouse to translate business needs into data requirements, design and validate HR metrics within our enterprise data warehouse. The role will collaborate cross-functionally to enhance data quality, governance, and analytics supporting organizational goals.

This hybrid W2 role requires 3–5 years of BA/Data Analyst experience, strong SQL and Snowflake skills, and proficiency in PowerBI/Tableau.