Jobs Career Advice Signup
X

Send this job to a friend

X

Did you notice an error or suspect this job is scam? Tell us.

  • Posted: Oct 20, 2020
    Deadline: Not specified
    • @gmail.com
    • @yahoo.com
    • @outlook.com
  • Want to get a job fast? Signup and complete your profile on MyJobMag. Employers will find you 4x faster with a complete profile. You can download your completed profile anytime

    Momentum Metropolitan Holdings, formerly MMI Holdings, is a South African-based financial services group was established on 1 Dec 2010, through the merger of Metropolitan and Momentum. We are specialists in long and short-term insurance, asset management, savings, investments, healthcare administration, health risk management, employee benefits and reward...
    Read more about this company

     

    Data Warehouse Engineer

    Introduction

    • Metropolitan is one of the oldest financial services brands in South Africa. With a 116 year legacy of serving the communities in which it operates, Metropolitan represents true empowerment in serving Africa's people through affordable financial solutions that create financial growth and security. Metropolitan operates in South Africa, but the brand is also present in 9 African countries including, Namibia, Botswana, Kenya, Ghana, Nigeria, Lesotho, and Swaziland. Metropolitan provides financial wellness solutions that meet the needs of low income clients, including funeral insurance, health, savings, hospital cash-back cover, retirement solutions and life insurance.www.metropolitan.co.za

    Role Purpose

    • The Data Warehouse Engineer is tasked with overseeing the full life-cycle of back-end development of the business's data warehouse. The Data Warehouse Engineer is responsible for the development of ETL processes and various administration and dimensional design of the table structures. The Data Warehouse Engineer works closely with various internal stakeholders, including, but not limited to data analysts and senior data teams in order to power insight and avail meaningful data products for the business and enable consistently informed management decisions.

    What you're going to do

    ETL: Develop and maintain the ETL processes:

    • Identify, analyse, design and maintain the loading of data into the warehouse from different source environments.
    • Use Linux shell script to code jobs to run ETL.
    • Do necessary checks to ensure that the tables loaded balances back to the operational system in terms of control totals and record counts as per Audit requirements.
    • Develop and maintain procedures and standards for processes e.g.
      • Extraction and loading of data
      • Coding and naming standards
      • Scheduling of DWH scripts and jobs.
    • Develop Change control standards.
    • Do all of the above in accordance with best practice, standards and procedures as approved by the database manager and SAS 70.

    Database maintenance:

    • Identifying potential improvements to the design of the warehouse and ETL processes.
    • Maintain security and access to the database.
    • Monitor the database and tables space usage.
    • Archive historical data and delete unused tables.
    • DWH performance monitoring and performance.
    • Core system availability (99.99%).
    • Data trends, forecasting, Statistics and Reporting.
    • Limit Priority 1's.
    • Extended Operational support (24/7).

    Provide Technical Support:

    • Providing technical support and assistance to the Business Intelligence and IT developers.
    • Assist Business Intelligence in the creation of summary tables and data marts that will deliver information to internal as well as external clients.
    • Approve, schedule and test code.
    • Assist business users in validating production data and trouble-shoot problems.

    Effective Project Delivery:

    • Participate in Metropolitan Health projects e.g.:
      • Migration
      • Upgrades
      • New system developments and year-end projects.
      • DWH Audit - internal and external.
    • Effective project delivery - Delivery of projects on time within the agreed budgets.
    • Ensure Continuous Service Improvement (CSI).
    • Achieving Operational Excellence.
    • Innovation:
    • Promote new techniques and Data Warehousing tools that shape the future of the Data Warehousing in the business, i.e. Unstructured data, Data Lakes, Apache Hadoop/ Spark/Hive/Kafka.
    • Objectives:
    • Continually finding new ways of cost savings.
    • Team Relationship management - Engaging and partnering with other IT and Business support teams.
    • Ensuring effective service delivery to our Business Partners - are we focussing on the right things.
    • Manage own performance and development.

    Requirements

    Minimum Qualifications:

    • Grade 12/Matric or Equivalent.
    • Relevant tertiary qualification (e.g. Computer Science degree / diploma or IT-related degree).

    Minimum Experience:

    • 5 - 7 years of experience in IT.
    • Data Warehousing experience (current).
    • Engagement with internal stakeholders with regards to setting up controls (processes and standards).
    • Bigger picture and attention to detail orientation.
    • SQL advanced coding.
    • Understanding of data.
    • Ability to present information best aligned to business needs.
    • Understanding of BI.
    • Database administration (advantageous).
    • Basic Linux shell scripting (requirement),
    • Analytical skills, problem solving,
    • Initiative, take responsibility for challenges, persistence (come up with solutions),
    • Flexibility with regards to thinking (different perspectives),

    Competencies required

    • Business Acumen.
    • Client/Stakeholder Commitment.
    • Drive for Results.
    • Leads Change and Innovation.
    • Strategic Thinking.
    • Collaboration and Teamwork.
    • Impact and Influence.
    • Self-Awareness and Insight.
    • Diversity and Inclusiveness.

    Additional Information

    Shortlisted candidates will be subjected to the following statutory checks:

    • Reference
    • ITC
    • Qualification
    • Criminal
    • Psychometric Assessment

    We reserve the right not to fill the vacancy. Should you not receive any response in respect of your application within 2 weeks, please consider your application unsuccessful.

    Disclaimer

    • Only on-line applications submitted via our careers page will be considered.
    • Internal Team Members must inform their manager of their application. Your manager must be aware of and support your application.

    Method of Application

    Interested and qualified? Go to Momentum Metropolitan Holdings Limited on www.linkedin.com to apply

    Learn how to get a job in any industry you want. Read 72 Hours to The Job You Love

  • Send your application

Back To Home

Career Advice

  • Product Manager Job Description

    Product management is one of the highest paying jobs. This is because it is an integral part of an organization’s operation. As the name entails, product ...

    Read More

  • Cover Letter Writing Tips

    Let’s be honest. Writing a cover letter can be dreadful. This is even more stressful when you are applying for different positions. When tasked with writing...

    Read More

  • Organizational Skills To Have On Your Resume

    Organizational skills are one of the key transferable skills that every job seeker is encouraged to have. This is because employers are on the lookout for ...

    Read More

  • Administrator Job Description

    Ever wondered how workplaces with multiple units and subdivisions are kept organized? Well, that’s because they most likely employ the services of an administ...

    Read More

View All Career Advice

Subscribe to Job Alert

 

Join our happy subscribers

This website uses cookies to improve your experience. By using this site you agree to the storing of cookies on your device to enhance navigation, analyze site usage, and assist in our marketing efforts. To learn more, see our Cookie Policy. Accept and Close
 
 
 
Send your application through

Yahoomail Gmail Hotmail