Data Modeler

2 weeks ago


Johannesburg, South Africa iCore Full time

Looking for a Data Modeler at one of our client locations Johannesburg

Qualifications: Minimum of 4-year tertiary qualification in Engineering, Data Sciences, Computer Science, or IT Experience working with conventional relational database management systems and new Big Data Platforms and Systems.
- Understanding of entity-relationship modeling techniques.
- Understanding of normalization and denormalization.
- Highly proficient in logical dimensional data model and star-schema design.
- Knowledge of generalization and abstraction techniques in data warehouse design.
- Understanding of data store modeling (schema on write) and data access modeling (schema on read) and when to use each.
- SQL knowledge (both Oracle SQL and Hive SQL).
- 5+ years’ experience in working in data warehouse design and implementation.
- Proven abilities to take initiative and be innovative.
- Telecommunications industry experience would be beneficial.
- English fluency for written and verbal communication.
- Must have advanced analytical and problem-solving skills as well as strong knowledge of current industry and data modeling best practices.
- Strong communication skill within a client-facing environment is essential.
- The ability to engage with confidence across the organisation structures is a key advantage.
- Needs to be self-driven, ability to work under pressure, by meeting deadlines effectively and efficiently.

Duties

The data modeler will work with the data architects and analysts to design data structures that will meet organizational needs using conceptual, logical, and physical data models.
- Data Model Design for the curated Data Lake environment and for the dimensional data marts to enable transformation of raw data into meaningful insights.
- Responsible for liaison with data analysts and data architects to fully understand all the source systems and the information available in them and leverage this understanding in the data model design.
- Responsible for utilising and including industry and organisational best practices, principles, guidelines, frameworks and templates in the design of the data structures.
- Supporting the conversion of a logical/conceptual data model to the physical data model and providing the support for the ETL design to populate the physical model. - Creation and maintenance of the Data Dictionary which details, field by field, the datatypes, the field meanings in organizational context and what are the pieces of information which will be mapped and stored in the physical model to meet the BI requirements.
- Creation and maintenance of the data map/ source to target mapping that will show how the data will move from the source systems to the physical model including transformation rules or how the data from different systems will be integrated together to populate the physical model. - Identifying the Master data sources to support the data model.
- Providing inputs into the ETL design.
- Producing and maintaining the artefacts to showcase requirements coverage through the logical and physical models.
- Identifying the business reference data requirements and to design the structures to hold and maintain the business reference data.
- Considering the history/ data retention requirements in the design of the dimensions, aggregates, summaries etc.
- Design of the analytical or denormalized records based on business needs, reporting needs or needs of a data service.
- Keeping abreast of global and local best practices as it relates data architecture and data modelling.
- Develop best practices for standard naming conventions and schema design to ensure consistency of data models.

**Salary**: From R25,350.75 per month

Ability to commute/relocate:

- Johannesburg, Gauteng: Reliably commute or planning to relocate before starting work (required)


  • Data Modeler

    6 days ago


    Johannesburg, South Africa PBT Group Full time

    Data Modeler required for a vacancy at PBT Group. **Duties**: - Create and implement comprehensive logical and physical data models. - Perform detailed data analysis in order to develop the data warehouse’s / BI solution’s data model. - Involved in the requirements definition process. - Assist the ETL Analysts / Business Analysts with the specification...

  • Data Modeler

    Found in: Whatjobs ZA C2 - 1 week ago


    Johannesburg, South Africa IOCO Full time

    We are seeking a talented and experienced Data Modeler to join our dynamic team at iOCO. As a Data Modeler, you will play a crucial role in designing, implementing, and maintaining data models that facilitate efficient storage, retrieval, and analysis of data across various systems and platforms. You will collaborate closely with stakeholders, including...

  • Data Modeler

    Found in: Adzuna ZA B C2 - 3 weeks ago


    Johannesburg, South Africa Adzuna ZA B C2 Full time

    We are seeking a talented and experienced Data Modeler to join our dynamic team at iOCO. As a Data Modeler, you will play a crucial role in designing, implementing, and maintaining data models that facilitate efficient storage, retrieval, and analysis of data across various systems and platforms. You will collaborate closely with stakeholders, including...

  • Data Modeler

    Found in: Talent ZA 2A C2 - 3 weeks ago


    Johannesburg, South Africa IOCO Full time

    We are seeking a talented and experienced Data Modeler to join our dynamic team at iOCO. As a Data Modeler, you will play a crucial role in designing, implementing, and maintaining data models that facilitate efficient storage, retrieval, and analysis of data across various systems and platforms. You will collaborate closely with stakeholders, including...

  • Data Modeller

    Found in: beBee S ZA - 4 weeks ago


    Johannesburg, South Africa SabenzaIT Full time

    Our client, a huge player in the Multimedia & Entertainment sector, is on the hunt for a Data Modeller, i.e. a Data Analyst.  If you are in the Johannesburg area and are a master with all things data and analytics, read on!!!  Essential Qualifications:Covid-19 VaccinationA Bachelor’s Degree in Computer Science, Information Technology or Equivalent...


  • Johannesburg, South Africa Absa Bank Limited Full time

    Bring your possibility to life! Define your career with us - With over 100 years of rich history and strongly positioned as a local bank with regional and international expertise, a career with our family offers the opportunity to be part of this exciting growth journey, to reset our future and shape our destiny as a proudly African group.Job Summary Join...

  • Data Modeler

    5 days ago


    Johannesburg, South Africa SyncNodes Full time

    3yrs IT related experience with 2yrs+ in a Data Modelling role Experience in NOSql and other forms of database modelling advantageous **Certification**: TOGAF, DAMA Advanced Diplomas/National 1st Degrees/equivalent NQF level 6 qualification Able to demonstrate practical experience in relational and dimensional modelling techniques, OO modelling...

  • Data Modeler

    2 weeks ago


    Johannesburg, South Africa SyncNodes Full time

    3yrs IT related experience with 2yrs+ in a Data Modelling role Advanced Diplomas/National 1st Degrees/equivalent NQF level 6 qualification TOGAF, DAMA Able to demonstrate practical experience in relational and dimensional modelling techniques,OO modelling experience also an advantage Exprience using Infosphere Data Architect or any other Data Modelling...

  • Data Architect

    Found in: Talent ZA C2 - 3 weeks ago


    Johannesburg, South Africa Dimension Data Full time

    FunctieomschrijvingAre you tired of being micro managed? Do you want to work for a company where the CEO acts like a consultant and has few final decisions to make? We are looking for an experienced Data Architect who can deliver complex data solutions with minimal oversight.As a Data Architect, you'll be responsible for designing and implementing the...

  • Financial Modeller

    5 days ago


    Johannesburg, South Africa Communicate Recruitment Full time

    One of the biggest boutique Advisory Firms in the country is looking for a Financial Modeller to join the team to build and develop transaction financial models from scratch. You will have complete freedom and work remotely! **Job & Company Description**: The main duties and responsibilities will include, amongst others: - Develop and maintain appropriate...

  • Financial Modeller

    5 days ago


    Johannesburg, South Africa Communicate Recruitment Full time

    Are you an experienced Financial Modeller looking for a new challenge? We're currently seeking a highly skilled and motivated Financial Modeller to join our team. In this role, you will play a critical role in driving the success of our organization by developing and maintaining complex financial models that support strategic decision-making. As a key...

  • Model Risk Manager

    2 days ago


    Johannesburg, South Africa Communicate Recruitment Full time

    Looking for a talented and driven Model Risk Manager to join our team We are a leading financial institution seeking an experienced Manager with expertise in credit, market risk, and insurance modeling. As the Model Risk Manager you will be responsible for ensuring that all models used by the company are accurate, reliable, and meet regulatory...

  • Model Risk Specialist

    2 weeks ago


    Johannesburg, South Africa FirstRand Full time

    About us, purpose, experience and qualifications **about us**: **purpose**: **experience and qualifications**: - Essential Qualification: Bachelor’s degree (Honours preferrable) in one of the following disciplines: Statistics, Mathematics, Quantitative Risk Management, Engineering, Actuarial science, Data science or similar. - Experience: 2-4+ years of...


  • Johannesburg, South Africa Absa Bank Limited Full time

    Bring your possibility to life! Define your career with us - With over 100 years of rich history and strongly positioned as a local bank with regional and international expertise, a career with our family offers the opportunity to be part of this exciting growth journey, to reset our future and shape our destiny as a proudly African group.Job...

  • Credit Analytics

    Found in: Whatjobs ZA C2 - 1 week ago


    Johannesburg, South Africa Top Talent Professional Services Full time

    JOB PURPOSE The Credit Analytics and Modeling Manager is a modeling expert that apply a credit risk background in the telecommunications industry, mainly on the postpaid contracts. The role requires a good understanding of credit risk, out of the box thinking and analyzing large quantities of data in order to positively affect profitability and credit...

  • Credit Analytics

    Found in: Talent ZA 2A C2 - 3 weeks ago


    Johannesburg, South Africa Top Talent Professional Services Full time

    JOB PURPOSEThe Credit Analytics and Modeling Manager is a modeling expert that apply a credit risk background in the telecommunications industry, mainly on the postpaid contracts. The role requires a good understanding of credit risk, out of the box thinking and analyzing large quantities of data in order to positively affect profitability and credit losses....

  • Model Risk Specialist

    Found in: beBee S ZA - 4 weeks ago


    Johannesburg, South Africa FirstRand Full time

    Job DescriptionHello future Model Risk Analyst FirstRand believes that its people are its single most important resource and will not operate in a sector unless it has people who are right for that market and who share FirstRand's business values. We recruit self-starters who have a passion for what they do. We empower them, hold them accountable and reward...

  • Data Scientist

    3 weeks ago


    Johannesburg, South Africa FirstRand Full time

    Job Description To plan, build, optimise and implement innovative quantitative analytical methodologies, procedures, products and advanced mathematical models that provide analytical support and interpret insights, using advanced analytics technologies, to address business opportunities and problems and implement business strategy. - Take all necessary...

  • Data Scientist

    5 days ago


    Johannesburg, South Africa FirstRand Full time

    Job Description To plan, build, optimise and implement innovative quantitative analytical methodologies, procedures, products and advanced mathematical models that provide analytical support and interpret insights, to address business opportunities and problems and implement business strategy, with mínimal guidance. - Take all necessary actions to ensure...

  • Data Architect

    5 days ago


    Johannesburg, South Africa Intellinexus Full time

    **Intellinexus in a nutshell**: **Intellinexus, What we offer**: - Intellinexus offers remote and hybrid opportunities. - Intellinexus is an SME and therefore you get a lot more exposure to different technologies, solutions, techniques and perspectives during projects, which you might be excluded from in other firms with specialists in those areas. -...