ETIC, Data Modeler, Senior Associate
At a glance
Senior Data Architecture & Governance role at PwC. Cairo - ETIC · full-time.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Design data models using dimensional, normalized, and star or snowflake approaches
- Shape enterprise warehouse or lakehouse architecture around data modeling needs
- Use SQL and a modeling tool such as ERwin, ER/Studio, PowerDesigner, or an equivalent
What you bring
- You have five to seven years of data modeling and data architecture experience
- You bring strong SQL skills and experience with enterprise warehouse or lakehouse architecture
- You have used a data modeling tool, such as ERwin, ER/Studio, or another listed option
Who this fits
This senior associate role suits someone with substantial experience in data modeling and architecture. Financial services, regulatory reporting, enterprise-scale data work, and DAMA-DMBOK knowledge are preferred. Work visa sponsorship is unavailable.
From the employer
Line of Service
AdvisoryIndustry/Sector
TechnologySpecialism
Advisory - OtherManagement Level
Senior AssociateJob Description & Summary
Required Skills & Qualifications:
5-7 years of experience in data modeling and data architecture.
Strong knowledge of:
Dimensional modeling (Kimball)
Data Vault (preferred)
3NF / normalized modeling
Star & Snowflake schemas
Experience with enterprise data warehouse or lakehouse architecture.
Strong SQL skills.
Experience with modeling tools (ERwin, ER/Studio, PowerDesigner, or equivalent).
Experience in financial services, regulatory reporting, or large-scale enterprise data environments is preferred.
Knowledge of data governance frameworks (DAMA-DMBOK preferred).
Strong analytical and problem-solving skills.
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
Optional 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 {+ 27 more}Desired Languages (If blank, desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship?
NoGovernment Clearance Required?
NoJob Posting End Date