Systems Developer

The Systems Developer is responsible for the analysis, design, development and testing of the business intelligence components according to business requirements and the overall business intelligence architecture. This role will mainly deliver on the BI requirements for tertiary and schools units.

Team Leadership

• Lead the design, development, and deployment of BI solutions
• Create an inspiring team environment with an open communication culture
• Partner with various teams to ensure the applications are delivered on time and to the technical excellence demanded
• Set clear team goals
• Delegate tasks and set deadlines
• Oversee day-to-day dev operations
• Monitor team performance and report on metrics
• Motivate team members
• Discover training needs and provide coaching
• Listen to team members’ feedback and resolve any issues or conflicts
• Encourage creativity and innovative thinking

Data Modelling & Data Engineering

• Gather user requirements and identify new data modelling and engineering features and carry necessary improvements as needed.
• Evaluate data architecture specifications and establish an architecture framework for applicable BI Systems.
• Develop conceptual, logical and physical data models.
• Design the Enterprise Data Model for KITSO and BI systems for schools/tertiary.
• Develop other necessary technical artefacts documentation on demand and for critical integration systems.
• Evaluate and document data acquisition processes and data sources.
• Design stable, reliable and effective databases across platforms including on-prem, off-site and public and private cloud.
• Modify databases to optimize and maintain legacy systems and carryout performance tests.
• Respond to database usage issues and malfunctions where applicable.
• Provide data management and function support to users on demand and ensure all database programs meet schools/tertiary quality and performance requirements.
• Develop a detailed and thorough knowledge of database schema, database operations and database communication layers.
• Design large scale big data solutions with key database technology as needed.
• Develop a thorough and detailed understanding of the relational database platforms, with a focus on performance analysis, query optimization operations, appropriate SQL syntax and database internals.
• Perform data profiling and data discovery on request and demand.
• Perform independent database performance analysis with a focus on SQL query efficiency and schema design; apply tools and utilities to identify integrity or performance issues.
• Review database schema changes and generates queries as needed, assist and mentor less experienced individuals with schema and query reviews.
• Work with teams to enforce database standards; aid in design and research of new database standards as needed.
• Research and suggest new database products, services and protocols.

ETL and Data Integration

• Define data integration and lifecycle requirements.
• Develop data and information services.
• Develop data flow orchestration.
• Develop data migration approach and framework.
• Define and maintain meta data reference techniques.
• Provide a standard for data exchange specifications.
• Designs and builds relational databases to support our current data integration Packages and Solutions.
• Works with application developers to ensure end user and application data requirements are fulfilled.
• Develops strategies for data acquisitions, archive recovery and implementation of a database.
• Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents with the process.
• Performs integration of new systems into the schools/tertiary network and Identify potential issues and opportunities prior to implementation.
• Develop data cleansing techniques and methods where applicable.
• Develop necessary data models to support integration processes.
• Implement data sharing processes and solutions on demand.
• Develop and coordinate system integration processes with internal departments and outside vendors.
• Comply with application integration policies, standards, documentation and procedures.

• Evaluates existing integration systems and/or user needs to analyse, design, recommend and implement necessary system changes.
• Ensures optimal performance, reliability and integrity of the database/system through a variety of techniques and procedures

OLAP Cube & Data Science

• Translate business measures into data algorithms and models.
• Designing and implementing OLAP Cubes (Multi-dimensional Model) to meet business requirements for schools/tertiary.
• Designing and implementing OLAP (Tabular Model) to meet business requirements for schools/tertiary.
• Design and implement data analytics Key Performance Indicators (KPI) that are aligned to business measures and analytics.
• Investigate facts and measures that are relevant for the data challenges in the schools/tertiary units.
• Build OLAP cubes that support data analytics road map for theschools/tertiary and strives to achieve descriptive analytics, predictive analytics and prescriptive analytics.
• Integrate statistical models to build comprehensive analytical algorithms to support complex business data questions.
• Work with business teams to gather their analytical needs and develop business analytics models and data mining solutions in SSAS and other related tools.
• Ensure that OLAP cubes comply with data visualization or presentation to meet business requirements.
• Work with data integration developers to define OLAP requirements for analytics.
• Provide data analytics and analysis architectural leadership and guidance to ensure that new initiatives enable effective data analytics.
• Utilize statistics and applied mathematics to build complex measures.
• Provide data analysis at all levels of complexity on demand.

Dashboard and Enterprise Reporting

• Work with business teams to gather their reporting needs.
• Responsible for developing data extractions and reports that meet customer and schools/tertiary requirements for all our applications.
• Suggesting and implementing procedural enhancements and code
• optimizations that supports data visualization and reporting products.
• Make prompt and technically sound decisions as well as recommendations that add value to business priorities and needs.
• Develop and maintain Power BI dashboards and SSRS Reports, and schedule, distribute, and perform ad hoc run of reports on demand.
• Develop new Power BI visualizations based on the business requirements.
• Prepare and review necessary dashboard specifications and design documents.
• Develop interactive reports and effective visuals in Power BI, SSRS and other dashboard and reporting technologies.
• Escalating issues on critical reports and dashboards in a timely manner and driving necessary urgent improvements.

Operational Support Responsibilities

• Additional to special BI and data projects, it expected that the developer will also apply BI and data skills and processes on data operational tasks, as part of a transitional process towards establishing a 100% commitment on BI projects.

These tasks would include but not limited to:

• Operational Data Integration Packages (SSIS Packages)
• Data Manipulation (Daily Run)
• Enterprise Report Development (SAM Reports & CAMS Reports)

As and when required the developer maybe required to assist the ITSU team with technical work in line with BI skills and capabilities.

As an intermediate resource, the developer will also take part in grooming of junior developers to assist building the team capacity and capabilities.