Staff Data Engineer - UMER Platforms

Johnson Controls•Milwaukee, WI

2d•$89,000 - $134,000•Hybrid

About The Position

Build your best future with the Johnson Controls team As a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet. Join a winning team that enables you to build your best future! Our teams are uniquely positioned to support a multitude of industries across the globe. You will have the opportunity to develop yourself through meaningful work projects and learning opportunities. We strive to provide our employees with an experience, focused on supporting their physical, financial, and emotional wellbeing. Become a member of the Johnson Controls family and thrive in an empowering company culture where your voice and ideas will be heard – your next great opportunity is just a few clicks away! What we offer: Competitive salary Paid vacation/holidays/sick time Comprehensive benefits package including 401K, medical, dental, and vision care On the job/cross training opportunities Encouraging and collaborative team environment Dedication to safety through our Zero Harm policy What you will do: Develop, enhance, and maintain .NET Framework and .NET Core applications, including APIs, backend services, and business‑critical workflows. Troubleshoot application issues, implement new features, refactor legacy code, and ensure high‑quality development practices through code reviews and standards. Manage CI/CD pipelines, deployments, and configuration using Azure DevOps and IIS. Provide hands‑on production support for .NET applications, SQL Server databases, and data pipelines, ensuring high availability and timely resolution of incidents. Monitor application and data pipeline health, investigate alerts, perform root‑cause analysis, and implement long‑term corrective actions. Support on‑call rotations and collaborate with cross‑functional teams to maintain operational stability and performance. Analyze logs, failure points, and upstream/downstream data flows to quickly diagnose and resolve issues. Analyze operational and source data to implement and maintain Slowly Changing Dimensions (SCD Type 2), including change detection, historization, and surrogate key management. Build and optimize SQL Server, SSIS, and Snowflake/ADF pipelines to capture attribute changes accurately and maintain a complete historical record. Perform data profiling, validation, and reconciliation to ensure data quality and trustworthy analytical outputs. Snowflake Architecture & Modeling: Develop data models (star/snowflake schemas) and database objects (views, tables, stored procedures, user-defined functions) in Snowflake.

Requirements

C# / .NET programming
SQL / T‑SQL proficiency
SSIS fundamentals
IIS application hosting basics
Production support + troubleshooting
Data warehousing basics
SCD Type 2 change tracking concepts
Azure + DevOps basics (pipelines, repos, deployments)
Cloud Platforms: Experience with Snowflake/Azure cloud environments.
Minimum 5+ years of Relevant Experience.
Bachelor’s or master’s degree in computer science, Data Engineering, or related field.
Proven experience as a Application Data Support Engineer.

Responsibilities

Develop, enhance, and maintain .NET Framework and .NET Core applications, including APIs, backend services, and business‑critical workflows.
Troubleshoot application issues, implement new features, refactor legacy code, and ensure high‑quality development practices through code reviews and standards.
Manage CI/CD pipelines, deployments, and configuration using Azure DevOps and IIS.
Provide hands‑on production support for .NET applications, SQL Server databases, and data pipelines, ensuring high availability and timely resolution of incidents.
Monitor application and data pipeline health, investigate alerts, perform root‑cause analysis, and implement long‑term corrective actions.
Support on‑call rotations and collaborate with cross‑functional teams to maintain operational stability and performance.
Analyze logs, failure points, and upstream/downstream data flows to quickly diagnose and resolve issues.
Analyze operational and source data to implement and maintain Slowly Changing Dimensions (SCD Type 2), including change detection, historization, and surrogate key management.
Build and optimize SQL Server, SSIS, and Snowflake/ADF pipelines to capture attribute changes accurately and maintain a complete historical record.
Perform data profiling, validation, and reconciliation to ensure data quality and trustworthy analytical outputs.
Snowflake Architecture & Modeling: Develop data models (star/snowflake schemas) and database objects (views, tables, stored procedures, user-defined functions) in Snowflake.