PwC Logo

PwC

Data Engineer - Senior Associate

Posted Yesterday
Hybrid
Chicago, IL, USA
77K-202K Annually
Senior level
Hybrid
Chicago, IL, USA
77K-202K Annually
Senior level
Designs and develops cloud-based data architectures, pipelines, ETL workflows, data lakes, and warehouses using AWS, Azure, Databricks, Snowflake, Airflow, and Java. The role includes database performance tuning, data quality validation, anonymization, security practices, workstream ownership, client collaboration, and mentoring junior engineers while modernizing legacy data platforms.
The summary above was generated by AI
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
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.

PwC Chicago, Illinois, USA Office

One North Wacker Drive, Chicago, IL, United States, 60606

PwC Chicago, Illinois, USA Office

330 North Wabash Avenue, Suite 3950, Chicago, IL, United States, 60611

PwC Rosemont, Illinois, USA Office

9399 West Higgins Road Suite 900, Rosemont, IL, United States, 60018

Similar Jobs at PwC

2 Days Ago
Hybrid
Chicago, IL, USA
77K-214K Annually
Senior level
77K-214K Annually
Senior level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Design and build data infrastructure, pipelines, and transformations using Azure Data Factory, Azure Databricks, and Snowflake. Develop data architecture and modeling, maintain data lakes/warehouses, ensure data quality and security, optimize performance, and collaborate with clients to deliver tailored data solutions and governance.
Top Skills: Azure Data FactoryAzureMicrosoft Azure DatabricksSnowflake
9 Hours Ago
Hybrid
Chicago, IL, USA
124K-335K Annually
Senior level
124K-335K Annually
Senior level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Leads software engineering initiatives that deliver scalable tax technology solutions. Responsibilities include architecting enterprise applications and microservices, directing C# development and testing, translating tax-service needs into requirements, evaluating AI capabilities, managing cross-team delivery, improving processes, and coaching engineering teams.
Top Skills: .NetArtificial IntelligenceC#Enterprise ApplicationsMicroservices
9 Hours Ago
Hybrid
2 Locations
61K-100K Annually
Junior
61K-100K Annually
Junior
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Supports Google Cloud data modernization and generative AI client engagements. Builds Vertex AI, LLM, vector database, Python, RAG, prompt engineering, evaluation, guardrail, LLMOps, and agent orchestration solutions. Collaborates on cloud data platforms, integration, analytics modernization, and machine learning projects while troubleshooting, documenting findings, contributing to solution design, and incorporating feedback.
Top Skills: Agent OrchestrationAi GuardrailsETLGoogle Cloud PlatformGoogle Vertex AiLlm ApisLlm EvaluationLlmopsMachine LearningMulti-CloudNatural Language ProcessingPrompt EngineeringPythonRetrieval-Augmented GenerationVector Databases

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account