Job Description

Introduction

Through our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations. We help people grow their savings, protect what matters to them and invest for the future. We help companies and organisations care for and reward their employees and members. Through our own network of advisers or via independent brokers and utilising new platforms Momentum Metropolitan provides practical financial solutions for people, communities, and businesses.

Disclaimer

As an applicant, please verify the legitimacy of this job advert on our company career page.

Role Purpose

Design, build and maintain scalable Business Intelligence (BI) solutions that enable reliable reporting, data integration, and data analytics. Lead the redevelopment of the existing data warehouse and migration from on-premises systems to cloud-based environments. The Senior BI Developer ensures data integrity, performance optimization, and alignment under the direction of the BI Manager. Serve as the team lead for the BI development team, supporting and guiding BI developers in best practices for data modelling, ETL/ELT processes and BI solution delivery. Collaborate closely with the BI manager, data analyst and business stakeholders to deliver modern, efficient, and scalable BI solutions that drive business value and enable data-driver decision making.

Requirements

#

QUALIFICATION

Valid Matric or Equivalent
Bachelor's degree in Computer science, Information Systems, Data Science, Business Analytics, Statistics, Engineering, or an equivalent quantitative qualification.
Postgraduate qualifications or master's degree in quantitative discipline (advantageous)
Relevant BI certifications in Microsoft Power BI, Azure Data Engineer, Azure Synapse Analytics, or SQL Server (advantageous)
Certification or training in data warehousing, data modelling, or ETL development (advantageous)
#

KNOWLEDGE

Strong understanding of business intelligence and data analytics systems, processes, and lifecycle management.
In-depth knowledge of data warehousing principles, dimensional modelling (Kimball/Inmon), and ETL/ELT methodologies.
Proficiency in SQL and familiarity with Microsoft Azure ecosystem (Data Factory, Synapse, Databricks, and Fabric).
Understanding of business processes and KPIs across operational and financial domains.
Knowledge of System Development Lifecycle (SDLC) and BI delivery frameworks (Agile or hybrid).
Awareness of data governance, metadata management, and information security practices within enterprise BI environments.
#

SKILLS

Advanced SQL development for data extraction, transformation, and performance optimization.
ETL design and implementation using Sybase or Azure Data Factory.
Data modelling and semantic model design for Power BI and reporting environments.
Power BI dataset and dashboard development, including DAX optimization and data refresh scheduling.
Strong analytical thinking and problem-solving capability.
Excellent communication skills, able to translate technical solutions into business-friendly terms.
High attention to detail, data accuracy, and solution documentation.
Ability to mentor BI Developers and collaborate effectively within cross-functional teams.
#

EXPERIENCE

Minimum of 7 of relevant experience in Business Intelligence, Data Engineering, or Data warehouse development, ideally within the financial services or corporate sector.
Strong proficiency in SQL and database management.
Proficient in Power BI and/or other Data Visualisation tools, like QlikView and Tableau, etc.
Proven experience developing BI solutions and transitioning data assets to cloud.
Strong analytical and problem-solving skills with the ability to interpret complex data sets.
Hands-on experience building and optimizing ETL/ELT pipelines and data models for reporting and analytics.
Strong track record in SQL performance tuning, data validation, and report automation.
Experience working in an agile development environment.
Experience collaborating with Data Analysts and BI Managers to deliver enterprise-level reporting and analytics solutions.
Exposure to Microsoft Fabric, Azure Synapse, or Databricks is advantageous.

Duties & Responsibilities

#

INTERNAL PROCESS

BI Solution Development

: Design, build, and maintain scalable BI solutions that support both operational and strategic business needs, ensuring reliability, performance, efficiency and scalability.

Database & ETL Development:

Develop and optimize SQL queries, procedures, and scripts within the internal environments. Manage ETL/ELT processes to ensure efficient and secure data movement across systems.

Data Integration:

Integrate data from multiple sources into a unified, trusted repository to support enterprise analytics and reporting.

Data Modelling & Architecture:

Develop and maintain robust data models (relational, dimensional, and tabular) to support analytics, Power BI reporting, analytical dashboards and self-service BI initiatives.

BI Reporting & Visualization:

Develop and publish Power BI, Cognos, or SQL-based reports to meet operational and strategic information needs. Optimize report performance through efficient queries, caching, and data model tuning. Collaborate with Data Analysts to design intuitive dashboards that effectively communicate key insights to business users. Implement and maintain Power BI semantic models and data refresh schedules, ensuring alignment with data governance and accuracy standards. Support self-service BI enablement, ensuring users can access, explore, and visualize trusted data independently.

Cloud Migration:

Lead the migration of existing on-premise data assets and processes to cloud environment, ensuring seamless transition and adherence to governance standards.

Performance Optimization:

Evaluate, enhance, and troubleshoot BI systems to improve query performance, scalability, and data refresh efficiency.

Collaboration & Support:

Work closely with the BI Manager, Data Analysts, and BI Developers to translate business requirements into effective technical designs and solutions.

Data Quality & Validation:

Implement data validation and reconciliation processes to ensure accuracy, completeness, and consistency across BI environments.

Documentation:

Maintain comprehensive technical documentation, including data flow diagrams, ETL logic, metadata, and model definitions for transparency and reproducibility.

Automation & Innovation:

Identify opportunities to automate BI workflows, enhance data processes, and adopt emerging Azure tools and Fabric capabilities.

Technical Mentorship:

Provide technical guidance, peer review, and knowledge sharing for BI Developers, ensuring adherence to BI development standards and best practices.

Data Governance & Compliance:

Support the implementation of data governance policies, ensuring that all BI development aligns with security, privacy, and compliance frameworks defined by the BI Manager.
#

CLIENT

Provide authoritative technical expertise and BI development support to internal business stakeholders.
Collaborate with business units and BI manager to understand reporting, data and integration requirements, translating them into effective BI and data solutions.
Ensure the accuracy, reliability, and performance of BI deliverables including dashboards, datasets and reports.
Support the BI manager in stakeholder engagements by explaining BI capabilities, data model design, and system enhancements that improve reporting efficiency.
Partner with the Senior Data Analyst to ensure models, metrics and dashboards align with analytical and business reporting needs.
Maintain professionalism, responsiveness and data confidentiality when supporting business areas and executives with BI outputs.
#

PEOPLE

Lead a team of data professionals and maintain a high impact culture
Act as a technical mentor and subject matter expert for BI Developers, providing guidance on data modelling, ETL design, SQL optimization, and Power BI dataset development
Support the BI Manager in cultivating a collaborative, high-performance BI team culture focused on innovation, accuracy, and technical excellence.
Promote knowledge sharing and skills development by contributing to BI standards documentation, peer code reviews, and internal learning sessions.
Encourage innovation and continuous improvement, exploring new technologies and approaches within systems.
Demonstrate professionalism, accountability, and technical leadership in all project interactions and cross-functional collaborations.
Foster strong working relationships with Data Analysts, Developers, and business teams to ensure BI solutions meet organizational needs.
Stay current with emerging BI technologies and cloud advancements to strengthen team capability and support organizational modernization goals.
#

FINANCE

Deliver accurate and efficient BI solutions that support financial reporting, budgeting, forecasting, and performance tracking.
Develop cost-efficient data pipelines and BI processes that optimize infrastructure usage across different environments.
Support the BI Manager in ensuring the accuracy and completeness of financial datasets used in executive dashboards and KPI reporting.
Implement automated data refreshes, reconciliation processes, and validation checks to improve the timeliness and reliability of financial reporting.
Identify and implement opportunities to reduce data processing costs and improve system performance efficiency through query optimization and resource management.
Contribute to financial and operational insight by maintaining data structures that enable reliable financial metrics and self-service reporting.
Ensure all BI assets related to financial information comply with internal data governance, security, and audit requirements.

Competencies

Examining Information
Developing Strategies
Directing People
Interpreting Data
Articulating Information
Valuing Individuals
Providing Insights
Challenging Ideas
* Attention to detail