Data Engineer - Senior Associate
Anonymization
Apache Airflow
Azure
Azure Data Engineer
Azure Data Factory
Azure Data Platform
Big Data
Bigdata
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Engineer
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Data
Data Architecture
Data Engineer
Data Engineering
Data Factory
Data Factory Azure
Data Integration
Data Integration Tools
Data Lakehouse
Data Lakes
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Database Security
Databases
Databricks
Engineer
ETL
Informatica
Microsoft Azure
Performance Tuning
Query Optimization
Snowflake
Spark
Job Description
In PwC’s Advisory practice, you’ll help clients modernize data platforms by designing cloud-based architectures and building data pipelines that keep pace with evolving business needs. This role is onsite in the United States, with a salary range of USD 77,000 - 202,000 per year. You will work with cloud and analytics technologies across AWS, Microsoft Azure, and Google Cloud, leveraging tools like Databricks and Snowflake.
What you can expect
- Annual discretionary bonus eligibility for all hired individuals
- Medical, dental, vision coverage
- 401k
- Holiday pay
- Vacation
- Personal and family sick leave
Responsibilities
- Design 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
- Build and maintain data pipelines using Apache Airflow, Azure Data Factory, Databricks, and Java to move and transform data across source systems and cloud platforms
- Develop data lakes and warehouses with Snowflake and dimensional modeling, including snowflake schemas, to support analytics and changing requirements
- Troubleshoot MySQL and PostgreSQL workloads and warehouse performance using query optimization, indexing, and performance tuning
- Validate data quality through integration and transformation, applying anonymization and database security practices for sensitive information
- Manage assigned engineering workstreams, document design decisions, and adapt pipeline plans as technical constraints and client needs evolve
- Use AI-assisted tools and knowledge of Hadoop where appropriate to assess data engineering approaches, then review outputs against technical requirements
- Review junior team members’ deliverables, provide practical feedback, and partner with clients to clarify data needs and communicate implementation progress
Requirements
- Bachelor’s degree
- At least 3 years of experience
Technologies and tools you’ll work with
AWS, Microsoft Azure, Google Cloud, Apache Airflow, Azure Data Factory, Databricks, Java, ETL, Snowflake, dimensional modeling, snowflake schemas, MySQL, PostgreSQL, AI-assisted tools, Hadoop, query optimization, indexing, performance tuning, database security practices, anonymization
What sets you apart
- Preference for at least one field of study: Analytics/Data Science, Business Administration/Management, Computer Science/Information Systems, Economics, Engineering, Finance, Mathematics/Statistics, Operations/Supply Chain
- Experience modernizing legacy data systems with cloud-based data architecture on AWS or Microsoft Azure
- Experience building pipelines with Apache Airflow or Azure Data Factory for integration and transformation
- Experience developing data models and warehouses using Databricks, Snowflake, and dimensional modeling
- Demonstrated ability to improve database performance through query optimization, indexing, and troubleshooting
- Ability to apply data validation, anonymization, and security practices when handling client data
- Experience guiding junior colleagues while managing data engineering workstreams and incorporating client feedback