BI Data Analyst

Requisition Details & Talent Acquisition Contact

REQ 135811- Tshego Semenya

Location: Sandton

Closing date: 11 September 2024

Cluster

RBB

Career Stream

It Application Development

Leadership Pipeline

Manage Self: Technical

Position

BI Data Analyst

Why You Should Apply

• Cutting-Edge Technology: Youll work extensively with Python and SQL, leveraging these tools to handle large datasets and perform complex data analysis.
• Data-Driven Environment: With access to vast amounts of data and diverse datasets, youll have the opportunity to conduct in-depth recons, ETL processes, and visualize insights that drive strategic decisions.
• Collaborative Team: Join a team that values collaboration and knowledge sharing, where your contributions are recognized and valued.
• Impactful Work: Your analyses will directly influence business strategies and outcomes, giving you a sense of purpose and accomplishment.
• Professional Growth: We support continuous learning and development, offering opportunities to advance your technical skills and career.

Questions To Ask Yourself:

• Do you enjoy solving puzzles?
• Does finding connections and highlighting gaps between datasets excite you?
• Have you found cleaning and structuring data boring and made you implement processes to simplify your job?
• Do you prefer writing code easier than writing reports?
• Have you found ways of making data more accessible through web-based approaches?
• Do you strive to make your working environment better?

Please note that we are looking for candidates that will be able to hit the ground running and add your skillset to the team. This position will provide infinite opportunities for growth and honing your skills, but this position is not an opportunity to develop these skills from scratch. Please only apply if you are confident that you will be able to

Why You Should not Apply

• Preference for Routine: If you prefer routine tasks over dynamic and challenging tasks, this role might not be the best fit.
• Lack of Initiative: This position requires a proactive approach and a willingness to take ownership of your work. If youre not comfortable with taking the lead, it might be challenging.
• Discomfort with Change: Our environment means that changes in our business environment change are inevitable. If you find it difficult to adapt to changing circumstances, this role may not be suitable.
• Preference for existing solutions: If you prefer to work with out-the-box GUI tools or legacy code, and struggle to articulate, conceptualise, test and implement solutions to enable efficiency, changes required this role may not be suitable.

Day in the Life of a BI Data Analyst

• Work through unpacking and reconciliate data sources and structure the data into the data mart, and highlight risks, issues and provide actionable next steps
• Dive into reviewing legacy code, optimising and enabling it for better performance. This involves refactoring Python scripts and SQL queries to enhance efficiency and maintainability.
• Work with business stakeholders to identify key insights that have strategic and material impacts
• Find innovative ways to automate repetitive tasks to automate the boring stuff, using Python and SQL to develop scripts that streamline processes and free up time for more strategic work.
• Meet and work with people who are excited about making a difference, as your share your ideas and discuss ongoing projects
• Keep your codebase up to date on Git, ensuring version control and collaborate with your team.
• Continuously update your progress on the backlog, prioritizing tasks and communicating your next goals.
• Collaborate with business stakeholders to identify key insights that have strategic and material impacts. Use your analytical skills to translate complex data into meaningful insights that drive business decisions.

Job Purpose

To support the automation of processes and process re-engineering initiatives to enhance service delivery

To provide ad hoc strategic and operational support across business units to unlock operational efficiencies and identify process root cause analyses

To support the development of ETL pipelines for the sourcing of data from MS Excel, SQL, CSV, JSON sources into data marts

To recon and validate data across various data sources and provide critical feedback on the actions required to sustain data integrity

To support the maintenance and development of data mart models

To provide business intelligence reports and analyses to business

Job Responsibilities

• Ensure information is provided correctly to stakeholders by maintaining knowledge sharing knowledge with team.
• Structure data according to compliance standards by adhering to metadata governance procedures according to Nedbank documented standards and formats; and ensuring metadata is continuously up to date.
• Manage final transformed data content by complying to prescribed standards for reviewing and publishing.
• Govern the population of data mart and metadata repository by complying to standards; systems; processes and procedures.
• Align and continuously improve set processes by identifying innovation opportunities.
• Identify and recommend opportunities to enhance processes; systems and policies and support implementation of new processes; policies and systems.
• Deliver work according to customer expectations by prioritizing; planning and implementing requirements.
• Ensure work are delivered according to relevant technical standards
• Support business units by providing consulting services that delivers data and information relevant to their business
• Ensure customer needs are met through regular customer feedback sessions
• Manage vendor relationship interactions by conforming to vendor management office guidelines and principles.
• Manage vendor relationship interactions by conforming to vendor management office guidelines and principles.
• Utilize resources by adhering to standards; policies and procedures.
• Identify and mitigate risk by executing within governance.
• Resolve incidents by logging and tracking through correct channels
• 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.
• 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 Nedbank vision and demonstrate the values through interaction with team and stakeholders.
• Contribute to internal and external information sharing sessions by attending formal and informal meetings.
• Contribute to a culture conducive to the achievement of transformation goals by participating in Nedbank Culture building initiatives (e.g. staff surveys etc).
• Participate and support corporate social responsibility initiatives for the achievement of key business strategies.

Experience Level

Minimum

• Minimum 5 years experience is in a data management / business role
• Data reconciliation and validation
• Developed and implemented data driven reports
• Transformation and normalisation of source datasets for analytical insights
• Manage internal process and process re-engineering
• Track record of using technology to optimise your work environment

Preferred

• You have improved processes and culture where you have worked
• You have built and maintained stakeholder relationships
• You have managed ETL pipelines and enabled data quality and validation
• You have supported the transformation, change and continued improvement of the tools and processes used

Essential Qualifications - NQF Level

• Advanced Diplomas/National 1st Degrees

Qualification Details

Qualifications (Essential)

• Provide a proven track record of managing big datasets in MS SQL Server using a proven framework (no less than 5 years work experience) or associated certifications in data management (MS SQL Server / Python / Azure or similar)
• Bachelors Degree in IT, Business Management, Mathematics, Statistics, Engineering, Economics, Finance, etc.

Qualification (Preferred)

• Post-graduate degree in IT, Business Management, Mathematics, Statistics, Engineering, Economics, Finance, etc.

Essential Certifications

• Certification relevant to data analytics, SQL, database management, Python, Git, etc.

Technical / Professional Knowledge

Essential

• SQL (MS SQL Server)
• Python
• Git
• PowerBI / similar visualisation tools
• Microsoft Office with Excel skills (advanced)

Preferred

• Experience using Python for analysing data and ETL process tooling
• Experience using and deploying Django Framework, esp. using the ORM
• Experience managing work requests using Azure DevOps / Jira
• Experience using Script-base visualisation

Disclaimer

Preference will be given to candidates from the underrepresented groups

Please contact the Nedbank Recruiting Team at +27 860 555 566

Please contact the Nedbank Recruiting Team at +27 860 555 566