ETIC Data Engineer Snowflake Senior Associate
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Line of Service
AdvisoryIndustry/Sector
TechnologySpecialism
Advisory OtherManagement Level
Senior AssociateJob Description & 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 decisionmaking 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.
Key Responsibilities:
Design and build robust ELT pipelines using Snowflake integrating data from various structured and unstructured sources.
Develop and maintain data models including star/snowflake schemas data marts and enterprise data warehouses on Snowflake.
Implement data transformation logic using Snowflake SQL Streams & Tasks and tools like DBT (Data Build Tool).
Optimize performance of Snowflake warehouses queries and materialized views to support businesscritical analytics.
Implement data governance security and access control policies within Snowflake using RBAC and masking policies.
Work closely with data analysts BI developers and data scientists to understand data requirements and deliver highquality datasets.
Automate CI/CD workflows for Snowflake objects and transformations using tools like GitHub Azure DevOps or GitLab.
Monitor and troubleshoot data pipeline issues ensuring reliability consistency and accuracy.
Document data workflows lineage and architecture for maintainability and knowledge sharing.
Required Skills & Qualifications:
Bachelors or Masters degree in Computer Science Information Systems Engineering or a related field.
Strong knowledge of SQL and data modeling best practices (e.g. Kimball Inmon).
Handson experience with Snowflakespecific features: Virtual Warehouses Streams Tasks Time Travel Cloning and Secure Views.
Experience with ETL/ELT tools such as DBT Matillion Fivetran Informatica or Azure Data Factory.
Familiarity with cloud platforms (Azure AWS or GCP) especially Snowflake integrations.
Proficiency in at least one scripting/programming language: Python Scala or Java.
Strong understanding of data governance lineage and metadata management.
Version control and CI/CD experience using Git Terraform or similar tools.
Education (if blank degree and/or field of study not specified)
Degrees/Field of Study required:Degrees/Field of Study preferred:Certifications (if blank certifications not specified)
Required Skills
Azure Data Lake Microsoft Azure Microsoft Azure SQL Database Snowflake Data WarehouseOptional 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 19 moreDesired Languages (If blank desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship
NoGovernment Clearance Required
NoJob Posting End Date
Required Experience:
Senior IC
Employment Type
Full-Time
