Snowflake

Line of Service - Advisory

Specialism - Data, Analytics & AI

Management Level - Senior Associate

Job Description & Summary

At PwC, our people in data and analytics engineering focus on leveraging advanced technologies and techniques to design and develop robust data solutions for clients. They play a crucial role in transforming raw data into actionable insights, enabling informed decision-making and driving business growth.

In data engineering at PwC, you will focus on designing and building data infrastructure and systems to enable efficient data processing and analysis. You will be responsible for developing and implementing data pipelines, data integration, and data transformation solutions.

Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firms growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. "

Responsibilities:

• Design, develop, and optimize data pipelines and data models in Snowflake.
• Implement and maintain DBT workflows for data transformation and modeling.
• Write efficient and scalable SQL queries for data extraction and reporting.
• Collaborate with data analysts, scientists, and business stakeholders to understand data requirements.
• Integrate data from various sources using Python.
• Orchestrate workflows using Apache Airflow or similar tools
• Ensure data quality, integrity, and governance across the pipeline.
• Work with CI/CD tools to automate deployment and testing of data workflows.
• Optimize performance and cost of Snowflake workloads.
• Leverage cloud services from Azure or GCP for scalable data solutions.

Primary Skills:

• Snowflake
• SQL
• Data Modelling
• DBT (Data Build Tool)

Secondary Skills:

• Airflow (Workflow Orchestration)
• Python (Scripting, Data Manipulation)
• CI/CD (Git, Jenkins, Azure DevOps, etc.)
• PL/SQL, Teradata (for legacy support)
• Exposure to Azure or GCP cloud services (Data Factory, BigQuery, Storage, etc.)

Years of experience required:

5-10

Education qualification:

B. Tech/MBA/MCA / M. Tech

Certifications - SnowPro Core , SnowPro Advanced