Senior Data Engineer
Johnson Controls International plc2 months ago
Warsaw, PolandSenior
Responsibilities
- Design and maintain modular, reusable transformation pipelines in Coalesce.io.
- Build analytics-ready Snowflake models for headcount, attrition, recruiting pipelines, and other workforce metrics.
- Model complex HR data, including employee lifecycles, organizational hierarchies, job and position structures, effective-dated records, and slowly changing dimensions.
- Implement data quality checks and validation logic, investigate metric accuracy issues, and resolve data problems with Integration and Platform teams.
- Write efficient SQL and improve data model and query performance.
- Design data structures aligned with secure consumption patterns.
- Partner with Data Integration Engineers on source systems, especially Workday, and with Data Platform Engineers on access models.
- Translate People Analytics and HR business requirements into data models and standardized metrics.
- Enable self-service analytics through well-documented datasets and maintain clear documentation for model logic.
- Use Azure DevOps and GitHub for version control and CI/CD.
Requirements
- 5+ years of experience in data engineering or analytics engineering.
- Advanced SQL skills, including complex transformations and performance tuning.
- Hands-on experience with Coalesce.io, dbt, or a similar transformation framework.
- Proven experience designing analytics-ready data models that solve business problems at scale.
- Experience with cloud data platforms, preferably Snowflake.
- Strong understanding of dimensional modeling and slowly changing dimensions.
- Preferred experience with workforce or HR data, especially 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.
- Strong collaboration and documentation skills for partnering with Integration, Platform, People Analytics, and HR teams.
Benefits
- Hybrid work arrangement.
- Initial basic salary of 19,600–30,600 PLN per month, with the final offer based on experience, skills, and qualifications.
- Commitment to fair, equitable, and gender-neutral pay practices.
Tech Stack
Categories
Data Engineering
About Johnson Controls International plc
Johnson Controls International plc builds and services building automation, HVAC (York), fire detection/suppression, security, and industrial refrigeration systems for commercial, institutional, and industrial facilities. The NYSE-listed company, headquartered in Cork, Ireland, traces its roots to 1885 and expanded via a 2016 merger with Tyco. It sells equipment, software, and lifecycle services to sectors such as data centers, healthcare, education, and advanced manufacturing, with a global installed base and service footprint.