Duties:
- 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 strong 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
Requirements:
- 5+ years of hands-on data engineering experience (solid “III” level; deeper experience is the key differentiator vs. DE II)
- Advanced SQL skills, including writing and optimizing complex queries across relational databases (SQL Server required; PostgreSQL is a strong plus)
- Strong Python experience building and maintaining ETL routines/pipelines
- Proven ETL architecture experience (designing, improving, and simplifying pipelines to make delivery easier and more scalable)
- Strong software engineering fundamentals (experience with languages like C# is transferable; ability to work in structured codebases, troubleshoot issues, and improve performance)
Salary Range: $100,000–$120,000 + (based on level and experience)
Ready to step into a role where your work will directly improve scalability, speed, and decision-making? Apply today.
Allied OneSource is connecting great people with great opportunities.

