Senior Data Analytics Specialist - Centurion
Salary Negotiable
Centurion,
Gauteng
more than 14 days ago
Senior Data Analytics Specialist
Johannesburg Northern Suburbs
Support the business's existing MIS Databases, Reports and Dashboards, and its Data Warehouses, and enhancing them in future to provide business intelligence solutions and insights that enable management to make informed decisions that will drive business effectiveness, efficiency and help the business to meet its strategic objectives.
Maintain and support:
• Existing MIS databases
• Existing reports and dashboards
• Existing data warehouses
Principles:
Must be familiar with design patterns in data development industry, must have solid understanding of Metadata constructs, a clear understanding of EDW, knowledge of Domain driven design would be an advantage, must be familiar with the concept of Data Marts and with abstraction techniques.
Modelling:
Must have proven data modelling techniques (3 years), knowledge and experience in Ralph Kimball data warehouse modelling (3 years), knowledge of Immon data warehouse modelling techniques and data normalization skills most especially the 2nd Normal form.
Development Software:
The candidate must have advanced knowledge of T-SQL (4 years), dynamic T-SQL, multi-threading, performance optimisation and tuning, practical experience of SQL Server Database Engine (4 years), MS SSIS ETL software (4 years), MS SSAS OLAP software (4 years), MS Visual Studio Data Tools (4 years). Knowledge of Database Administration would add an advantage. Expert knowledge in configuration of database hardware resource.
Repository type:
The candidate must be able to source data from different repositories, must be fully acquainted with Microsoft SQL Server repository. Knowledge of Data Lake, Oracle and Hadoop will also be an advantage.
Relevant IT and data analytics qualifications, e.g. B.Tech or B.Sc. (Informatics)
Dimensional modelling and/or relevant Microsoft certification – Advantageous
On-the-job training / qualifications:
• Oracle
• Microsoft Sql Server
• Power BI
• Advanced MS Excel
• Starquest
Exposure to/experience in the Short-term Insurance industry will be an advantage.
Johannesburg Northern Suburbs
Support the business's existing MIS Databases, Reports and Dashboards, and its Data Warehouses, and enhancing them in future to provide business intelligence solutions and insights that enable management to make informed decisions that will drive business effectiveness, efficiency and help the business to meet its strategic objectives.
Maintain and support:
• Existing MIS databases
• Existing reports and dashboards
• Existing data warehouses
Principles:
Must be familiar with design patterns in data development industry, must have solid understanding of Metadata constructs, a clear understanding of EDW, knowledge of Domain driven design would be an advantage, must be familiar with the concept of Data Marts and with abstraction techniques.
Modelling:
Must have proven data modelling techniques (3 years), knowledge and experience in Ralph Kimball data warehouse modelling (3 years), knowledge of Immon data warehouse modelling techniques and data normalization skills most especially the 2nd Normal form.
Development Software:
The candidate must have advanced knowledge of T-SQL (4 years), dynamic T-SQL, multi-threading, performance optimisation and tuning, practical experience of SQL Server Database Engine (4 years), MS SSIS ETL software (4 years), MS SSAS OLAP software (4 years), MS Visual Studio Data Tools (4 years). Knowledge of Database Administration would add an advantage. Expert knowledge in configuration of database hardware resource.
Repository type:
The candidate must be able to source data from different repositories, must be fully acquainted with Microsoft SQL Server repository. Knowledge of Data Lake, Oracle and Hadoop will also be an advantage.
Relevant IT and data analytics qualifications, e.g. B.Tech or B.Sc. (Informatics)
Dimensional modelling and/or relevant Microsoft certification – Advantageous
On-the-job training / qualifications:
• Oracle
• Microsoft Sql Server
• Power BI
• Advanced MS Excel
• Starquest
Exposure to/experience in the Short-term Insurance industry will be an advantage.
Recruiter: Moving Heads Personnel