Job title : Senior BI Engineer-(DBN)
Job Location : KwaZulu-Natal, Deadline : March 20, 2025 Quick Recommended Links
- Jobs by Location
- Job by industries
You Bring :
5-7 years' solid working experience within the BI environment.Design, develop, maintain and work towards sustainable, long-term Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSAS, SSRS and Power BI.Creation of stored procedures, operational reports and dashboards.Design, develop and maintain ETL process using SSIS.Datawarehouse design, maintenance and re-architecture as required.Follow project specifications and corporate coding standards and policies.Coach and mentor junior team members.Liaise with fellow developers, DBAs and business analysts to identify and optimise inefficient BI processes and code.Recommend improvements to provide optimum reporting solutions.Be involved in strategic planning and design sessions.Demonstrated ability to work on projects from planning to delivery.W hat You’ll Do :
Design, Development and Implementation :
Responsible for the design, development, maintenance and work towards sustainable, long term Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSAS, SSRS and Power BI.Ensures the creation of stored procedures, operational reports and dashboards.Design, develop and maintain ETL process using SSIS.Datawarehouse design, maintenance and re-architecture as required.Follow project specifications and corporate coding standards and policies.Responsible for coaching and mentoring junior team members.Liaise with fellow developers, DBAs and business analysts to identify and optimise inefficient BI processes and code.Make recommendations on improvements to provide optimum reporting solutions.Should be involved in strategic planning and design sessions.Works on highly complex and cross-functional BI solutions. Directs, organises, and leads projects in the implementation and use of new BI software tools and systems.Participates in workstream planning process including inception, technical design, development, testing and delivery of BI solutions.Develops work plans or reviews other work plan timelines and manages workflows to meet timeframes.Participates in project management estimation process.Manages and plans for service demand forecasts.May participates in the development of business cases to support IT projects.Collects, analyses, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results.Works with the BI Analyst during implementation, gathering additional information when needed and keeping the business informed.Responsible for implementing data structures using best practices in data modelling, processes, and technologies.Performs data conversions, imports and exports of data within and between internal and external software systems.Implements tools and frameworks for automating report generation, identification of data-quality issues, and data governance.Leads the integration efforts for merging BI platforms with enterprise systems and applications.Performs data conversions, imports, and exports of data within and between internal and external software systems.Explores the data and discovers patterns, meaningful relationships, anomalies, and trends.Performs programming analyses for a wide range of requests using data in different formats and from various platforms.Ensures documentation is created and maintained.Production Support
Troubleshoots BI tools, systems, and software.Troubleshoots reported data loads or reconciliation inconsistencies in conjunction with the sites for data models and / or reports.Tracks, monitors and analyses performance and production issues, and implements improvements.Supports and helps manage external resources, such as service providers and vendor support.Quality Assurance
Ensures the collected data is within required quality standards.Maintains the quality of Metadata Repository by adding, modifying, and deleting data.Recommends quality metrics and ensures quality metrics are documented and tracked development, model validation, and model implementation.Documents standards and policies for the form, structure, and attributes of the BI tools and systems.Ensures adherence to process, policies, and standards.Research / Evaluation
Analyses and tests new releases / versions of software.Conducts research and makes recommendations on BI products and services.Interfaces with vendors to keep abreast of new technologies, pricing, and customer applicability.Participates in vendor evaluations.Interfaces with Architects to recommend new technology opportunities that will have an impact on BI systems.Coaching / Mentoring
Provides guidance, training, and problem-solving assistance to other team members.Mentors and contributes to the growth of junior and intermediate team members.Designs and delivers end-user training and training materials.ICT jobs