Senior BI Developer MMH251028-9

Momentum Bellville, Western Cape, South Africa 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 optimisation, 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‑driven decision making. Qualifications 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 optimisation. 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 optimisation 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 years 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 optimising 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 and Responsibilities Lead the migration of existing on‑premise data assets and processes to cloud environment, ensuring seamless transition and adherence to governance standards. 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 optimise 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 & Visualisation: Develop and publish Power BI, Cognos, or SQL‑based reports to meet operational and strategic information needs. Optimise 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. Performance Optimisation: 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 optimisation, 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 organisational needs. Stay current with emerging BI technologies and cloud advancements to strengthen team capability and support organisational 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 optimise 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 optimisation 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. As an applicant, please verify the legitimacy of this job advert on our company career page. #J-18808-Ljbffr