Sr Associate – Snowflake Data Engineer, D&A, Advisory

Overview

Sr Associate – Snowflake Data Engineer role in PwC’s Data and Analytics services, focused on designing and building data infrastructure and pipelines using Snowflake and cloud services.

What you'll do

• Design, develop, and maintain ETL/ELT pipelines using Snowflake and cloud services.
• Build and optimize Snowflake databases, schemas, tables, views, stages, file formats, streams, tasks, and stored procedures.
• Implement data ingestion frameworks using Snowpipe, COPY INTO, CDC, Streams, and Tasks.
• Develop transformation logic using SQL, DBT, and Python.
• Perform data migration from legacy platforms (Oracle, SQL Server, etc.) to Snowflake.
• Implement security controls such as RBAC, row-level security, masking policies, and governance standards.
• Optimize Snowflake warehouse performance and support reporting platforms like Power BI and Tableau.

What you'll need

• 4-8 years of experience (years required stated as “4-8”).
• Advanced SQL.
• Data warehousing concepts.
• SCD Type 1 & Type 2 data modeling.
• ETL/ELT development.
• Data migration.

Nice to have

• Knowledge of real-time data ingestion and CDC.
• Experience with DBT and Airflow orchestration.

Details

• Location: Pune.