Hybrid Data Engineer III — Azure, SQL & Spark

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

Benefits offered by this job

In-office 3 days/week

Mentorship program

Professional development

Job summary

Preferred Travel Group is seeking a Data Engineer III in Chicago to design, build, and optimize scalable data pipelines. You will collaborate with stakeholders to deliver robust data solutions and mentor junior engineers while driving best practices across the team.

You will work in a hybrid in-office setting with a focus on reliability, performance, and data quality. A strong background in SQL, Python, Spark, and modern ETL tools is essential.

Qualifications

• 5+ years of experience in data engineering or a related field.
• Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
• Strong SQL development and query optimization experience.
• 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.
• Ability to independently manage complex technical work while collaborating across teams.
• Strong written and verbal communication skills.
• Commitment to continuous improvement and knowledge sharing.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL workflows.
• Develop and optimize SQL, Python, and Spark solutions for data processing.
• Build and support integrations using Azure Data Factory, Microsoft Fabric, and APIs.
• Monitor, troubleshoot, and improve reliability and performance of data processes.
• Collaborate with 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

Python

Spark

ETL

Git

Data modeling

Analytical thinking

Communication

Education

Bachelor's degree in CS/IS

Tools

Azure Data Factory

Microsoft Fabric

REST/SOAP APIs

Git

REST APIs

Job description

Preferred Travel Group is seeking a Data Engineer III in Chicago to design, build, and optimize scalable data pipelines. You will collaborate with stakeholders to deliver robust data solutions and mentor junior engineers while driving best practices across the team.

You will work in a hybrid in-office setting with a focus on reliability, performance, and data quality. A strong background in SQL, Python, Spark, and modern ETL tools is essential.