BI Developer at Nedbank

Job Purpose

• To  focus on building, testing, and maintaining BI solutions, using various technologies, IT infrastructure and systems that suppport business intelligence initiatives within the organisation.  Works closely with data analysts and data engineers, to ensure that data is collected, stored, and transformed into actionable insights for Business Specific solutions.

Job Responsibilities

• Develop and maintain simple to medium BI solutions across multiple data source using the standard enterprise technology infrastructure
• Provides input into the design of the data models, data flow and  data integration requirements.
• Create and manage Extract, Transform, Load (ETL) workflows using various sources,  ensuring the data is cleansed and loaded accurately
• Use database query tools and data scheduling tools (e.g., Informatica, Microsoft SSIS), and scripting languages to build and optimize data pipelines
• Maintain data warehouse structures that efficiently store and organize large volumes of data. 
• Manage  data quality, integrity, and security within the data warehouse for accurate reporting 
• Conduct Data provisioning using database tools or using Data Virtualization Technology
• Test and verify for data inconsistencies, data types and data quality that may impact ingestion and provisioning
• Deliver multiple BI Use Case solutions, on an ongoing long term basis within a squad to meet business requirements 
• Learn to interpret  Reports and Dashboards based on business needs
• Create visualizations, virtual marts and report to business stakeholders

Essential Qualifications - NQF Level

• Matric / Grade 12 / National Senior Certificate
• Diploma

Essential Certifications

• DMBok certification ( Data Management Body of Knowledge)

Minimum Experience Level

• 1-2 years experience as a BI Developer with strong Data Analysis and Power BI skillset.

Technical / Professional Knowledge

• Administrative procedures and systems
• Data analysis
• Microsoft Office
• Relevant regulatory knowledge
• Business writing skills
• BI tools -Basic
• DBMS (database management systems) Basic
• Coding and Debugging- Basic
• Data story telling (Basic)
• Database Query intermediate
• Data Virtualization understanding basic
• Data Visualization design and build intermediate

Behavioural Competencies

• Adaptability
• Applied Learning
• Communication
• Managing Work
• Quality Orientation
• Leveraging Feedback