16.03.2024
Data Modeler
PBT Group
South Africa, Cape Town
PBT Group has an opportunity for a Data Modeler to provide expertise, advice and support by designing and developing logical and physical data models and databases to meet the needs of the organisations information systems and business requirements. The Data Modeller is responsible for data standards and procedures, warehousing, distributed data management and information management functions. Duties:Manage cost related to income to increase profitability and efficiencies for the businessIncrease operational efficiency and suggest solutions to enhance cost effectiveness and prevent wastageIdentify process improvements in order to save costsIdentify, control and escalate potential risks which may lead to increased costsDeliver against operational and cost targetsDelivers internal and external customer service excellence through adherence to quality service standards for data managementAdhere to shared company values and service standards with regard to customer interaction.Resolve customer dissatisfaction/complaints by taking ownership of the problem.Analyse customer feedback to help improve customer service.Ensure that delivery is accurate, timeous and of an acceptable standard.Ensure that product knowledge and advice is technically accurate.Know and understand customer needs in order to deliver a quality service.Propose ideas to improve customer serviceCoordinate data models, dictionaries, and other database documentation across multiple applicationsMaintain the data dictionary internal and external to the data modelMaintain the business glossary internal and external to the data modelCreate logical and physical data models using best practices to ensure high dataquality and reduced redundancyOptimize and update logical and physical data models to support new and existing projectsEnsure that the source to target mapping is done in accordance to the requirementMaintain all ETL and business rules within the data modelMaintain all model related metadataDevelop best practices for standard naming conventions and coding practices to ensure consistency of data modelsRecommend opportunities for reuse of data models in new environmentsWork with data transformation teams to ensure that the model design and development is properly communicatedReview modifications to existing data modeling software to improve efficiency and performanceDevelop and maintain the Business MatrixManage the flow of information between departments using the data model designDevelop policies and procedures related to development and support of new and ongoing systems to ensure the integrity of dataAssure transformation rules are maintained, accurate and consistentPerform reverse engineering of physical data models from databases and SQL scriptsValidate business data objects for accuracy and completenessEvaluate data models and physical databases for variances and discrepanciesContinuously assess own performance, seek timely and clear feedback and requesttraining where appropriateIdentify effective activities to address own development gaps.Create own development plan and review plan with team leader.Understand which competencies and skills are required to be mastered to ensurepersonal development and performance Experience:6 to 8 years related experienceStrong technical and statistical model building, including scorecard and capital modelingMySQL Workbench, Erwin Data Modeller, MS Visio + Strong experience in Hybrid cloud environments, Strong analysis and communication skillsMySQL Workbench, Amundsen, Erwin Data Modeller, Lucid Chart, SQuirrel SQL Client, MS Visio, Enterprise Architect, Finance Domain knowledgeUse of macro-economic and other drivers to build technical predictive modelsQuick to understand client/user requirement. Ability to provide ideas which may have a bearing on design early in the processHighly skilled in flow diagrams. Provide for all possible loops to make coding and numerical process easyVery experienced individual who demonstrates advanced level of numerical/statistical proficiency. Solution offers lots of features that provide for business policy rules and will be functional to client, (e.g. appropriately measure and quantify the degree of new business risk being written.)Ability to coordinate multiple projects and officially hand over end-product to client, providing the necessary demonstration and is able to answer complex questions relevant to the modelHigh level evaluation of model/s. Assesses how different models best serve client requirements. Informed on model building best practice and provides thought leadership on model design Qualifications/ Certification:Minimum: Relevant B.Sc or B.Com degreePreferred: Honours degree with focus in Information Management * In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent
Attention! You will be redirected to another site