Senior Data Engineer
Johnson Controls International plc2 months ago
Budapest, HungarySenior
Responsibilities
- Design and maintain modular, reusable transformation pipelines in Coalesce.io.
- Build analytics-ready Snowflake models for headcount, attrition, recruiting pipelines, and other workforce analytics use cases.
- Apply layered data architecture from raw through staging to curated datasets.
- Model complex HR data, including employee lifecycles, organizational hierarchies, job and position structures, recruiting pipelines, effective-dated data, slowly changing dimensions, and point-in-time reporting.
- Implement data quality checks and validation logic, resolve data issues, and ensure the accuracy of workforce metrics.
- Write efficient SQL and improve data model and query performance.
- Design structures aligned with secure data 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 documented datasets.
- Use Azure DevOps and GitHub for version control and CI/CD, and maintain documentation for models and logic.
Requirements
- 5+ years of experience in data engineering or analytics engineering.
- Strong SQL skills, including advanced transformations and performance tuning.
- Hands-on experience with Coalesce.io, dbt, or a similar transformation framework.
- A proven track record designing analytics-ready data models that solve business problems at scale.
- Experience with cloud data platforms, with Snowflake preferred.
- Solid understanding of data modeling concepts, including dimensional modeling and slowly changing dimensions.
- Preferred: experience with workforce or HR data, especially Workday.
- Preferred: experience modeling effective-dated and hierarchical data.
- Preferred: exposure to People Analytics use cases.
- Preferred: familiarity with data quality frameworks.
- Preferred: experience working with sensitive or personally identifiable information.
Benefits
- Initial basic salary of 1 462 500 - 2 285 166 HUF per month.
- Hybrid work arrangement, as indicated by the #LI-Hybrid designation.
- Final offer reflects relevant 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.