Job Description

Line of Service AdvisoryIndustry/Sector Not ApplicableSpecialism Data, Analytics & AIManagement Level Senior Associate & Summary 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.*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 .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 firmxe2x80x99s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. " & 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.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 xe2x80x93 roles, databases, schemas
• Core Snowflake concepts xe2x80x93 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:

• Integration with third-party tools
• Data Build Tool(dbt)
• Coding in languages like Python
• Hadoop, Spark, and other warehousing tools

Preferred skill sets:

• Integration with third-party tools
• Data Build Tool(dbt)
• Coding in languages like Python
• Hadoop, Spark, and other warehousing tools
• SnowPro Certification

Years of experience required:3 - 7Education qualification:B.Tech / M.Tech / MBA / MCAEducation (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Master of Engineering, Master of Business Administration, Bachelor of EngineeringDegrees/Field of Study preferred:Certifications (if blank, certifications not specified)Required Skills PySparkOptional Skills Accepting Feedback, Accepting Feedback, Active Listening, Agile Scalability, Amazon Web Services (AWS), Analytical Thinking, Apache Hadoop, Azure Data Factory, Communication, Creativity, Data Anonymization, Database Administration, Database Management System (DBMS), Database Optimization, Database Security Best Practices, Data Engineering, Data Engineering Platforms, Data Infrastructure, Data Integration, Data Lake, Data Modeling, Data Pipeline, Data Quality, Data Transformation, Data Validation {+ 18 more}Desired Languages (If blank, desired languages not specified)Travel Requirements Not SpecifiedAvailable for Work Visa Sponsorship? NoGovernment Clearance Required? NoJob Posting End Date

PwC