> Markdown version of [/jobs/ext/2520588-senior-data-integration-engineer](https://www.wearedevelopers.com/jobs/ext/2520588-senior-data-integration-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Integration Engineer - **Company:** Johnson Controls - **Location:** Milwaukee, WI, United States - **Experience:** Expert - **Salary:** $100,000.0 - $145,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Microsoft Azure, Cloud Database, Continuous Integration, Information Engineering, Data Infrastructure, Data Integration, Data Integrity, Data Structures, Data Systems, Database Queries, Human Resources Information System (HRIS), Fault Tolerance, Github, Monitoring of Systems, HR Analytics, Raw Data, Workday Integrations, File Transfer Protocol (FTP), Data Ingestion, Workday HCM, Snowflake, SOAPAPI, HR Software, Enterprise Integration, Integration Frameworks, Api Design, Software Version Control, Data Pipelines, Workday - **Published:** August 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=8790b61787760d8d ## About the Role * 5+ years of experience in data engineering or data integration engineering * Strong experience with Fivetran or similar ingestion tools * Experience integrating data via APIs and flat files * Hands-on experience working with Workday integrations or HR data systems * Strong SQL skills and understanding of data structures * Experience building reliable, production-grade data pipelines * Familiarity with cloud data ecosystems (Snowflake preferred) Preferred Qualifications * Deep experience with Workday (HCM, Recruiting, etc.) * Experience handling effective-dated and hierarchical datasets * Exposure to Workforce / People Analytics domains * Familiarity with Azure ecosystem * Experience with data observability/monitoring tools * Understanding of downstream transformation frameworks (Coalesce/dbt) ## Description This role is responsible for acquiring and standardizing data from enterprise systems-especially Workday-into the data platform, using tools such as Fivetran, APIs, and file-based integrations. You will ensure that source data is ingested accurately, reliably, and efficiently to support downstream modeling, analytics, and secure consumption. You will work closely with Data Platform, Data Engineering, and HR systems teams to ensure data is timely, complete, and production-ready., Data Ingestion & Integration Engineering (Core Focus) * Design, build, and maintain scalable ingestion pipelines using: + Fivetran (primary tool) + REST/SOAP APIs + Flat files (SFTP, batch ingestion, vendor extracts) * Integrate data from key enterprise systems, including: + Workday (core HCM, recruiting, etc.) + Other HR, payroll, and workforce-related systems * Ensure ingestion pipelines are robust, efficient, and fault-tolerant Workday & HR Domain Expertise * Develop deep expertise in Workday data structures and integration patterns * Design ingestion strategies for: + Worker data + Job/position structures + Organizational hierarchies + Recruiting and talent data * Handle complexities such as: + Effective-dated data + Hierarchical relationships + Slowly changing attributes Data Reliability & Monitoring * Implement monitoring, alerting, and observability for ingestion pipelines * Ensure data completeness, timeliness, and accuracy * Troubleshoot pipeline failures and data discrepancies at the source level * Partner with upstream system owners to resolve data quality issues Fivetran Optimization & Management * Configure and optimize Fivetran connectors * Manage sync schedules, schema changes, and connector performance * Ensure cost-efficient use of Fivetran * Handle edge cases where custom ingestion is required beyond Fivetran Integration Design & Standards * Define best practices for: + API-based ingestion + File handling and validation + Incremental vs full-load strategies * Establish standards for naming, metadata, and lineage at ingestion layer * Ensure raw data is structured for downstream transformation (Coalesce) CI/CD & Version Control * Implement version control and deployment practices using Azure DevOps / GitHub * Enable repeatable, testable deployment of ingestion pipelines * Document integration logic and configurations Cross-Team Collaboration * Partner with: + Data Platform Engineering (Snowflake readiness, access patterns) + Data Engineers (downstream modeling in Coalesce) + HRIS / Workday teams (source system alignment) * Ensure clean handoffs between ingestion transformation consumption ## Related Videos - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Destigmatizing the Workplace: Building Real Inclusion](https://www.wearedevelopers.com/videos/1492-destigmatizing-the-workplace-building-real-inclusion) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [WeAreDevelopers LIVE - How DevRel Makes Tech More Human](https://www.wearedevelopers.com/videos/2149-wearedevelopers-live-how-devrel-makes-tech-more-human) - [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)