In PwC’s Advisory practice, you’ll help clients modernize data platforms by designing cloud-based architectures and building data pipelines that keep pace with evolving business needs. This role is onsite in the United States, with a salary range of USD 77,000 - 202,000 per year. You will work with cloud and analytics technologies across AWS, Microsoft Azure, and Google Cloud, leveraging tools like Databricks and Snowflake.
What you can expect
- Annual discretionary bonus eligibility for all hired individuals
- Medical, dental, vision coverage
- 401k
- Holiday pay
- Vacation
- Personal and family sick leave
Responsibilities
- Design cloud-native data architectures that modernize legacy platforms, align data models with client needs, and support 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, to support analytics and changing requirements
- Troubleshoot MySQL and PostgreSQL workloads and warehouse performance using query optimization, indexing, and performance tuning
- Validate data quality through integration and transformation, applying anonymization and database security practices for sensitive information
- Manage assigned engineering workstreams, document design decisions, and adapt pipeline plans as technical constraints and client needs evolve
- Use AI-assisted tools and knowledge of Hadoop where appropriate to assess data engineering approaches, then review outputs against technical requirements
- Review junior team members’ deliverables, provide practical feedback, and partner with clients to clarify data needs and communicate implementation progress
Requirements
- Bachelor’s degree
- At least 3 years of experience
Technologies and tools you’ll work with
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
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 pipelines with Apache Airflow or Azure Data Factory for integration and transformation
- Experience developing data models and warehouses using Databricks, Snowflake, and dimensional modeling
- Demonstrated ability to improve database performance through query optimization, indexing, and troubleshooting
- Ability to apply data validation, anonymization, and security practices when handling client data
- Experience guiding junior colleagues while managing data engineering workstreams and incorporating client feedback