BI Data Analyst at Nedbank

Job Purpose

• The purpose of this role is to produce a monthly client account profitability data mart that supports financial and strategic reporting across the cluster. The BI Data Analyst is responsible for sourcing, transforming, and reconciling data from multiple systems to ensure accuracy, consistency, and alignment with financial statements. The role enables key stakeholders—including Finance, Segment, and Product teams—to access reliable insights that drive profitability, performance improvement, and strategic decision-making.

Job Responsibilities

• Build and maintain a monthly client account profitability data mart to support financial and strategic reporting across the cluster.
• Source and integrate data from various systems, including product platforms and spreadsheets, ensuring completeness, consistency, and reliability.
• Apply business rules to the data and perform reconciliations to ensure outputs align accurately with financial statements.
• Investigate anomalies in the data and resolve them in collaboration with the Finance team to maintain data integrity.
• Provide reporting support to Finance, Segment, and Product stakeholders by delivering accurate, timely, and insightful data outputs.
• Drive automation initiatives to improve the efficiency, accuracy, and sustainability of reconciliation processes.
• Develop and maintain interactive dashboards and reports using Power BI to enable data-driven decision-making.
• Build and manage data pipelines using SQL Server and SSIS to ensure seamless data flow and transformation.
• Perform data profiling, validation, and quality checks to ensure the integrity and usability of data for reporting and analysis.
• Collaborate with Data Engineers, Data Modelers, and Governance teams to ensure data solutions are aligned with business requirements and standards.
• Ensure all data processes and outputs comply with internal governance policies, data privacy regulations, and relevant industry standards.
• Operate within the data value chain, working closely with Finance, Segment, Product, and Data teams to deliver consolidated and strategic insights.
• Contribute to strategic decision-making by producing outputs that reflect a comprehensive view of banking products and performance.
• Support Personal, Private, and Commercial Banking clusters, with future expansion into Corporate Investment Banking and Rest of Africa.
• Ensure the profitability data mart is accurate, complete, and reconciled with financial statements to maintain stakeholder trust.
• Deliver outputs in line with agreed service level agreements and timelines to meet business expectations.
• Reduce recurring reconciliation issues through proactive analysis, process improvements, and stakeholder engagement.
• Maintain high levels of stakeholder satisfaction by consistently delivering reliable and actionable data insights.
• Identify and resolve anomalies effectively to uphold data quality and support confident decision-making.

Essential Qualifications - NQF Level

• Advanced Diplomas/National 1st Degrees

Preferred Qualification

• Bachelor’s degree in Mathematics, Statistics, Engineering, Computer Science, or a related quantitative field.
• Preferred qualifications include BSc or BEng in relevant disciplines.

Preferred Certifications

• Certifications in SQL, Power BI, Data Analysis, Data Modelling, or Cloud platforms (Azure, AWS) will be advantageous.

Minimum Experience Level

• 5–6 years of experience in data analysis, business intelligence, or financial reporting roles.
• Strong proficiency in SQL Server and T-SQL, with experience in building and managing data pipelines using SSIS.
• Hands-on experience with Power BI for dashboard development and reporting.
• Exposure to financial services or banking environments is preferred.
• Experience in data profiling, validation, and reconciliation processes.
• Familiarity with data modelling concepts and data warehouse architectures (e.g., star schema, snowflake schema).
• Understanding of data governance, privacy standards, and compliance requirements.

Technical / Professional Knowledge

• Administrative procedures and systems
• Banking knowledge
• Banking procedures
• Business principles
• Business terms and definitions
• Data analysis
• Governance, Risk and Controls
• Microsoft Office
• Relevant regulatory knowledge
• Relevant software and systems knowledge
• Business writing skills
• Cluster Specific Operational Knowledge