Business Intelligence Solutions Engineer at ooba

JOB DESCRIPTION

• The Business Information team is looking for a dynamic individual to help them maximise the value embedded in ooba's data.
• The role includes approximately 50% engineering and architecture duties that will require this person to collaborate to define and implement the BI roadmap.
• The balance of the role is BI development and governance. This includes SQL development, BI publisher template development, PBI development as well as loading of data into systems for relevant reporting. 
• They must be able to analyse data and understand how to use it. Ultimately using this insight to create the relevant data structures and create the reports required.

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