Snowflake Dremio - Senior 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 will interact with Offshore Manager/ Onsite Business Analyst to understand the requirements. Candidates will be responsible for architecting and implementing very large scale data intelligence solutions around Snowflake Data Warehouse. Candidates should have in-depth knowledge of cloud services. Possess experience in SQL development and Data analysis.

Years of Experience: Candidates with 12-16 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
  
  

• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Proficient with Dremio for data lake query acceleration and data virtualization.
• 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 within Snowflake and Dremio
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modeling)
• Exposure to cloud AWS, Azure or GCP data storage and management technologies such as S3, Blob/ADLS and Google Cloud Storage
• Experience in defining cloud migration strategy for Database / Datalake
• 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
  
  

• Knowledge of Snowflake Cortex, Snowflake AI features and Sigma.
• Knowledge of data integration tools like Informatica, DataStage, or Ab Initio.
• Familiarity with data visualization tools such as Tableau or Qlik.
• Experience with programming languages such as Python, Java, or PySpark.
• Certifications related to cloud data warehousing or Snowflake.
• Experience in pre-sales engagements and proposal development.
• Data Modeling and Data Architecture
• Cloud - AWS, GCP, Oracle-Cloud
• Business Intelligence - MicroStrategy, Business Objects, Cognos
• Data Appliance - Teradata, Netezza
  
  

• Excellent communication skills, client presence, presentation skills
• People skills, Leadership skills
• Engage with business and technical teams to drive consensus
  
  

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