PwC

Data Engineer - Experienced Associate

PwC
Apply
3 days ago

Base Salary

$63k - $140k/yr

Responsibilities

  • Build cloud data pipelines that ingest, transform, and integrate client data across AWS and Azure using Apache Airflow and Azure Data Factory.
  • Support migration of legacy data systems to cloud-based data lakes and warehouses by documenting infrastructure, mapping dependencies, and implementing assigned components.
  • Develop data models and dimensional schemas for Snowflake and Databricks in alignment with analytics requirements and documented architecture.
  • Write SQL and Java transformations across MySQL, PostgreSQL, and data engineering platforms, using validation checks to investigate data quality issues.
  • Configure workflow dependencies in directed acyclic graphs and support data processing with Apache Hadoop while troubleshooting pipeline failures.
  • Apply database administration, indexing, and query optimization techniques to investigate warehouse performance and data management issues.
  • Implement data anonymization and database security controls within assigned engineering work.
  • Contribute to client discussions by clarifying requirements, sharing technical findings, incorporating feedback, and using digital and AI-assisted tools to explore integration options.

Requirements

  • At least a bachelor's degree is required.
  • At least one year of experience is required.
  • Preferred fields of study include analytics or data science, business administration or management, computer science or information systems, economics, engineering, finance, mathematics or statistics, and operations or supply chain.
  • Preferred experience includes building pipelines with Apache Airflow or Azure Data Factory, applying data modeling and validation techniques, supporting cloud platform migrations with AWS, Azure, or Databricks, troubleshooting Snowflake queries, and communicating data quality findings.
  • Up to 80% travel is required.

Benefits

  • PwC offers medical, dental, vision, 401(k), holiday pay, vacation, personal and family sick leave, and additional benefits.
  • The salary range is $63,000-$140,000 with eligibility for an annual discretionary bonus.
  • The role may require travel of up to 80%.

Tech Stack

Apache AirflowApache HadoopAWSAzureDatabricksGoogle CloudJavaMySQLPostgreSQLSnowflakeSQL

Categories

Data Engineering
PwC

About PwC

10,000+ employees

PwC is a global network of professional services firms providing assurance, tax, and advisory work for businesses and public-sector clients. It sells project-based and managed consulting, audit, and deals services, and implements and integrates business applications. Formed in 1998 by the merger of Price Waterhouse and Coopers & Lybrand, it is headquartered in London and is one of the Big Four accounting firms.

Contact me