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
Join PwC’s Advisory practice to help clients modernize data platforms through cloud-based architectures and production-ready data pipelines.
- Location: United States (onsite)
- Compensation: USD 77,000 - 202,000 per yearly
- Experience: 3+ years
- Education: Bachelor’s degree
Responsibilities
- Design cloud-native data architectures to modernize legacy platforms, align data models to 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 warehouses with Snowflake and dimensional modeling, including snowflake schemas for analytics and evolving business requirements
- Troubleshoot MySQL, PostgreSQL, and warehouse workloads by applying query optimization, indexing, and performance tuning
- Validate data quality across integration and transformation workflows, applying anonymization and database security practices for sensitive information
- Manage assigned engineering workstreams, document design decisions, and adjust pipeline plans as technical constraints and client requirements change
- Use AI-assisted tools and knowledge of Hadoop when appropriate to evaluate data engineering approaches, and review outputs against technical requirements
- Review junior team members’ deliverables, provide practical feedback, and partner with clients to confirm data needs and communicate implementation progress
Requirements
- Education: At least a Bachelor’s degree
- Experience: At least 3 years of experience
Technology Stack
- 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
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 integration and transformation pipelines with Apache Airflow or Azure Data Factory
- Experience developing data models and warehouses using Databricks, Snowflake, or dimensional modeling
- Experience improving database 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