BI Specialist: Data Warehouse l ELT l Data Marts l PowerBI l Metadata l OLAP l Data Lake

SUMMARY:
-

POSITION INFO:

Data Analytics Specialist: Financial Services Industry

Maintain and support:

• Existing MIS databases l Reports and dashboards l Data Warehouses
• Develop, test, deploy, maintain, and support new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.
• Remain informed about developments and trends in the data enablement field to assist the business to keep its data analytics and management capability up-to-date, and able to meet the future needs of the business in a constantly maturing and increasingly complex short-term insurance industry.
• Collaborate with Project Managers and Business Leaders to deliver quality, effective management information, data warehouse and business intelligence applications, in line with the agreed development process and business needs.
• Collaborate with stakeholders to gather requirements, conduct analysis, and prioritize requests.
• Conduct research and evaluate potential technical solutions to identified business problems.
• Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.
• Design and code new database and analytics functionality using code that is readable, maintainable, and re-usable.
• Conduct Unit Testing of own code and resolve all issues/queries timeously.
• Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly
• Deliver solutions into the applicable production environment once testing has been completed.
• Provide stakeholders with regular feedback on the technical design and timelines for solution ensuring that business needs are met.
• Maintain existing databases and applications according to change requests approved by business as and when needed.
• Diagnose root causes of issues through problem-solving and recommend potential solutions.
• Monitor performance of solutions and make recommendations to improve the performance and functionality of the solutions, where appropriate.
• Log issues found in existing systems as internal change controls and ensure successful resolution of issues.

Role-Specific Responsibilities and Outputs:

Develop, implement, and document Business Intelligence Solutions (Internal Process):

• Contribute to the overall data warehouse architecture and data base designs
• Maintain and oversee the administration and maintenance of the data warehouse
• Develop and maintain Business Intelligence and reporting technologies and processes
• Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications
• Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications
• Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions
• Ensure the continued maintenance and enhancement to existing business intelligence solutions
• Within user specifications extract, transform and load (ELT) data using the relevant tools
• Verify and quality assure of data provided
• Provide support to business intelligence users on data-related issues
• Future development and planning
• Conduct research and undergo training where appropriate, to remain abreast of data enablement trends and understand their application in the short-term insurance industry
• Assist management and colleagues to make the right decisions in terms of planning future data enablement infrastructure, architecture, and applications in the Momentum short-term insurance business, in alignment with Momentum Metropolitan group standards and the South African financial services regulatory framework.

Self-Management and Teamwork:

• Provide authoritative expertise and advice to colleagues
• Develop and maintain productive and collaborative working relationships with peers and team members.
• Deliver on Service Level Agreements made with colleagues
• Continuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specialization
• Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
• Contribute to continuous innovation through the development, sharing and implementation of new ideas and involvement of peers.
• Take ownership for driving career development.

Finance:

• Manage financial and other company resources under your control with due respect.

Qualifications& Experience:

B.Tech or B.Sc. (Informatics)

Dimensional modelling and/or relevant Microsoft certification l Essential

Microsoft SQL Server l Oracle l Power BI l Advanced MS Excel l Starquest

Methodologies: elicit data requirements from stakeholders l documentation skills

Principles: design patterns in data development industry l Metadata constructs l EDW l Domain driven design l Data Marts l abstraction techniques

Modelling: data modelling techniques (3 years) l Ralph Kimball data warehouse modelling l Immon data warehouse modelling l data normalization skills most especially the 2nd Normal form

Data Transportation: ETL systems l sourcing, staging, and loading l parallel loading principles l source to target mapping

Development Software: T-SQL (4 years) and the following concepts l Dynamic T-SQL l multi-threading

Performance optimization and tuning: SQL Server Database Engine (4 years) l MS SSIS ETL software (4 years) l MS SSAS OLAP software (4 years) l MS Visual Studio Data Tools (4 years) l Database Administration would add an advantage l database hardware resource

Repository type: source data from different repositories l Microsoft SQL Server repository l Data Lake would be an advantage l Oracle would be an advantage l Hadoop is not essential but will also be an advantage l

Jino.swart@isilumko.co.za

NB! This job is now closed. You can apply for other jobs by uploading your CV.