Senior Data Engineer

What You Will Do

We are looking for a Data Engineer or Data Analyst with a proven track record of designing, developing, and scaling robust data models that enable impactful Workforce Analytics and insights.

You will turn raw, ingested data into clean, trusted, analytics-ready datasets in Snowflake using Coalesce.io. This role is ideal for someone who has designed data models that solve real business problems in complex, large-scale organizations — balancing structure, flexibility, and scalability.

You'll partner closely with Data Integration Engineers (ingestion) and Data Platform Engineers (access & security) to deliver a scalable, high-quality data ecosystem for HR and business leadership.

How You Will Do It

Data Modeling & Transformation

• Design and maintain modular, reusable transformation pipelines in Coalesce.io • Build analytics-ready Snowflake models (headcount, attrition, recruiting pipelines) • Apply best practices for layered architecture (raw → staging → curated) and scalable model design

Workforce Data Complexity

• Model complex HR datasets: employee lifecycle, org hierarchies, job/position structures, recruiting pipelines • Handle effective-dated data, slowly changing dimensions, and point-in-time reporting

Data Quality & Trust

• Implement data quality checks and validation logic • Ensure accuracy of key workforce metrics; resolve data issues with Integration and Platform teams

Performance & Optimization

• Write efficient, optimized SQL; improve…