Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailLine of Service
AdvisoryIndustry/Sector
Not ApplicableSpecialism
Technology StrategyManagement Level
Senior AssociateJob Description & Summary
At PwC our people in infrastructure focus on designing and implementing robust secure IT systems that support business operations. They enable the smooth functioning of networks servers and data centres to optimise performance and minimise downtime.Data Modeler
Job Description:
Looking for candidates with a strong background in data modeling metadata management and data system optimization. You will be responsible for analyzing business needs developing long term data models and ensuring the efficiency and consistency of our data systems.
Key areas of expertise include
Analyze and translate business needs into long term solution data models.
Evaluate existing data systems and recommend improvements.
Define rules to translate and transform data across data models.
Work with the development team to create conceptual data models and data flows.
Develop best practices for data coding to ensure consistency within the system.
Review modifications of existing systems for cross compatibility.
Implement data strategies and develop physical data models.
Update and optimize local and metadata models.
Utilize canonical data modeling techniques to enhance data system efficiency.
Evaluate implemented data systems for variances discrepancies and efficiency.
Troubleshoot and optimize data systems to ensure optimal performance.
Strong expertise in relational and dimensional modeling (OLTP OLAP).
Experience with data modeling tools (Erwin ER/Studio Visio PowerDesigner.
Proficiency in SQL and database management systems (Oracle SQL Server MySQL PostgreSQL).
Knowledge of NoSQL databases (MongoDB Cassandra) and their data structures.
Experience working with data warehouses and BI tools (Snowflake Redshift BigQuery Tableau Power BI).
Familiarity with ETL processes data integration and data governance frameworks.
Strong analytical problemsolving and communication skills.
Qualifications:
Bachelors degree in Engineering or a related field.
5 to 9 years of experience in data modeling or a related field.
4 years of handson experience with dimensional and relational data modeling.
Expert knowledge of metadata management and related tools.
Proficiency with data modeling tools such as Erwin Power Designer or Lucid.
Knowledge of transactional databases and data warehouses.
Preferred Skills:
Experience in cloudbased data solutions (AWS Azure GCP).
Knowledge of big data technologies (Hadoop Spark Kafka).
Understanding of graph databases and realtime data processing.
Certifications in data management modeling or cloud data engineering.
Excellent communication and presentation skills.
Strong interpersonal skills to collaborate effectively with various teams.
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 Analytical Thinking Architectural Engineering Cloud Virtualization Communication Continuous Deployment Continuous Integration/Continuous Delivery (CI/CD) Creativity Data Infrastructure DevOps Practices Embracing Change Emotional Regulation Empathy Hardware Troubleshooting Inclusion Infrastructure Architecture Infrastructure Management Infrastructure Monitoring Infrastructure Optimization Infrastructure Services Infrastructure Support Intellectual Curiosity IT Infrastructure 18 moreDesired Languages (If blank desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship
NoGovernment Clearance Required
YesJob Posting End Date
Required Experience:
Senior IC
Full-Time