Data Engineer

Johnson Controls; United States; Remote; USD 42,000 - 66,000; Full time

Benefits offered by this job

Обеденные ваучеры

Гибкий пакет льгот

MultiSport карта

Семейная поддержка (детский сад)

Удаленная работа / гибрид

Помощь с релокацией

Job summary

Johnson Controls приглашает старшего инженера по данным для проектирования и поддержки основных моделей данных и трансформационных пайплайнов на платформе Snowflake с использованием Coalesce.io. Вы будете формировать workforce метрики, обеспечивать качество данных и доверительную аналитику для HR и руководителей.

Требуется 5+ лет опыта в data engineering, сильные SQL навыки и опыт работы с облачными платформами.

Qualifications

• Опыт работы в data engineering не менее 5 лет.
• Продвинутые навыки SQL.
• Опыт работы с фреймворками трансформации данных (Coalesce.io, dbt или аналогичные).
• Опыт создания аналитически пригодных моделей данных.
• Опыт работы с облачными платформами (Snowflake предпочтителен).
• Глубокое понимание концепций моделирования данных (dimensional, SCD).
• Опыт работы с Workforce/HR данными (Workday предпочтителен).

Responsibilities

• Проектирование, разработка и сопровождение основных моделей данных и преобразующих пайплайнов.
• Преобразование неструктурированных данных в аналитически пригодные наборы в Snowflake через Coalesce.io.
• Определение и поддержка KPI по персоналу, обеспечение качества данных.
• Сотрудничество с инженерами интеграций и платформы для обеспечения безопасности и доступа.

Skills

SQL

Data pipelines

Coalesce.io

dbt

Snowflake

Data modeling

SCDs

Workday

Tools

Coalesce.io

dbt

Snowflake

Job description

Задачи: We are seeking a Senior Data Engineer to design, build, and maintain the core data models and transformation pipelines that power Workforce Analytics. This role is responsible for transforming raw, ingested data into clean, well-structured, and analytics-ready datasets in Snowflake, using Coalesce.io as the primary transformation framework. You will play a critical role in defining workforce metrics, ensuring data quality, and enabling trusted insights across HR, analytics, and business leadership. You will work closely with Data Integration Engineers (data ingestion) and Data Platform Engineers (data access and security) to deliver a scalable, high-quality data ecosystem. Data Transformation & Modeling (Core Focus)

Design, build, and maintain data transformation pipelines in Coalesce.io

Develop analytics-ready data models in Snowflake (e.g., headcount, attrition, recruiting pipelines)

Apply best practices for: Modular, reusable transformations Clear layer separation (raw → staging → curated) Maintainable and scalable model design

Workforce Data Modeling

Model complex Workforce / HR datasets, including: Employee lifecycle (hire → transfer → termination) Organizational hierarchies Job and position structures Recruiting pipelines

Handle challenges such as: Effective-dated data Slowly changing dimensions Point-in-time reporting Data Quality & Reliability

Implement and maintain data quality checks and validation logic

Ensure consistency and accuracy of key workforce metrics

Investigate and resolve data issues in partnership with Integration and Platform teams

Build trust in enterprise workforce datasets

Snowflake Optimization (Data Layer)

Write efficient and optimized SQL for transformation pipelines

Improve performance of models and downstream queries

Design data structures that align with secure consumption patterns defined by the platform

Cross-Team Collaboration

Partner with Data Integration Engineers to: Understand source system structures (especially Workday) Ensure proper ingestion and schema alignment

Partner with Data Platform Engineers to: Align on access models and consumption layers

Support secure and scalable data usage

Business Enablement

Translate business requirements from People Analytics and HR stakeholders into data models

Define and standardize workforce metrics and business logic

Enable self-service analytics through consistent and well-documented datasets

CI/CD & Development Practices

Use Azure DevOps / GitHub for version control and deployment

Support CI/CD workflows for transformation pipelines

Maintain documentation for models, logic, and data definitions

What we look for

Required 5+ years of experience in data engineering

Strong SQL skills (advanced transformations, performance tuning)

Hands-on experience with data transformation frameworks (Coalesce.io, dbt, or similar)

Experience building and maintaining analytics-ready data models

Experience working with cloud data platforms (Snowflake preferred)

Strong understanding of data modeling concepts (dimensional, SCDs, etc.)

Требования:

Experience with Workforce / HR data (Workday strongly preferred)

Experience modeling effective-dated and hierarchical data

Exposure to People Analytics use cases and metrics

Familiarity with data quality frameworks and testing approaches

Experience working in environments with sensitive/PII data

Условия:

The initial basic salary for this position will be in the range of €3,346 - €5,230 per month, plus a 13th month salary applied after your first 6 months in the job.

The final package will reflect your experience, skills, and qualifications relevant to the role.

We are committed to fair, equitable, and gender-neutral pay practices.

At Johnson Controls, your work comes with benefits that support both your career and your wellbeing.

Meal vouchers fully covered by the company.

Flexible benefits budget with access to 3,500+ options, including a MultiSport card, medical and wellness services.

Extra savings through retail and lifestyle discounts (Benefit+).

Allowance for the private kindergarten or nursery to support your family.

Flexible working hours and home office days.

Allowance for language courses, professional development support, and wellbeing support.

On site benefits: massages, distribution of fruits, yoga, psychologist, health month, various events with supporting groups (volunteering activities, branding activities).

Seniority benefits - extra monthly financial allowance, medical care and support, wellbeing day.

Relocation support with housing allowance if moving to Slovakia 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.