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 decision-making and driving business growth.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 business-critical 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 high-quality 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:
Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field.
Strong knowledge of SQL and data modeling best practices (e.g., Kimball, Inmon).
Hands-on experience with Snowflake-specific 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 Airflow, Apache Hadoop, Azure Data Factory, Communication, Creativity, Data Anonymization, Data Architecture, Database Administration, Database Management System (DBMS), Database Optimization, Database Security Best Practices, Databricks Unified Data Analytics Platform, Data Engineering, Data Engineering Platforms, Data Infrastructure, Data Integration, Data Lake, Data Modeling, Data Pipeline {+ 28 more}Desired Languages (If blank, desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship?
NoGovernment Clearance Required?
NoJob Posting End Date
Want to know if this job is worth applying to?
Cairo - ETIC, Egypt
Onsite