Data Engineer II

Position: Data Engineer II
Location: Chicago, Illinois
Duration: Contract
Job ID: 178844

Job Overview:
We are seeking a skilled and experienced Data Engineer II to join our team. This role is tied to 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.

• 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.

• 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. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com

At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:

• Pay any fee to be considered for, submitted to, or selected for any opportunity.
• Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
• Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.

Pay Range: $50-$55/hr

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. 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.

If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 214-740-2424. To report any concerns, please email us at legal@pinnacle1.com

During the hiring process, we may use artificial intelligence (AI) tools to assist in evaluating information related to your application. These tools may help analyze job-related qualifications or assist recruiters in reviewing applications and interview responses. AI-generated information is one factor considered in our hiring process. Final employment decisions are made by qualified hiring personnel and are not based solely on AI-generated recommendations.
 

#LI-Remote #LI-YP1