Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives.

As a business application consulting generalist at PwC, you will provide consulting services for a wide range of business applications. You will leverage a broad understanding of various software solutions to assist clients in optimising operational efficiency through analysis, implementation, training, and support.

*Why PWCAt 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. "

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: 

 

4 to 8 years 

Education qualification: 

 

Graduate Engineer or Management Graduate 

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

Degrees/Field of Study required: Bachelor in Business Administration, Bachelor of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Microsoft Azure

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Reasoning, Analytical Thinking, Application Software, Business Data Analytics, Business Management, Business Technology, Business Transformation, Communication, Creativity, Documentation Development, Embracing Change, Emotional Regulation, Empathy, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, Performance Assessment, Performance Management Software {+ 16 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date