DataJobs.io
← Back to all jobs

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

Similar Jobs