Job Description

Join our client as a BI Data Analyst and drive strategic decisions with your expertise in SQL Server, SSIS, and PowerBI.
Design and maintain secure database systems, provide critical data insights, and continuously improve processes. Ensure compliance, mitigate risks, and stay ahead of industry changes. Leverage your skills in SQL, Python, .Net C#, and HTML to excel. Be part of a dynamic team that values innovation, collaboration, and excellence. Apply now!!
Job Purpose:

• To provide Business Intelligence Analysis through performing strategic and operational support.
• To designs, develops, implements, and maintains database systems, writing code to create and manage databases, and ensuring their efficiency and security.

Job Responsibilities:

• Structure data into compliance standards by adhering to metadata governance procedures according to the client's documented standards and formats.
• Manage final transformed data content by complying to prescribed standards for reviewing and publishing.
• Assist/govern population of datamart and metadata repository by complying to standards, systems, processes and procedures.
• Support business units by providing consulting services that delivers data and information relevant to their business.
• Deliver work according to customer expectations by prioritising, planning and implementing requirements.
• Utilise resources by adhering to standards, policies and procedures.
• Align and continuously improve set processes by identifying innovation opportunities.
• Identify and mitigate risk by executing within governance.
• Resolve incidents by logging and tracking through correct channels.
• Keep abreast of legislation and other industry changes that impacts on role by reading the relevant newsletters, websites and attending sessions.
• Understand and embrace the client's vision and demonstrate the values through interaction with team and stakeholders.
• Improve personal capability and stay abreast of developments in field of expertise by identifying training courses and career progression for self through input and feedback from managers.
• Ensure personal growth and enable effectiveness in performance of roles and responsibilities by ensuring all learning activities are completed, experience practiced and certifications obtained and/or maintained within specified time frames.
• Ensure information is provided correctly to stakeholders by maintaining knowledge sharing knowledge with team.
• Contribute to a culture conducive to the achievement of transformation goals by participating in the client's culture building initiatives.
• Participate and support corporate social responsibility initiatives for the achievement of key business strategies.
• Identify and recommend opportunities to enhance processes, systems and policies and support implementation of new processes, policies and systems.

Minimum Experience Level:

• 8+ years of relevant experience, including:

• 3-5 years in a data management or business intelligence role.
• 6+ years of SQL Server and SSIS experience.
• Experience in financial services or similar industries (e.g., telecoms) is advantageous.

Essential Skills

• Advanced T-SQL and SQL Server Management Studio.
• SSIS (ETL development and scheduling).
• Power BI (tabular models and dashboards).
• Root cause analysis and data quality assessment.

Advantageous skills

• Python (for automation and data manipulation)
• .Net C# (especially for integration with Kafka/Kibana)
• HTML
• SSAS and SSRS
• Visual Studio 2019/2022

Essential Qualifications - NQF Level

• Diploma

Preferred Qualification

• Degree in Information Technology or Business Management, Mathematical/Statistics

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