Snowflake - Manager

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.

At PwC - The candidate must have strong expertise in Snowflake and DBT to architect, design, and implement scalable cloud data warehouse solutions. The candidate will be responsible for leading data migration, building optimized and automated ETL/ELT pipelines with DBT, and ensuring data quality and security on Snowflake Cloud Platform. This role requires collaboration with clients and cross-functional teams to translate business requirements into effective technical solutions, while managing and mentoring a technical team to deliver projects successfully.

Years of Experience: Candidates with 8-12 years of hands on experience

Position Requirements

Must Have:

• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe,ETL data Pipelines, Big Data model techniques using
  
  

Python / Java

• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Proficient in DBT for developing, testing, and deploying modular, version-controlled data transformation pipelines.
• Ability to interpret complex business and technical requirements into scalable Snowflake data models and DBT workflows.
• Handling large and complex sets of XML, JSON, and CSV from various sources and databases
• Experience in load from disparate data sets and translate complex functional and technical requirements into detailed design
• Should be aware in deploying Snowflake features such as data sharing, events and lake-house patterns
• Should have experience with data security and data access controls and design
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modeling)
• Good to have AWS, Azure or GCP data storage and management technologies such as S3, Blob/ADLS and Google Cloud Storage
• Should have a good understanding of Data Quality processes, methods and project lifecycle.
• Experience validating the ETL and writing SQL queries
• Strong knowledge in DWH/ODS, ETL concept and modeling structure principles
• Should have clear understanding of DW Lifecycle and contributed in preparing technical design documents and test plans
• Good analytical & problem-solving skills
• Good communication and presentation skills
• Business / domain knowledge in one of the domains -Financial Services/ Healthcare/ Consumer Market/Industrial Products/ Telecommunication,Media and Technology /Deal advisory along with technical expertise
• Experience in leading technical teams, guiding and mentoring team members
  
  

Desired Knowledge / Skills

• Certifications in Snowflake (SnowPro Core) and DBT (DBT Fundamentals) are highly desirable.
• Experience in Agile delivery frameworks and DevOps culture
• Knowledge of additional data tools/technologies such as Python, Apache Spark and Kafka
  
  

Professional And Educational Background

• BE / B.Tech / MCA / M.Sc / M.E / M.Tech / MBA
  
  

Additional Information

• Travel Requirements: Travel to client locations may be required as per project requirements.
• Line of Service: Advisory
• Horizontal: Technology Consulting
• Designation: Manager
• Location: Bangalore, India
  
  

The Opportunity

When you join PwC Acceleration Centers (ACs), you step into a pivotal role focused on actively supporting various Acceleration Center services, from Advisory to Assurance, Tax and Business Services. In our innovative hubs, you’ll engage in challenging projects and provide distinctive services to support client engagements through enhanced quality and innovation. You’ll also participate in dynamic and digitally enabled training that is designed to grow your technical and professional skills.

As part of the Data and Analytics Engineering team you will architect and deliver highly scalable, cloud-based enterprise data solutions. As a Manager you will lead teams and manage client accounts, focusing on strategic planning and mentoring junior staff, while securing project success and maintaining elevated standards. This role offers the chance to leverage your knowledge in cloud technologies and data engineering to drive innovation and deliver exceptional results for our clients.

Responsibilities

• Design and implement scalable cloud-based data solutions
• Lead project teams and manage client relationships
• Mentor junior staff and promote professional growth
• Maintain adherence to project timelines and quality standards
• Analyze data engineering challenges and propose creative solutions
• Collaborate with cross-functional teams to enhance service delivery
• Utilize cloud technologies to drive productivity and effectiveness
• Foster a culture of continuous improvement and knowledge sharing
  
  

What You Must Have

• Bachelors Degree
• 7 years of experience in data engineering
• Oral and written proficiency in English required
  
  

What Sets You Apart

• 7-12 years of experience
• Experience in architecting scalable cloud data solutions
• Guiding teams in data modeling and performance optimization
• Skilled in AWS, Azure, or GCP data technologies
• Hands-on experience with Snowflake and ETL tools
• Knowledge of Big Data frameworks like Hadoop and Spark
• Experience with AWS Streaming Services
• Certification on AWS Architecture desirable
• Business knowledge in Financial Services or Healthcare

---