Line of Service
AdvisoryIndustry/Sector
Not ApplicableSpecialism
Data, Analytics & AIManagement Level
Senior AssociateJob 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.
*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.
Responsibilities: Job Description:
Knowledge of SQL language and cloud-based
technologies
Data warehousing concepts, data modeling, metadata
management
Data lakes, multi-dimensional models, data dictionaries
Migration to AWS or Azure Snowflake platform
Performance tuning and setting up resource monitors
Snowflake modeling – roles, databases, schemas
SQL performance measuring, query tuning, and
database tuning
ETL tools with cloud-driven skills
Integration with third-party tools
Ability to build analytical solutions and models
Coding in languages like Python
Hadoop, Spark, and other warehousing tools
Managing sets of XML, JSON, and CSV from disparate
sources
Snowflake warehousing, architecture, processing,
administration
Data ingestion into Snowflake
Enterprise-level technical exposure to Snowflake
applications
Proven track record of data migration and optimization
within Snowflake
Ability to translate business needs into technical
specifications
Design and implement scalable and efficient data
storage solutions using Snowflake.
Write, optimize, and troubleshoot SQL queries within
the Snowflake environment.
Integrate Snowflake with various data sources and
third-party tools.
Ensure data security and compliance with industry
standards.
Collaborate with cross-functional teams to meet data-
driven business objectives.
Stay updated with the latest Snowflake features and
best practices.
Proficient in SQL and familiar with ETL processes
Experience with data modeling and cloud computing
environments
Hands-on experience with Snowflake features like Time
Travel and Zero-Copy Cloning
Understanding of data compliance and security best
practices
Experience in performance tuning and cost optimization
in a cloud data platform
Familiarity with BI tools integration, such as Tableau.
Mandatory skill sets: Snowflake
Preferred skill sets: Snowflake
Years of experience required: 7-10 Years
Education qualification: BE, B.Tech, MCA, M.Tech
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
Structured Query Language (SQL)Optional Skills
Desired Languages (If blank, desired languages not specified)
Travel Requirements
Available for Work Visa Sponsorship?
Government Clearance Required?
Job Posting End Date