Junior Data Warehouse Developer

Momentum Group Limited (Momentum Group) is a significant player in South Africa's life insurance and integrated financial services sectors. We are a proud Level 1 B-BBEE South African-based group dedicated to building and protecting our clients' financial dreams. Our client-facing retail and specialist brands, including renowned names such as Momentum, Metropolitan, Guardrisk, and Eris Properties, play a pivotal role in fulfilling this purpose.

Our federated model emphasises empowerment, accountability, and continuous engagement with all our stakeholders. Designed in close consultation with leaders across the group, this operating model aims to unleash each business unit's inherent energy and commercial drive through our collaborative federated approach. Visit us at www.momentumgroupltd.co.za

Disclaimer As an applicant, please verify the legitimacy of this job advert on our company career page.

Role Purpose

Gather, analyse and interpret data from various sources, extract insights in a clear, precise and actionable manner, using easily understandable representations of data for both technical and non-technical audiences.

Requirements

Experience and Qualifications

• 3-year degree in Mathematics, Economics, Computer Science, Information Management or Statistics
• Introductory Cloud Certification - Desirable
• 1-3 years' experience as a Junior Data Warehouse/MIS Developer or related field (essential)
• Experience in ETL and visualisation tools (e.g. SQL, Informatica, QlikView, PowerBI etc.)
  
  

Duties & Responsibilities

Internal Process

• Develop Power BI solutions, working from high level technical requirements in line with business requirements.
• Quality assurance checks on all new Power BI project functionality and business requirements.
• Produce documentation for code written.
• Configure realtime replication of data from source system to the Data Warehouse, using tools like Stelo SQDR
• Partake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting
• Basic interaction and collaboration with technical stakeholders to identify data sources, find data definitions for master and meta data as well as formulate and implement solutions.
• Promote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant compliance and adherence to data governance principles.
• Promote reusability, maintainability, reliability, and scalability in design and development of data solutions.
• Process live and confidential data according to specified guidelines.
• Convert Legacy Excel reports to PowerBI
• Development and design of professional reports and dashboards to support various stakeholders within the company.
• Testing, debugging and reconciliation of data to source data to ensure data integrity.
• Ensure accuracy and integrity of data and its attribution to costs incurred by business.
• Communicate progress, including easily understandable representation of the data.
• Pro-active in suggesting for opportunities as well as making analytical observations on any aspect that would be beneficial to business.
  
  

Client

• Provide authoritative expertise and advice to clients and stakeholders.
• Continuous interaction with clients and internal stakeholders.
• Deliver on service level agreements made with clients and internal and external stakeholders in order to ensure that client expectations are managed
• Participate and contribute to a culture which builds rewarding relationships, facilitates feedback and provides exceptional client service.
  
  

People

• Develop and maintain productive and collaborative working relationships with peers and stakeholders.
• Continuously develop own expertise in terms of professional, industry and legislation knowledge.
• Contribute to continuous innovation through the development, sharing and implementation of new ideas.
• Take ownership for driving career development.
  
  

Competencies

Behavioural competencies required:

• Examining Information
• Generating Ideas
• Interpreting Data
• Articulating Information
• Producing Quality Output
• Providing Insights
• Team working
• Work output according to agreed standards
  
  

Skills required:

• Verbal and written communication
• Interpersonal skills
• Analytical skills
• Report writing
• Problem solving
• Attention to detail
• Teamwork
• Time Management
• Critical Thinking
  
  

Knowledge required:

• Business acumen
• Database development
• Software Development Lifecycle
• Intermediate SQL
• Intermediate Excel
• Intermediate Data visualisation
• Intermediate Data analysis
• Intermediate Data extraction
• Data reconciliation techniques
• Intermediate PowerBI
• Entry level Data Replication experience, e.g. Stelo SQDR, Qlik Replicate, etc.
• Intermediate SQL Server 2022
• Intermediate SSIS
• Intermediate SQL Developer/ Data Warehouse skills with MS T-SQL