Senior Data Engineer: Scalable ETL Pipelines

Allied OneSource; Kansas City (MO); Hybrid; USD 125,000 - 130,000; Full time

Job summary

Allied OneSource is seeking a Data Engineer III/IV to build and optimize scalable ETL pipelines in a mostly in-house, hybrid environment. You will help improve ETL architecture, optimize performance, and strengthen data quality across critical systems as data volume grows.

The role requires 5+ years in data engineering, strong SQL (SQL Server) and Python skills, and experience with ETL architecture. Collaboration with engineers, architects, actuaries, and analysts is essential.

Qualifications

• 5+ years hands-on data engineering experience.
• Advanced SQL skills across relational databases (SQL Server required; PostgreSQL a plus).
• Strong Python experience building ETL pipelines.
• Proven ETL architecture experience (designing, improving, and simplifying pipelines).
• Strong software engineering fundamentals; experience with languages like C# is transferable.

Responsibilities

• Build, improve, and maintain scalable ETL pipelines to support increasing inbound data volume.
• Develop and optimize SQL queries and data transformations for performance, reliability, and accuracy.
• Partner with software engineers, architects, actuaries, and analysts to translate business needs into data solutions.
• Assemble and manage large, complex datasets that meet functional and non-functional requirements (security, scalability, reliability).
• Create and maintain documentation, follow change management, and perform quality checks on business-impacting processes.

Skills

SQL

Python

C#

ETL pipelines

Data quality

Tools

SQL Server

PostgreSQL

Job description

Allied OneSource is seeking a Data Engineer III/IV to build and optimize scalable ETL pipelines in a mostly in-house, hybrid environment. You will help improve ETL architecture, optimize performance, and strengthen data quality across critical systems as data volume grows.

The role requires 5+ years in data engineering, strong SQL (SQL Server) and Python skills, and experience with ETL architecture. Collaboration with engineers, architects, actuaries, and analysts is essential.