Business Intelligence Solutions Engineer - Western Cape at ooba

RESPONSIBILITIES

BI and data Roadmap Planning:

• Develop and communicate a strategic plan for the ooba's BI and data infrastructure, encompassing ETL processes, data models, reporting tools, and cloud migration strategies which will be clearly outlined in a roadmap.
• Create end-to-end data solutions, considering cloud-native technologies, ETL optimizations, and data modeling best practices.

Reporting Excellence:

• Collaborate to development interactive and insightful reports using tools like PowerBI, catering to the specific needs of stakeholders across the organization.
• Collaborate on report visualization and delivery methods to meet the business needs.
• Creation of robust data extracts for analysis purposes and ensuring that this code is reusable when required elsewhere and these extracts become reports as required.

Data Governance and Compliance:

• Implement and enforce robust data governance policies, ensuring data security, quality and compliance with industry regulations and ooba's architectural and security standards.
• Code reviews, implementation reviews and sizing reviews of internal and external deliverables.
• Implement performance and health monitoring of BI systems, data integrations and reports performance and delivery.

Continuous Improvement and Training:

• Identify opportunities for process optimization and automation within the data pipeline, while also conducting training sessions for team members and end-users on new technologies and practices.
• Create the data structures, SQL queries, views etc. on which reports will be based and deliver reports in the BI  technologies available at ooba.

Other duties and things to consider

• Unified Data Model implementation: Implement a unified PowerBI data model, providing a cohesive structure for diverse data sources and facilitating seamless reporting and analytics.
• Cloud Migration Execution: If justified and we decide to go this route. Lead the execution of the cloud migration plan, ensuring a smooth transition of data solutions to cloud platforms while minimizing disruptions.
• ETL Optimization: Continuously optimize ETL processes for efficiency, scalability, and reliability, ensuring timely and accurate data extraction, transformation and loading.
• Consolidation and Integration: Establish and maintain a consolidated database that integrates data from various sources, emphasizing data quality, integrity and accessibility.
• Cross-Functional Collaboration: Act as a liaison between tchnical and non-technical teams, collaborating with stakeholders to understand their data needs and align solutions accordingly.
• Help to analyse/identify and implement data fixes.

QUALIFICATIONS

• 5+ years of recent BI Developer (or Oracle SQL)
• Microsoft Power BI and MS Excel advanced
• Relational database systems
• Working on an enterprise level BI development platform
• Data Science or ICT diploma/degree

Critical Competencies

• Accuracy
• Devotion to quality
• Planning
• Performing under pressure
• Result-oriented
• Analyzing and forming opinions
• Creating support
• Cooperation
• Assertiveness