Job Description

Business Intelligence Data Modeler (Contract) South Africa/Hybrid
Our client requires the services of a Business Intelligence Data Modeler, responsible for designing, structuring, and optimising enterprise data models that support reporting, analytics, data products, and application needs. This role ensures data is well-organised, governed, and aligned to business definitions, enabling trusted, scalable, and high-performance insights across the organisation.
Contract Details:

• Working Model: Hybrid
• Assignment: Contract role for initial 6 months (possibility of renewal).
• Commencement: As soon as possible.

Key Responsibilities
Data Modelling (Conceptual, Logical, Physical)

• Design and maintain conceptual, logical, and physical data models.
• Develop dimensional models including star schemas, snowflake schemas, relational models, and semantic layers.
• Translate business rules, KPIs, and reporting requirements into robust modelling structures.

Collaboration & Requirements Alignment

• Work closely with Business Analysts to interpret reporting and analytical requirements.
• Partner with Data Engineers to implement data models within ETL/ELT pipelines.
• Collaborate with BI developers to ensure data model alignment with dashboards and reports.

Metadata Management & Documentation

• Maintain data dictionaries, entity relationship diagrams (ERDs), and data lineage artefacts.
• Define and manage business terms, hierarchies, and data relationships.
• Ensure data documentation is accurate, accessible, and maintained for analysts and developers.

Data Quality & Governance

• Ensure consistency in KPI definitions, metrics, and transformation logic.
• Support data governance initiatives, standards, and naming conventions.
• Conduct model reviews, audits, and optimisation assessments.

Optimisation & Best Practices

• Optimise data models for performance, scalability, and long-term maintainability.
• Apply enterprise data modelling standards, patterns, and best practices.
• Enable self-service analytics through well-designed semantic and business layers.

Qualifications & Experience
Education:

• Degree in Computer Science, Information Systems, or a related field.

Experience:

• 3-5+ years' experience in data modelling, data architecture, or related roles.
• Experience working within business intelligence and enterprise reporting environments.

Knowledge & Skills
Technical Skills:

• Strong experience with data modelling tools such as ERWIN, PowerDesigner, dbt, SAP BW/4HANA Modelling, or equivalent.
• Deep understanding of relational and dimensional data modelling techniques.
• Experience working with cloud data platforms including Azure Synapse, Snowflake, BigQuery, or AWS Redshift.
• Advanced SQL skills for data analysis, validation, and modelling support.

Soft Skills:

• Strong analytical mindset with high attention to detail.
• Ability to translate complex business processes into clear, scalable data structures.
• Excellent documentation, communication, and stakeholder engagement skills.

#FuelledbyPassionIntegrityExcellence #isanqa #isanqaresourcing #isanqajobs #DataModeler #BusinessIntelligence #DataArchitecture #DimensionalModeling #StarSchema #SQL #CloudData #AzureSynapse #Snowflake #AnalyticsEngineering #HybridWork #ITCareers #SouthAfricaJobs

Skills Required