Business Intelligence Developer

SUMMARY:
-

POSITION INFO:

Job Purpose:

This role requires an experienced and highly skilled senior business intelligence specialist with expertise in Microsoft Stack, specifically with strong experience in data warehousing, data lake technologies, and Power BI. The incumbent will serve as the technical expert responsible for designing, developing, and maintaining robust and scalable business intelligence solutions using Microsoft technologies such as SQL Server, Azure Data Warehouse, Azure Data Lake, and Power BI. Collaborate with cross functional teams to gather requirements, architect data warehouse and data lake solutions, create insightful reports and visualizations, and deliver actionable insights to meet stakeholder needs.

Key Performance Area

Strategic Function: 

• Contributes to the strategy, vision, and governance of the BI and Data Analytics capability.
• Drive best practices, iterative improvement, and innovation at the strategic deployment level.
• Provide strategic support and identify opportunities in existing business processes for building reports and dashboards.
• Function as an integrator between the business and technology to create business solutions.
• Support the implementation of the centre Balance Score Card (BSC) project and initiatives.
• Support define and manage best practices for our Data Warehouse. This may include payload design of source data, logical data modeling, implementation, metadata, and testing standards.
• Support to set standards and ways of working with data across the organisation and Auditees, through collaboratively way.

Product Management:

• Support with the design and development of data warehouse solutions using Microsoft Stack, including SQL Server, Azure Data Warehouse, and Azure Synapse Analytics.
• Collaborate with business stakeholders to understand their data requirements and translate them into scalable and efficient data models that support reporting, analytics, and data integration.
• Design and implement ETL processes to extract, transform, and load data from various sources into the data warehouse, ensuring data quality, consistency, and integrity.
• Designs, develops, and tests BI solutions such as databases, data warehouses, queries and views, reports, and performs data conversions, imports, and exports of data within and between internal and external Auditees.
• Participates in workstream planning process including inception, technical design, development, testing and delivery of BI solutions.
• Oversee end-to-end ownership of data projects and independently collaborate with business stakeholders in an agile environment to solve business problems.
• Develop and maintain data transformation workflows using tools such as SQL Server Integration Services (SSIS) or Azure Data Factory.
• Collaborate with data engineers and data scientists to integrate and process data from data lakes, leveraging technologies such as Azure Data Lake Storage and Azure Databricks.
• Create visually appealing and interactive reports, dashboards, and visualizations using Microsoft Power BI, enabling stakeholders to derive actionable insights from the data warehouse.
• Implement data governance and security measures within the data warehouse environment, ensuring compliance with regulatory requirements and maintaining data privacy.
• Monitor and optimize the performance of the data warehouse, identifying and addressing bottlenecks, and recommending improvements for scalability and efficiency.
• Keep abreast of the latest advancements in Microsoft Stack, Power BI, data warehousing, and data lake technologies, evaluating and recommending new tools and techniques that can enhance our business intelligence capabilities.
• Keep abreast with the latest trends and advancements in Business Intelligence/Data Analytics technologies and identify opportunities for innovation.
• Support with Optimize SQL queries and stored procedures for data retrieval and analysis, ensuring efficient performance and adherence to best practices.
• Collaborate with cross-functional teams, including business stakeholders, data engineers, data scientists, and IT teams, to understand business requirements and deliver impactful insights.
• Maintains the quality of the Metadata Repository by adding, modifying, and deleting data.
• Provides input to the development of data/information quality metrics.
• Provide guidance, training, and problem-solving assistance to other team members.
• Tracks, monitors and analyses performance and production issues, and implements improvements.

Stakeholder Management:

• Establish, build, and maintain collaborative working relationships with relevant internal stakeholders.
• Build and maintain positive and value-adding relationships with relevant internal/external stakeholders.
• Scan the environment to ensure a clear understanding of stakeholder needs.
• Proactively interact with stakeholders to determine their needs and deliver on them accordingly.
• Engage with both internal and external stakeholders to identify and evaluate performance barriers in order to continuously improve service delivery.
• Work in collaboration with various teams to ensure timeous delivery of the work.
• Establish and maintain relations with recognized professional bodies within their own professional sphere.
• Manage service level agreements (SLAs).

People Management:

• Manage own performance to drive productivity.
• Motivate, coach and mentor junior staff to ensure maximum productivity and development of the staff to their full potential.
• Participate and/or take lead in the business unit transformation and culture plans.

Financial Management and Operational Management:

• Contribute to the compilation of center budget, and manage project expenditure related to functional area.
• Ensure compliance with policies and procedures.
• Ensure compliance with internal processes and procedures.
• Manage supply chain processes within scope of work.

Other Responsibilities:

• Perform and/or manage other projects, tasks, and assignments not stipulated on the Job description as and when required.

Technical Competencies

Technologies or relevant software knowledge:

• Experience in working as part of a scaled CoE for Business Intelligence and Data Analytics.
• Experience implementing Business Intelligence and Data Analytics solutions.
• Strong expertise in data warehousing concepts, data modelling, and dimensional modelling principles.
• Proficiency in SQL and experience with writing complex queries, stored procedures, and ETL processes.
• Experience with data integration and ETL tools such as SQL Server Integration Services (SSIS) or Azure Data Factory.
• Familiarity with big data technologies and distributed computing frameworks such as Apache Spark is highly desirable.
• Solid understanding of data lake architectures, data governance principles, and data privacy regulations.
• Strong experience in developing visually appealing and interactive reports, dashboards, and visualizations using Microsoft Power BI.
• Strong analytical and problem-solving skills, with the ability to analyze complex datasets, identify patterns, and derive meaningful insights.
• Excellent communication and stakeholder management skills, with the ability to effectively present complex technical concepts to non- technical audiences.

Research and Analytical Skills:

• Must have knowledge and skills in sourcing public data and information to enable interpretation, identification, and assessment of automation processes.
• Ability to integrate various sources of information.

Project Management:

• Ability to provide oversight for projects and all related activities.
• Ability to establish a set of tasks and activities associated with projected outcomes within stipulated times lines. Ensure that actions are implemented to achieve the desired results of the project.

Problem Management:

• Investigates and troubleshoot problems to understand the root cause and remove blockers.
• Assists with the implementation of agreed remedies and preventative measures through continuous updates to the Stakeholders and Business units based on lessons learned.

Reporting:

• Ability to document and communicate the scope of work and findings and recommendations in line with relevant reporting standards or guidelines.
• Writing and analytical skills.

Behavioural Competencies

Emotional Maturity:

• Demonstrate emotional maturity by displaying sensitivity towards others in the workplace.
• Understands and manages own emotions and their influence on others and takes perspective of and empathize with others from diverse backgrounds and cultures and handles conflict situations constructively and maturely in own area of work and influence.
• Facilitates and mediates conflict between staff, stakeholders and clients at a cross-functional level.
• Creates a work environment which minimizes stress and ensures an even distribution of workload.
• Supports the right of staff to a personal life and a reasonable balance between work and personal life.

Empowerment:

• Conveys strategic and operational objectives for implementing at cross-functional performance by translating strategic objectives into clear and measurable outcomes.
• Takes ownership for developing, mentoring and coaching employees to build their skills and capabilities.
• Creates an environment that enables ethical, transparent, honest work practices by putting the necessary structures and protocols in place and sharing information with the relevant parties.
• Conveys strategic and operational objectives with enthusiasm and energy with teams and across business units.
• Displays trust and faith in staff by giving them opportunities to represent the work unit by delegating meaningful work, allowing staff to use their judgment within their area of responsibility.

Diversity and Inclusion:

• Actively promotes and influence diversity, inclusion and gender equality in cross-functional teams.
• Enhances cross-cultural communication within and outside of the organisation.
• Creates an environment where individuals feel valued and regarded.
• Treats colleagues, partners, stakeholders, clients and counterparts with dignity and respect, and focuses on what unifies the workforce irrespective of gender, culture, or religion.
• Aligns divisional/unit/centre goals and resources with institutional diversity goals and monitors progress toward diversity initiatives across functional teams.

Integrity:

• Apply consistency in upholding and promoting the organisations values in actions and decisions related to staff and work.
• Exhibit uncompromising integrity and commitment in full compliance with the Values, code of conduct in a transparent manner.
• Promotes fair, consistent, and impartial treatment of all individuals in the centre and across business functions.
• Ensures that conflicts of interest and ethical dilemmas are resolved without compromising the organisation and applicable standards.
• Challenges stakeholders on unprofessional, unethical behaviour and makes unpopular decisions to ensure the integrity of the organisation.

Authenticity:

• Applies authentic leadership, and encourages others to do the same by creating an environment in which people feel psychologically safe.
• Exhibit high level of self-awareness and demonstrate genuine, uncompromising and consistent behaviour/leadership approach that is transparent, trustworthy and inspires loyalty and trust in others.
• Understands individuals’ strengths and ensures full utilisation of their talents in the achievement of centre/business goals and objectives.
• Provides honest, open and fair feedback to stakeholders in an endearing manner.
• Shows consistency regardless of the stakeholders involved.

Performance Excellence:

• Drive a culture that is conducive to quality and efficiency by promoting appropriate tools, technologies, practices, policies and procedures in response to the organisational goals and objectives.
• Proactively monitors organisational efforts, removes barriers and channels resources in the accomplishment of organisational goals, particularly in the face of complex work demands.
• Sets challenging, stretching goals for the unit in line with macro-contextual demands and opportunities.
• Drives a culture or high performance by ensuring that consistent, fair, transparent performance appraisal systems are upheld.
• Promotes dialogue about excellence at all levels of the organisation, and encourages staff to strive for excellence in all areas of their work.

Innovation and Continuous Improvement:

• Drive, build, and fosters a safe and stable work environment that allows for new and innovative ideas to surface.
• Translates creative ideas into strategic plans and operational objectives.
• Consistently seeks innovative technological solutions to facilitate the achievement of long-term organisational objectives.
• Inspires others to generate breakthrough ideas, fresh perspectives and new opportunities.
• Exercises good judgment in knowing when it is necessary to break from convention to serve client needs.
• Facilitates idea generation by creating networking opportunities.

Accountability:

• Apply, monitor and implement processes, policies and procedures that promote accountability and responsibility in teams.
• Accepts responsibility for outcomes (positive or negative) of divisional/ functional efforts.
• Motivates and rewards team members towards accepting responsibility for obligations, decisions, and actions.
• Accepts accountability for divisional successes and failures.
• Delegates significant responsibility and authority whiles remaining accountable.
• Walks the talk by acting as a role model and personally committing to the standards expected of others.

Courageous and Ethical Leadership:

• Apply ethical and moral behaviours when leading others in a fair, objective and consistent manner.
• Demonstrates consistency in behaviour by showing courage in face of opposition and draws confidence from the conviction that an ethical approach is the only option.
• Roots out any unethical and corrupt behaviours and ensures that the policies procedures and systems and controls are applied consistently, without fail.
• Applies consequence management in a consistent and transparent manner, and ensures that consequences suit transgressions.
• Recognizes ethical heroes and rewards those that make personal sacrifices, or takes personal risks to uncover unethical behaviour.

Minimum Requirements

Formal Education:

• Minimum 3 year Bachelor’s/ Degree in Computer Science, Information Systems, or a related field (NQF 7). Honours /Master qualification will be advantages.
• Relevant certifications in Microsoft Stack, Power BI, and data warehousing technologies (e.g., Microsoft Certified: Azure Data
  Engineer Associate) are desirable.

Experience or Requirements:

• Minimum 8 years of proven work experience as a Business Intelligence Specialist or similar role, with a focus on the Microsoft Stack, expertise in data warehousing, data lake technologies, and Power BI development.
• Experience in working with/in SQL Server, Azure Data Warehouse, Azure Data Lake, Azure Synapse Analytics, and Power BI.
• Experience working in an agile and waterfall development environment, following best practices for project management and collaboration.

NB! This job is now closed. You can apply for other jobs by uploading your CV.