Senior Data Engineer: Workforce Analytics & Snowflake

YDU JC Air Cond & Ref Inc.- Dubai; Warszawa; Hybrid; PLN 219,000 - 341,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Johnson Controls is seeking a Data Engineer or Data Analyst to design, develop, and scale robust data models for Workforce Analytics. You will turn ingested HR data into analytics-ready datasets in Snowflake using Coalesce.io, partnering with Integration and Platform Engineers.

You will model employee lifecycle data, ensure data quality, optimize performance, and enable self-service analytics through well-documented datasets, with CI/CD via Azure DevOps/GitHub.

Qualifications

• 5+ years of experience in data engineering or analytics engineering.
• Strong SQL skills (advanced transformations, performance tuning).
• Hands-on experience with transformation frameworks (Coalesce.io, dbt, or similar).
• Proven track record designing analytics-ready data models that solve business problems at scale.
• Experience with cloud data platforms (Snowflake preferred).
• Solid understanding of data modeling concepts (dimensional modeling, SCDs).

Responsibilities

• 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.
• 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.
• Implement data quality checks and validation logic.
• Ensure accuracy of key workforce metrics; resolve data issues with Integration and Platform teams.
• Write efficient, optimized SQL; improve model and query performance.
• Collaborate with Integration Engineers on source systems (especially Workday) and Platform Engineers on access models.
• Translate business requirements from People Analytics/HR into data models and standardized metrics.
• Enable self-service analytics through well-documented datasets.
• Use Azure DevOps/GitHub for version control and CI/CD.
• Maintain clear documentation for models and logic.

Skills

SQL

Data modeling

Snowflake

Coalesce.io

dbt

Tools

Coalesce.io

dbt

Snowflake

Job description

Johnson Controls is seeking a Data Engineer or Data Analyst to design, develop, and scale robust data models for Workforce Analytics. You will turn ingested HR data into analytics-ready datasets in Snowflake using Coalesce.io, partnering with Integration and Platform Engineers.

You will model employee lifecycle data, ensure data quality, optimize performance, and enable self-service analytics through well-documented datasets, with CI/CD via Azure DevOps/GitHub.