Business Intelligence Data Analyst - Cape Town at Juru Holdings

Tasks and Responsibilities

• Collaborate with stakeholders to understand business challenges, needs, processes and requirements
• Accountable for gathering, clarifying and documenting data and reporting requirements – including scope, sources, data fields, measures, definitions, exceptions, visualisations, security.
• Obtain confirmation or decisions from SMEs or stakeholder where required.
• Assess effectiveness, integrity and accuracy of data sources and optimal data gathering techniques.
• Perform data analysis to map and model data into central repository.
• Design proof of concept and support developers to ensure successful delivery.
• Guide clear data storytelling and visualisation to ensure meaningful insights shared with consumers.
• Design optimal data visualisation and mockups, and build, or oversee, dashboards/ reports.
• Produce clear and comprehensive delivery artefacts.
• Define test scenarios and perform unit and functional testing as well as oversee QA and UAT to quality assure final output.
• Defines a change strategy to ensure trust and adoption encouraged in user community.
• Executes tasks defined in strategy to mature user adoption.
• Facilitates user forums explaining available and/or new functionality.
• Drafts/ commissions training material and user guides for users.
• Once productionised, some support may be required.

Personal Effectiveness

• Accountable for service delivery through own efforts
• Individually accountable for managing own time, tasks and output quality
• Communicates clearly and timeously – verbal & written
• Has focused and problem-solving aptitude
• Collaborates effectively with others to meet deliveries
• Ability to work under pressure and meet strict deadlines
• Willing and able to learn quickly
• Resilient and able to handle change
• Align to ways of working and team culture
• Ensure and maintain appropriate data privacy and confidentiality
• Intermediate project coordination skills, with experience working within either Agile or other project methodologies

Requirements

• Tertiary qualification in Computer Science, Information Technology or related fields
• Relevant analytical, statistical and BI and data warehouse experience
• Data modelling using the Kimball methodology
• Proficient in SQL, Microsoft Excel, Microsoft Power Pivot, Power Query, Power BI, TeamFoundationServer
• Advantageous: experience in Finance, Financial Services, Human Capital, and/ or Marketing, Communication, Public Affairs & Sustainability