IN_Senior Associate_Snowflake & dbt/IICS Developer _D&A _Advisory _Mumbai

Line of Service

Industry/Sector

Specialism

Management Level

Job Description & Summary

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 firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations.

Job Summary:

We are seeking an experienced Snowflake & dbt/IICS Developer with 5–8 years of experience in designing and developing scalable data solutions. The ideal candidate must have strong proficiency in Python and SQL, along with hands-on experience in Snowflake, dbt (Data Build Tool), IICS or any leading ETL tools, and a good understanding of Data Lake and Data Warehouse architectures.

Responsibilities:

· Design, develop, and maintain data transformation pipelines using dbt/IICS on Snowflake.

· Write optimized SQL and Python scripts for complex data modeling and processing tasks.

· Collaborate with data analysts, engineers, and business teams to implement scalable ELT workflows.

· Create and manage data models, schemas, and documentation in dbt.

· Optimize Snowflake performance using best practices (clustering, caching, virtual warehouses).

· Manage data integration from data lakes, external systems, and cloud sources.

· Ensure data quality, lineage, version control, and compliance across all environments.

· Participate in code reviews, testing, and deployment activities using CI/CD pipelines.

Mandatory skill sets:

· 5–8 years of experience in Data Engineering or Data Platform Development.

· Hands-on experience with Snowflake – data warehousing, architecture, and performance tuning.

· Proficient in dbt (Data Build Tool) – model creation, Jinja templates, macros, testing, and documentation.

· Hands-on experience in creating mapping and workflows in IICS and have extensive experience in performance tuning and troubleshooting activities

· Strong Python scripting for data transformation and automation.

· Advanced skills in SQL – writing, debugging, and tuning queries.

· Experience with Data Lake and Data Warehouse concepts and implementations.

· Familiarity with Git-based workflows and version control in dbt projects.

Preferred skill sets:

· Experience with Airflow, Dagster, or other orchestration tools.

· Knowledge of cloud platforms like AWS, Azure, or GCP.

· Exposure to BI tools like Power BI, Tableau, or Looker.

· Understanding Data Governance, Security, and Compliance.

· Experience in leading a development team

Years of experience required:

5-8

Education qualification:

Btech/MBA/MCA

Education (if blank, degree and/or field of study not specified)

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date