IN-Manager_Snowflake Developer_Data & Analytics_Advisory_Bangalore
PWC
5 - 10 years
Bengaluru
Posted: 25/01/2025
Job Description
Line of Service
AdvisoryIndustry/Sector
Not ApplicableSpecialism
Data, Analytics & AIManagement Level
ManagerJob Description & Summary
A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.Creating business intelligence from data requires an understanding of the business, the data, and the technology used to store and analyse that data. Using our Rapid Business Intelligence Solutions, data visualisation and integrated reporting dashboards, we can deliver agile, highly interactive reporting and analytics that help our clients to more effectively run their business and understand what business questions can be answered and how to unlock the answers.
Responsibilities:
- Design, develop and maintain data warehouse solutions using Snowflake, while ensuring data quality, accuracy, and consistency.
- Knowledge of SQL language and stored procedures
- SQL performance measuring, query tuning, and database tuning
- Data warehousing concepts, data modeling, metadata management
- Create and maintain stored procedures and SQL scripts to support ETL processes and data transformations.
- Performance tuning and setting up resource monitors
- Snowflake modeling – roles, databases, schemas
- Core Snowflake concepts – Snowpipe, tasks, streams, dynamic tables, etc.
- Write, optimize, and troubleshoot SQL queries within the Snowflake environment.
- Integrate Snowflake with various data sources and third-party tools.
- Proficient in SQL and familiar with ETL processes
- Hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning
- Managing sets of XML, JSON, and CSV from disparate sources
Mandatory skill sets:
SQL, Snowflake, Data warehousing, Data modelling
Preferred skill sets:
- Integration with third-party tools
- Data Build Tool(dbt)
- Coding in languages like Python
- Hadoop, Spark, and other warehousing tools
Good to have: SnowPro Certification
Years of experience required:
7 to 10 years
Education qualification:
Graduate Engineer or Management Graduate
Education (if blank, degree and/or field of study not specified)
Degrees/Field of Study required: Master of Engineering, Bachelor of EngineeringDegrees/Field of Study preferred:Certifications (if blank, certifications not specified)
Required Skills
Snowflake (Platform)Optional Skills
Accepting Feedback, Accepting Feedback, Active Listening, Analytical Reasoning, Analytical Thinking, Application Software, Business Data Analytics, Business Management, Business Technology, Business Transformation, Coaching and Feedback, Communication, Creativity, Documentation Development, Embracing Change, Emotional Regulation, Empathy, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, Performance Assessment {+ 21 more}Desired Languages (If blank, desired languages not specified)
Travel Requirements
Available for Work Visa Sponsorship?
Government Clearance Required?
Job Posting End Date
About Company
PricewaterhouseCoopers (PwC) is a global professional services firm providing audit, tax, and consulting services. PwC helps organizations manage financial risks, comply with regulations, and improve performance through its expertise in industries like finance, healthcare, and technology.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).