lvl100Sign in

PwC US

Data Engineer - Senior Associate

  • IL-Chicago
  • Full-time
  • $77,000 - $202,000
  • Posted

Skills

  • AWS
  • Google Cloud
  • Java
  • Microsoft Azure
  • MySQL
  • Operations
  • PostgreSQL
  • Snowflake
  • Statistics
  • Supply Chain
  • Troubleshooting

Job description

Industry/Sector

Not Applicable

Specialism

Software Engineering

Management Level

Senior Associate

Job Description & Summary

The Opportunity

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%

Job Posting End Date

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. PwC offers a wide range of benefits, including medical, dental, vision, 401k, holiday pay, vacation, personal and family sick leave, and more. 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.

Browse all jobs by role, city or company