Business Intelligence Bi Analyst
Western Cape Government
Total years of experience :9 years, 9 Months
° Design Logical Data Model methodology based on business requirements utilizing Kimball methodology
° Produce Business Intelligence Reporting using PowerBI & SSRS.
° Delivers relevant and insightful information to the Business, whilst helping the organisation grow around Business Intelligence.
° Ensures solutions present timely, consistent accurate, complete and valid data.
° Guides and advises the Business on the most appropriate solution(s) to meet their needs and develop complete and accurate models.
° Provides quality information analysts to support key business decisions and reporting needs.
° Data mining, data modelling, report creation and automation, end user education and training.
° Provides ongoing support to users to ensure successful adoption and troubleshooting of the solutions developed. Supports users through their UAT processes, including testing and documentation of the solution developed.
° Prioritizes and works autonomously, yet collaboratively, when needed.
° Technical support for implemented Data Technology Stack as part of HealthBI Reporting Programme to ensure data governance; and
° Develop and maintain ETL packages & Azure data factory pipelines used to import data from Intersystem Cache DB to MSSQL & Azure SQL environment
° Create and maintain Models, Entities and Attributes in MDS.
° Create Analytics / OLAP Cube Development (Microsoft SSAS).
° Migrate SQL 2012 to Azure SQL
° Produce Business Intelligence Reporting using PowerBI & SSRS.
° Delivers relevant and insightful information to the Business, whilst helping the organisation grow around Business Intelligence.
° Prioritizes and works autonomously, yet collaboratively, when needed.
° System maintenance, support and analysis of new functionality
° SQL & MI administration
° System integration development
° SQL Stored Procedure Development
° Implementation and configuration of SSIS if required
° Implementation and configuration of SSRS if required
° Provide input when required including the following:
o Software releases
o Manage developer and code overlap on parallel projects as well as code merging and branching strategies
o Code reviews and conformance to coding standards at the Client
o Assist in setting and up-keeping coding and documentation standards
o Co-work with the project manager and stakeholders to set team deadlines and manage team deliverables
o Unit testing and System Integration testing of own code as well as assistance to developers
o Attendance and participation in development, business and project planning sessions
o Assistance in training of users as required
° Design Logical Data Model methodology based on business requirements utilizing Kimball methodology
° Produce Business Intelligence Reporting
° Delivers relevant and insightful information to the Business, whilst helping the organisation grow around Business Intelligence.
° Ensures solutions present timely, consistent accurate, complete and valid data.
° Guides and advises the Business on the most appropriate solution(s) to meet their needs and develop complete and accurate models.
° Provides quality information analysts to support key business decisions and reporting needs.
° Data mining, data modelling, report creation and automation, end user education and training.
° Provides ongoing support to users to ensure successful adoption and troubleshooting of the solutions developed. Supports users through their UAT processes, including testing and documentation of the solution developed.
° Prioritizes and works autonomously, yet collaboratively, when needed.
° Contributes to the BI strategy and develops and maintains sound knowledge of the Old Mutual Finance business, vision and values.
° Improve financial reporting and systems and processes.
° Data modelling best practice embedded in SDLC of Financial Reporting Projects
° Input into the Dimensional Design of the IFRS versus Management Solution and other Financial Reporting Programme deliverables based on the accurate translation of requirements;
° Technical support for implemented Data Technology Stack as part of Financial Reporting Programme to ensure data governance; and
° Deliver Business Intelligence Reporting as needed to deliver Group Finance Self Service Strategy.
° Develop and maintain PL/SQL packages used to import data from Oracle to MSSQL environment
*Translate business needs to technical specifications.
*Direct quality assurance and user acceptance
testing by writing test plans and managing the
execution of testing (Unit and UAT).
*Design, build and deploy BI solutions.
*Analytics / OLAP Cube Development (Microsoft SSAS
and MDX)
*Evaluate and improve existing BI systems.
*Collaborate with teams to integrate systems.
*Develop and update technical documentation.
*Dimensional Modeling (Kimball Methodology)
*Develop and execute database queries and conduct
analyses.
*Maintain and support data analytics platforms.
.Investigate logged calls escalated by support staff
.Correcting data effected by a software bug.
.Providing continues feedback to customer while investigate a task
Provide feedback once data fix has been applied and issue has been resolved.
Obtaining/Extracting data from multiple data sources.
Develop standard reports and functional dashboards based on business requirements.
Manage new report generation and report enhancement based on the change requests.
Creating and deploying reports.
Writing relational and multidimensional database queries.
Assisting junior staff on day to day tasks.
Identify staff that require training and report their training needs to line manager.
Resolve and complete tasks within the agreed SLA.
Coordinate with Business Analysts and customers to develop business requirements and specifications documents.
Develop standard reports and functional dashboards based on business requirements.
Generate reports for internal and external customers for business performance monitoring and business decision making.
Work with Project Manager in developing and executing project plans within assigned schedule and timeline.
Manage new report generation and report enhancement based on the change requests.
Creating and deploying reports
Ensure to generate and deliver quality reports to customers in timely and accurate manner.
Identify and resolve data reporting issues in a timely fashion.
Writing relational and multidimensional database queries
Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI.
Implement the ETL infrastructure used at a project level.
Work with Project Manager in developing and executing project plans within assigned schedule and timeline.
Develop Software Application (Front-end) C++.
Database Design (MS Access 2010).
Data Analysis and rapid problem diagnosis - Run SQL queries.
Test and debug Technologies Currently Using - VBA Access 2010.
Writing relational and multidimensional database queries
Identify and resolve data reporting issues in a timely fashion.
Develop Software Application (Front and back-end).
Database Design.
Work with Project Manager in developing and executing project plans within assigned schedule and timeline.
Data Analysis and rapid problem diagnosis.
Install, configure, maintain database.
ETL (SSIS).
Create stored procedures, functions and triggers. Create Reports (SAP Crystal Reports).
Create system and user documentation.
Staff training.
Liaise with staff and manager on project specifications.
Test and debug Technologies.
Development Software 1 (Cobol, C++) Information Systems 1 Systems Software (Cisco) Technical Programming (VB.NET) Communication Skills Entrepreneurial Skills Business Analysis 2 Accounting Skills Database 2 (Oracle SQL) Systems Analysis and Design Development Software 2 (C++) IT Project Management Database 3 Business Analysis 3 Development Software 3 (Oracle PL/SQL)
Maths Science Accounting Biology English Afrikaans