Sr. Data Integration Engineer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Milwaukee, WI, US

3 days ago Requisition

Salary Range: $ To $ Annually

Summary

The Senior Data Integration Engineer is responsible for the design, development, and operation of the data integration and ingestion processes that deliver partner and internal data into our analytics environment. The role owns the flow of data from source acquisition through the curated data warehouse tables consumed by reporting platforms, operational systems, and business analysts.

This is a senior, hands-on engineering position spanning the full integration lifecycle: acquiring data from a wide range of external partner and internal systems, validating and conditioning that data on arrival, transforming it into the structures that support analysis and operations, and operating those processes reliably in production. The role is concerned equally with building new integrations and with the continued performance, accuracy, and timeliness of those already in service.

A central objective of the position is to advance reusable, well-instrumented integration patterns that shorten the time required to onboard new data sources and that improve the reliability and transparency of data delivery to the business. The Senior Data Integration Engineer will also contribute substantially to the planned modernization of our data platform, evaluating and recommending tooling, architecture, and migration approach for leadership consideration.

The role sets technical direction and development standards for data integration work and collaborates closely with data architects, business analysts, stakeholders across the organization, and the technical contacts of our external data partners.

Essential Duties and Responsibilities

This list of duties and responsibilities is not all inclusive and may be expanded to include other duties and responsibilities as management may deem necessary from time to time.

• Design, develop, and maintain data integration processes that acquire data from partner and internal sources, including flat file transfers over SFTP, REST API endpoints, and direct database connections.
• Develop reusable, configuration-driven ingestion patterns that reduce the effort and elapsed time required to onboard new partner data feeds.
• Develop and maintain the T‑SQL transformation logic that carries data from landing and staging layers through to the curated warehouse tables supporting reporting, operational systems, and analyst queries.
• Design ingestion processes to be idempotent and safely re‑runnable, incorporating automated retry and restart behavior for failed executions.
• Implement automated validation and quarantine processes so that records failing business‑defined quality rules are isolated, reported, and prevented from reaching downstream consumers.
• Implement data quality rules defined by the business, including schema validation, reconciliation, row count and threshold checks, and anomaly detection.
• Establish monitoring, logging, and alerting for pipeline execution state, data freshness, and load completion, and automate the communication of ingestion status to stakeholders.
• Diagnose and resolve production data incidents, determine root cause, coordinate remediation, and document preventive measures through runbooks and post‑incident review.
• Contribute to dimensional data model design in collaboration with the data architect and senior team members.
• Establish and maintain version control, code review, and repeatable deployment practices for database and pipeline code.
• Define and uphold development standards for data integration work…