Senior Data Engineer III — Pipelines & Azure

Preferred Travel Group; Chicago (IL); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Preferred Travel Group is seeking a Data Engineer III in Chicago to design, build, and optimize scalable data pipelines powering business operations. The role emphasizes collaboration with stakeholders and engineering teams to deliver reliable data solutions.

The ideal candidate has 5+ years in data engineering, strong SQL, Python, and ETL skills, and experience with Azure Data Factory and Microsoft Fabric. Hybrid in-office schedule with remote flexibility supports team-driven innovation.

Qualifications

• 5+ years of experience in data engineering or related field.
• Bachelor's degree in CS/IS or equivalent.
• Strong SQL development and query optimization.
• Experience with Python and modern ETL/orchestration tools.
• Experience with Microsoft Azure, Microsoft Fabric, or similar cloud data platforms.
• Experience using Git and collaborative software development practices.
• Strong understanding of data modeling and ETL concepts.
• Strong analytical and problem-solving abilities.
• Strong written and verbal communication skills.
• Ability to independently manage complex technical work while collaborating across teams.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL workflows.
• Develop and optimize advanced SQL, Python, and Spark solutions for data processing.
• Build and support integrations using Azure Data Factory, Microsoft Fabric, and REST/SOAP APIs.
• Monitor, troubleshoot, and improve the reliability and performance of production data processes.
• Collaborate with business stakeholders to gather requirements and deliver data solutions.
• Participate in code reviews and maintain technical documentation.
• Mentor junior engineers and contribute to engineering best practices.

Skills

SQL development

Python

Data modeling

Communication

Problem solving

Education

Bachelor's degree in CS/IS or equivalent

Tools

Azure Data Factory

Microsoft Fabric

REST APIs

dbt

Git

Spark

Job description

Preferred Travel Group is seeking a Data Engineer III in Chicago to design, build, and optimize scalable data pipelines powering business operations. The role emphasizes collaboration with stakeholders and engineering teams to deliver reliable data solutions.

The ideal candidate has 5+ years in data engineering, strong SQL, Python, and ETL skills, and experience with Azure Data Factory and Microsoft Fabric. Hybrid in-office schedule with remote flexibility supports team-driven innovation.