Senior Data Engineer: Workforce Analytics & Snowflake

Johnson Controls, Inc.; Warszawa; Hybrid; PLN 219,000 - 341,000; Full time

Job summary

Johnson Controls, Inc. is seeking a Data Engineer or Data Analyst to design, develop, and scale workforce analytics data models in Snowflake using Coalesce.io. You will turn raw data into analytics-ready datasets and partner with Data Integration and Platform Engineers to deliver a trusted data ecosystem for HR and leadership.

The role emphasizes data modeling, ETL pipelines, data quality, and performance optimization in large-scale organizations, with a hybrid work model in Warszawa.

Qualifications

• 5+ years of experience in data engineering or analytics engineering.
• Strong SQL skills with advanced transformations.
• Experience with transformation frameworks like Coalesce.io or dbt.

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; resolve data issues with Integration and Platform teams.
• Write efficient, optimized SQL; improve model and query performance; design secure consumption patterns.
• Partner with Integration Engineers on source systems (Workday) and Platform Engineers on access models; translate requirements into data models and metrics.
• Use Azure DevOps/GitHub for version control and CI/CD; maintain documentation for models and logic.

Skills

SQL

Data modeling

dbt

Coalesce.io

Snowflake

Tools

Coalesce.io

dbt

Snowflake

Job description

Johnson Controls, Inc. is seeking a Data Engineer or Data Analyst to design, develop, and scale workforce analytics data models in Snowflake using Coalesce.io. You will turn raw data into analytics-ready datasets and partner with Data Integration and Platform Engineers to deliver a trusted data ecosystem for HR and leadership.

The role emphasizes data modeling, ETL pipelines, data quality, and performance optimization in large-scale organizations, with a hybrid work model in Warszawa.