Data Warehousing Spe....
Data Warehousing Specialist
Posted on :
05-02-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
05-02-2024
Job Description
Req ID : 2505023
Role Purpose
Maintain and support:
- Existing MIS databases
- Existing reports and dashboards
- Existing data warehouses
Develop test deploy maintain and support new databases and reporting data warehouse and business intelligence applications from highlevel 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 uptodate and able to meet the future needs of the business in a constantly maturing and increasingly complex shortterm insurance industry.
Outputs
nternal Process
- 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 prioritise 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 reusable.
- 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 problemsolving 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.
Rolespecific 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 datarelated issues
- Future development and planning
- Conduct research and undergo training where appropriate in order to remain abreast of data enablement trends and understand their application in the shortterm insurance industry
- 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 specialisation.
- Participate and contribute to a culture of workcentric 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.
Competencies required
- Business Acumen
- Client / Stakeholder Commitment
- Drive for Results
- Leads Change and Innovation
- Motivating and Inspiring Team
- Collaboration
- Impact and Influence
- SelfAwareness and Insight
- Diversity and Inclusiveness
- Growing Talent
Skills
- Communication – articulating information and challenging ideas
- Analysing and interpreting data
- Problemsolving
- Planning and organising – time and task management
- Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) Essential
- Dimensional modelling and/or relevant Microsoft certification Advantageous
On thejob training/qualifications:
- Microsoft Sql Server
- Oracle
- Power BI
- Advanced MS Excel
- Starquest
Some experience in predictive analytic platforms will be advantageous.
These include:
- Python
- Scala
- Spark
- AWS Sagemaker
Some experience in Azure / AWS platform services will be advantageous. These include:
- Azure SQL elastic instance
- Data factory
- PowerBI
- AWS RDS
Minimum Experience
Methodologies
- The candidate must have ability to elicit data requirements from stakeholders
- The candidate must have clear documentation skills
- The candidate must be familiar with design patterns in data development industry.
- The candidate must have solid understanding of Metadata constructs.
- The candidate must have clear understanding of EDW
- Knowledge of Domain driven design would be an advantage
- The candidate must be familiar with the concept of Data Marts
- The candidate must be familiar with abstraction techniques
- The candidate must have proven data modelling techniques (3 years)
- The candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years)
- Knowledge of Immon data warehouse modelling techniques would add an advantage
- The candidate must have data normalization skills most especially the 2nd Normal form
- The candidate must have solid experience of ETL systems
- The candidate must have solid experience of sourcing staging and loading
- The candidate must be familiar with parallel loading principles
- The candidate must be familiar with source to target mapping
- The candidate must have advanced knowledge of TSQL (4 years) and the following concepts
- Dynamic TSQL
- Multithreading
- Performance optimisation and tuning
- The candidate must have practical experience of SQL Server Database Engine (4 years)
- The candidate must have practical experience of MS SSIS ETL software (4 years)
- The candidate must have practical experience of MS SSAS OLAP software (4 years)
- The candidate must have practical experience of MS Visual Studio Data Tools (4 years)
- Knowledge of Database Administration would add an advantage
- Expert knowledge in configuration of database hardware resources
- The candidate must be able to source data from different repositories
- The candidate must be fully acquainted with Microsoft SQL Server repository
- Knowledge of Data Lake would be an advantage
- Knowledge of Oracle would be an advantage
- Knowledge of Hadoop is not essential but will also be an advantage
Location
The abovementioned position is based in Centurion
Employment Type
Full Time
Key Skills
- GIS
- Computer Data Entry
- Facilities Management
- ADMA
- Fleet
- Key Account
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
