Senior Data Engineer

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

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 model and query performance
• Design structures aligned with secure consumption patterns

Collaboration & Business Enablement

• Partner 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

Development Practices

• Use Azure DevOps/GitHub for version control and CI/CD
• Maintain clear documentation for models and logic

What we look for

• 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)

Preferred

• Experience with Workforce/HR data (Workday strongly preferred)
• Experience modeling effective-dated and hierarchical data
• Exposure to People Analytics use cases
• Familiarity with data quality frameworks
• Experience working with sensitive/PII data

Our salary

The initial basic salary for this position will be in the range of 19,600 - 30,600 PLN per month. The final offer will reflect your experience, skills, and qualifications relevant to the role. We are committed to fair, equitable, and gender-neutral pay practices.

About Us

Johnson Controls, a global leader in thermal management, mission-critical building systems, energy efficiency, and decarbonization, helps customers use energy more productively, reduce carbon emissions, and operate with the precision and resilience required in rapidly expanding industries such as data centers, healthcare, pharmaceuticals, advanced manufacturing, and higher education. For more than 140 years, Johnson Controls has delivered performance where it really matters. Backed by advanced technology, lifecycle services and an industry-leading field organization, we elevate customer performance, turn goals into real-world results and help move society forward. We are committed to diversity and inclusion and believe that different perspectives make us stronger. By encouraging open dialogue and valuing individuality, we strive to be one of the most desirable places to work.

Johnson Controls: Enhancing the Intelligence of Buildings

Your buildings have a purpose. They are places for people to live or work. Facilities for learning or healing. Venues for entertainment and shopping. Sites for the specialized storage of tangible goods or mission-critical data. Your buildings have a huge variety of functions; they are central to your mission. This is where Johnson Controls comes in, helping drive the outcomes that matter most. Through a full range of systems and digital solutions, we make your buildings smarter. A smarter building is safer, more comfortable, more efficient, and, ultimately, more sustainable. Most important, smarter buildings let you focus more intensely on your unique mission. Better for your people. Better for your bottom line. Better for the planet. At Johnson Controls, we’ve been making buildings smarter since 1885, and our capabilities, depth of innovation experience, and global reach have been growing ever since. Today, we offer the world’s largest portfolio of building products, technologies, software, and services; we put that portfolio to work to transform the environments where people live, work, learn and play.

#LI-DD1 #LI-Hybrid