Data Engineer II

Location: Chicago, Illinois | Duration: Contract

About the role

We are seeking a skilled and experienced Data Engineer II to join our team. This role focuses on the modernization and optimization of analytics data assets related to customer digital journeys and platform reliability. The selected candidate will play a key role in refactoring and optimizing existing Redshift and sandbox data work into scalable, production-grade analytics data products using Databricks and PySpark. While the team currently comes into the office once a week on Tuesdays at Willis Tower, we are flexible and open to fully remote candidates.

Responsibilities

• Refactor and optimize legacy SQL/PySpark logic into modular, scalable pipelines.
• Architect reliable, production-grade analytics data products with strong governance standards.
• Process large-scale data workloads using PySpark and Databricks.
• Collaborate with the core analytics team to create assets for handoff to broader engineering and offshore teams.
• Standardize data product outputs, including schema enforcement and metadata documentation.

Requirements

• Expert-level experience with PySpark and Databricks for large-scale data processing.
• Advanced SQL expertise, particularly in AWS Redshift environments with high-volume queries.
• Proven ability to transition experimental sandbox work into production-ready assets.
• Experience in refactoring legacy SQL/PySpark logic into optimized pipelines.
• Strong communication and partnership skills to work effectively with analytics and engineering teams.

Nice-to-Have Skills

• Experience in travel, e-commerce, logistics, or other fast-paced enterprise-scale environments.
• Familiarity with behavioral analytics, conversion funnels, and performance monitoring metrics.
• Experience working with transactional log sources and complex analytics data structures.
• Ability to enforce naming conventions and metadata documentation for data products.

About PTR Global

PTR Global is a leading provider of information technology and workforce solutions. With over 5,000 professionals, PTR Global delivers services across the U.S. and Canada.

Pay

$50–$55/hour. The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment.

Benefits

Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.