Data Engineer - Senior Associate

PricewaterhouseCoopers Advisory Services LLC

Chicago (IL)

On-site

USD 77,000 - 202,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical
Dental
Vision
401k
Holiday pay
Vacation
Sick leave

Job summary

PwC in Chicago seeks a Data Engineer - Senior Associate to modernize client data platforms, design ETL pipelines, and implement scalable cloud architectures using Databricks and Snowflake. You will guide data modeling, QA, and security while collaborating with advisory teams to meet client goals.

The role emphasizes ownership of engineering workstreams, technical leadership, and mentoring junior staff in a fast-paced consulting environment. Chicago location preferred.

Qualifications

  • Bachelor's degree in a relevant field with proven data engineering experience.
  • Experience designing cloud-native data platforms and ETL pipelines for analytics.
  • Strong SQL and data modeling skills with attention to data quality.

Responsibilities

  • Design cloud-native data architectures to modernize legacy platforms and support analytics.
  • Build and maintain data pipelines using Airflow, Databricks, and cloud services across AWS/Azure/GCP.
  • Develop data lakes/ warehouses with Snowflake and dimensional modeling for analytics.
  • Troubleshoot database workloads and optimize queries for performance and scalability.
  • Validate data quality and apply security practices on sensitive data.
  • Lead assigned workstreams and mentor junior engineers while aligning with client goals.
  • Review deliverables and communicate progress to clients and stakeholders.

Skills

Cloud data engineering
ETL development
Data modeling
SQL optimization
Team leadership

Education

Bachelor's degree

Tools

Databricks
Snowflake
Apache Airflow
Azure Data Factory
MySQL

Job description

Industry/Sector Not Applicable Specialism Software Engineering Management Level Senior Associate Job Description & Summary

As a Data Engineer - Senior Associate, you will help clients modernize data platforms within our Advisory practice, turning legacy data environments into scalable cloud-based architectures. In this role, you will design data pipelines and integration approaches, develop extract, transform, and load (ETL) workflows, and improve how data is stored and managed across AWS, Microsoft Azure, or Google Cloud. You will apply software engineering methods to cloud migration and platform development, including work with Databricks and Snowflake, helping clients make data more accessible for analytics and informed decisions. As a Senior Associate, you will take ownership of assigned engineering workstreams, analyze complex technical challenges, and connect your recommendations to clients’ broader modernization goals. You will draw on firm methodologies and critical thinking to navigate changing requirements, anticipate client and team needs, and build meaningful client relationships. By reviewing junior colleagues’ work and offering guidance, you will support technical and professional standards, including applicable independence requirements. Feedback and reflection will help you deepen your technical skills and develop your professional presence while contributing to the team’s delivery.

Responsibilities
  • Designing cloud-native data architectures that modernize legacy platforms, align data models with client needs, and support scalable storage and integration across AWS and Microsoft Azure
  • Building and maintaining data pipelines with Apache Airflow, Azure Data Factory, Databricks, and Java to move and transform data across source systems and cloud platforms
  • Developing data lakes and warehouses using Snowflake and dimensional modeling, including snowflake schemas that support analytics and changing business requirements
  • Troubleshooting MySQL, PostgreSQL, and warehouse workloads through query optimization, indexing, and performance tuning to improve data access and processing
  • Validating data quality throughout integration and transformation workflows, applying anonymization and database security practices when handling sensitive information
  • Managing assigned engineering workstreams, documenting design decisions, and adapting pipeline plans as technical constraints and client requirements evolve
  • Applying AI-assisted tools and knowledge of Hadoop where appropriate to assess data engineering approaches, while reviewing outputs against technical requirements
  • Reviewing junior team members’ deliverables, offering practical feedback, and working with clients to clarify data needs and communicate implementation progress
What You Must Have
  • At least a Bachelor's degree
  • At least 3 years of experience
What Sets You Apart
  • Preference for at least one of the following fields of study: Analytics/Data Science, Business Administration/Management, Computer Science/Information Systems, Economics, Engineering, Finance, Mathematics/Statistics, Operations/Supply Chain
  • Modernizing legacy data systems through cloud-based data architecture on AWS or Microsoft Azure
  • Building data pipelines with Apache Airflow or Azure Data Factory for integration and transformation
  • Developing data models and warehouses using Databricks, Snowflake, or dimensional modeling
  • Improving database performance through query optimization, indexing, and troubleshooting
  • Applying data validation, anonymization, and security practices when handling client data
  • Guiding junior colleagues while managing data engineering workstreams and incorporating client feedback
Travel Requirements

Up to 80%

The salary range for this position is: $77,000 - $202,000. Actual compensation within the range will be dependent upon the individual's skills, experience, qualifications and location, and applicable employment laws. All hired individuals are eligible for an annual discretionary bonus.

Benefits
  • medical
  • dental
  • vision
  • 401k
  • holiday pay
  • vacation
  • personal and family sick leave

To view our benefits at a glance, please visit the following link: https://pwc.to/benefits-at-a-glance

As PwC is an equal opportunity employer, all qualified applicants will receive consideration for employment at PwC without regard to race; color; religion; national origin; sex (including pregnancy, sexual orientation, and gender identity); age; disability; genetic information (including family medical history); veteran, marital, or citizenship status; or, any other status protected by law. PwC does not intend to hire experienced or entry level job seekers who will need, now or in the future, PwC sponsorship through the H-1B lottery, except as set forth within the following policy: https://pwc.to/H-1B-Lottery-Policy. Learn more about how we work: https://pwc.to/how-we-work

For only those qualified applicants that are impacted by the Los Angeles County Fair Chance Ordinance for Employers, the Los Angeles' Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, San Diego County Fair Chance Ordinance, and the California Fair Chance Act, where applicable, arrest or conviction records will be considered for Employment in accordance with these laws. At PwC, we recognize that conviction records may have a direct, adverse, and negative relationship to responsibilities such as accessing sensitive company or customer information, handling proprietary assets, or collaborating closely with team members. We evaluate these factors thoughtfully to establish a secure and trusted workplace for all.

To view other PwC job opportunities, visit pwc.com/careers.

Are you ready to make a difference? Want to unlock new value by applying your unique perspective and talents? You can grow exponentially at PwC. Here, you can uncover hidden talents, build lifelong relationships rooted in trust and empathy and turn challenges into opportunities for innovation. We’ll help you grow your skills through challenging, meaningful work so you can go further.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer - Experienced Associate
Data Engineer - Experienced Associate

PricewaterhouseCoopers Advisory Services LLC • New York (NY)

On-site
USD 63,000 - 140,000
medical
dental
vision
+5
Tax Innovation - Data Engineer - Senior Associate
Tax Innovation - Data Engineer - Senior Associate

PwC • Washington

On-site
USD 77,000 - 214,000
Tax Innovation - Data Governance- Senior Associate
Tax Innovation - Data Governance- Senior Associate

PwC • Dallas (TX)

On-site
USD 77,000 - 214,000
medical
dental
vision
+4
Tax Innovation - Data Engineer - Senior Associate
Tax Innovation - Data Engineer - Senior Associate

PwC • Dallas (TX)

On-site
USD 77,000 - 214,000
Medical insurance
Dental insurance
Vision insurance
+4
Deal Data Technology & Analytics, Senior Associate
Deal Data Technology & Analytics, Senior Associate

PwC • San Jose (CA)

On-site
USD 77,000 - 202,000
Annual discretionary bonus
Medical insurance
Dental insurance
+5
Tax Innovation - Data Engineer - Manager
Tax Innovation - Data Engineer - Manager

PwC • Dallas (TX)

On-site
USD 99,000 - 266,000
Annual discretionary bonus
Comprehensive benefits package
Tax Innovation - Data Governance- Senior Associate
Tax Innovation - Data Governance- Senior Associate

PwC • New York (NY)

On-site
USD 77,000 - 214,000
Medical, dental, vision
401k
Holiday pay
+2
Fraud Analytics - AI Engineer - Manager
Fraud Analytics - AI Engineer - Manager

PwC US Consulting LLP • New York (NY)

On-site
USD 99,000 - 232,000
Medical benefits
Dental benefits
401k
Tax Innovation - Data Engineer - Manager
Tax Innovation - Data Engineer - Manager

PwC • Washington

On-site
USD 99,000 - 266,000
Medical insurance
Dental insurance
Vision insurance
+4
Tax Innovation - Data Engineer - Senior Associate
Tax Innovation - Data Engineer - Senior Associate

PwC • New York (NY)

On-site
USD 77,000 - 214,000
Medical benefits
Dental benefits
Vision benefits
+4