BI Developer
The successful incumbent will be responsible for developing scalable and robust data solutions for integrating data from disparate sources into the Data Warehouse and Analytical Platform that will support diverse reporting and analytical capabilities.
MAIN DUTIES AND RESPONSIBILITIES:
Give input into the impact analysis for new BI solutions providing detailed development estimates, the technical feasibility of and risks associated with each solution design/project
Work with other team members to analyse and recommend an end to end BI solution that meet business and data requirements
Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture, data integration standards and best practices
Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling
Maintain and optimise data integration procedures
Conduct review of other integration developers' development efforts to ensure consistent methodologies are followed and to make recommendations where necessary
Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution
Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis
QUALIFICATIONS AND EXPERIENCE:
Relevant 3-year tertiary or NQF aligned qualification
Up to 5 years' experience in IT, with a minimum of 3 years in a BI Data role
Proven track record of delivery BI technical solutions on large- to medium-size BI projects
Proven application of Data Warehousing and BI best practices
Proven track record of implementing innovative BI solutions leading to clear business benefits
Knowledge of Data Warehousing concepts and Proven Report and Query writing ability
Strong PL/SQL or T-SQL coding skills, and solid understanding of complex ETL packages
Competencies in Cloud platforms and Big Data will be an advantage
In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies)
Extensive knowledge and experience in maintainability, scalability and performance of BI environments
In depth knowledge of Power BI and the Microsoft suite of data analytics tools
Disciplined in applying BI standards but open to suggestion and change
Meticulous and attention-to-detail focus
Self-motivated with a can-do attitude
Interested parties should send a CV and copies of certificates to: so@menar.com
Menar is an equal opportunity and affirmative action employer. A shortlist will be compiled and selected applications will be invited for an interview. If no response is received within one month, applicants may assume their applications to be unsuccessful. All original certificates and proof of experience must be produced at the interview.
Closing date: 4 September 2020
