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
Required
- 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.
#LI-DD1
#LI-Hybrid
Skills Required
- 5+ years of experience in data engineering or analytics engineering
- Strong SQL skills, including advanced transformations and performance tuning
- Hands-on experience with transformation frameworks such as Coalesce.io, dbt, or similar
- Experience designing analytics-ready data models that solve business problems at scale
- Experience with cloud data platforms; Snowflake preferred
- Understanding of data modeling concepts, including dimensional modeling and slowly changing dimensions
- Experience with workforce or HR data, particularly Workday
- Experience modeling effective-dated and hierarchical data
- Exposure to People Analytics use cases
- Familiarity with data quality frameworks
- Experience working with sensitive or personally identifiable information data
Johnson Controls Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Johnson Controls and has not been reviewed or approved by Johnson Controls.
-
Retirement Support — Retirement support is positioned as a meaningful part of the package through employer 401(k) matching, repeatedly framed as a strong pillar of the overall rewards mix. The matching contribution is described with specific match levels in multiple places, reinforcing perceived value for long-term saving.
-
Leave & Time Off Breadth — Time off is presented as comparatively robust, with multiple paid holiday categories, vacation time, and sick time described as generous or “amazing” in places. Paid time off breadth appears to be a consistent contributor to total rewards attractiveness beyond base pay.
-
Flexible Benefits — Benefits are described as broad and customizable, spanning standard medical/dental/vision plus optional add-ons like pet insurance, identity protection, and legal support. Tuition reimbursement is repeatedly highlighted as a high-value option supporting professional development.
Johnson Controls Insights
What We Do
At Johnson Controls, we transform the environments where people live, work, learn and play. From optimizing building performance to improving safety and enhancing comfort, we drive the outcomes that matter most. Dedicated to protecting the environment, we deliver our promise in industries such as healthcare, education, data centers and manufacturing. With a global team of 100,000 experts in more than 150 countries and over 130 years of innovation, we are the power behind our customers’ mission. Our leading portfolio of building technology and solutions includes some of the most trusted names in the industry, such as Tyco®, York®, Metasys®, Ruskin®, Titus®, Frick®, Penn®, Sabroe®, Simplex®, Ansul® and Grinnell®.
