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
ETL
Informatica
Microsoft Azure
Performance Tuning
Query Optimization
Snowflake
Spark
Job Description
Join PwC’s Advisory practice to help clients modernize data platforms with cloud architectures and production-ready data pipelines.
Responsibilities
- Design cloud-native data architectures to modernize legacy platforms, align data models with client needs, and enable 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 data warehouses using Snowflake and dimensional modeling, including snowflake schemas that support analytics and evolving business requirements
- Troubleshoot MySQL and PostgreSQL, including warehouse workload performance, using query optimization, indexing, and performance tuning
- Ensure data quality across integration and transformation workflows, applying anonymization and database security practices for sensitive information
- Own assigned engineering workstreams, document design decisions, and update pipeline plans as technical constraints and client requirements change
- Use AI-assisted tools and knowledge of Hadoop where appropriate to evaluate data engineering approaches, and validate outputs against technical requirements
- Review junior engineers’ deliverables, provide practical feedback, and partner with clients to clarify data needs and communicate implementation progress
Requirements
- Bachelor’s degree
- 3+ years of experience
Technologies
- 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
Benefits
- Annual discretionary bonus eligibility
- Medical, dental, vision
- 401k
- Holiday pay
- Vacation
- Personal and family sick leave
Additional Considerations
- 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
- Experience modernizing legacy data systems using cloud-based data architecture on AWS or Microsoft Azure
- Experience building integration and transformation pipelines with Apache Airflow or Azure Data Factory
- Experience developing data models and warehouses with Databricks, Snowflake, and/or dimensional modeling
- Track record improving performance through query optimization, indexing, and troubleshooting
- Experience applying data validation, anonymization, and security practices for client data
- Experience guiding junior colleagues while managing data engineering workstreams and incorporating client feedback
Location: United States (onsite)
Salary: USD 77,000 - 202,000 per yearly