BI Data Analyst (Full-Stack)

Requisition Details & Talent Acquisition Contact

REQ 135813- 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 (Full-Stack)

Why You Should Apply

• Cutting-Edge Technology: You’ll 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, you’ll 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?
• Are you excited about 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 you’re 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 (Full-stack)

• Enhance the web-framework to create micro business services to enable business to integrate datasets and reduce manual document management
• Enable transparency in the unpacking and reconciliation of data sources and and using ORM to structure the data into the data mart
• Dive into reviewing legacy code, optimising and enabling it for better performance, and creating new views and models to enable the integrated data mart. This involves refactoring Python scripts and SQL queries to enhance efficiency and maintainability.
• Work with business stakeholders to identify and document business requirements 
• 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 create web-based views 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 grow the web-based platform used to manage various business critical processes and enable strategic and operational support in sustaining the data mart and reduce manual data processing and document-based data capturing
To support the ETL processes from MS Excel, SQL, CSV, JSON sources 
To ensure that the platform has required tests to enable business efficiencies
To support the maintenance and development of data mart models

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

Experience Level (Minimum)

• Minimum 6 years’ experience is in a data management / business role / working with web-based Python framework
• Structuring source datasets into logical models
• Manage internal process and process re-engineering
• Track record of using technology to optimise your work environment

 

Experience Level (Preferred)

• You have improved processes and culture where you have worked
• You have built and maintained stakeholder relationships
• Developed and implemented data driven web-based reports
• 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
• 5 years’ experience working with Django framework
• Management and deployment of Django framework

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) and experience in using Django or similar Python framework. 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

Technical / Professional Knowledge (Essential)

• MS SQL Server or similar SQL engine
• Python based web-framework (including Python ORMs)
• Python
• Git
• PowerBI / similar visualisation tools
• Microsoft Office with Excel skills (advanced)

 

Technical / Professional Knowledge (Preferred)

• Experience using and deploying Django projects with comprehensive knowledge of the ORM
• Experience using Python for analysing data and ETL process tooling
• Experience managing work requests using Azure DevOps / Jira
• Experience using Script-base visualisation
• MS SQL Server experience (using t-sql

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