Data Engineer - Experienced Associate
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 Operations
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Factory
Data Factory Azure
Data Integration
Data Integration Tools
Data Lakehouse
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
Databricks
ETL
Gcp Cloud
Informatica
Microsoft Azure
Snowflake
SQL
Job Description
PwC is hiring an Experienced Associate Data Engineer for an onsite role in the United States. In this position, you will help clients modernize data platforms within Advisory by building cloud-based pipelines, strengthening data integration, and supporting analytics and decision-making. You will work across AWS and Microsoft Azure using core data engineering tools including Apache Airflow, Azure Data Factory, Databricks, and Snowflake.
What you’ll do
- Build cloud data pipelines to ingest, transform, and integrate client data across AWS and Azure using Apache Airflow and Azure Data Factory.
- Support migration of legacy systems to cloud data lakes and warehouses by documenting infrastructure, mapping dependencies, and implementing assigned components.
- Develop data models and dimensional schemas for Snowflake and Databricks, aligning storage structures to analytics needs and documented architecture.
- Write SQL and Java transformations across MySQL and PostgreSQL, using validation checks to investigate data quality issues.
- Configure workflow dependencies in directed acyclic graphs and support data processing with Apache Hadoop, documenting pipeline behavior and troubleshooting failures.
- Apply database administration, indexing, and query optimization techniques to investigate warehouse performance and address data management concerns.
- Implement data anonymization and database security controls within assigned tasks, and check data movement against documented client requirements.
- Contribute to client project discussions by clarifying requirements, sharing technical findings, incorporating feedback, and using digital and AI-assisted tools to explore integration options.
What you bring
- Bachelor’s degree
- At least 1 year of experience
Technology focus
You will work with AWS, Microsoft Azure, and Google Cloud, alongside Apache Airflow, Azure Data Factory, Databricks, Snowflake, SQL, Java, MySQL, PostgreSQL, Apache Hadoop, and directed acyclic graphs, including data lakes and data warehouses.
Benefits
- Annual discretionary bonus
- Medical, dental, and vision coverage
- 401(k)
- Holiday pay
- Vacation
- Personal and family sick leave
Salary: USD 63,000 - 140,000 per year.
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 building data pipelines using Apache Airflow or Azure Data Factory to integrate and transform data.
- Ability to apply data modeling and validation techniques in support of cloud data platform work.
- Experience with AWS or Microsoft Azure Databricks to support migration from legacy data systems.
- Capability to troubleshoot Snowflake warehouse queries and explore performance improvements with project teams.
- Skill in incorporating feedback while communicating data quality findings and asking questions during client work.