Senior Business Intelligence, Reporting and Insights Analyst - Boksburg at CHEP

Position Purpose :

• The Senior BIRA Analyst must take the lead in the development, ownership and accountability of Business Intelligence Products for the allocated function/s for the business based on business requirements. This includes full stack development from data gathering, ETL implementation, modelling and final production of the Business Intelligence Product.

This includes advanced projects and accountabilities with multiple levels of complexity.

Scope :

All dashboards/reports across IMETA across all functions or specific complex and complicated portfolios.

Major/Key Accountabilities :

• Engage and own the key relationships with stakeholders across the regions within the specific function/s within their portfolio as the BIRE SME in the function.
• Translate complex business requirements into actionable user-friendly business intelligence products to support the IMETA, BIRA, regional and functional strategies and decision making.
• Translate complex data from multiple data sources into information and insights to drive decision making at several levels i.ie. data driven decision making.
• Design, develop and deploy advanced ETL solutions to extract data from several data sources, transform and load into the warehouse (Amazon (AWS) RDS).
• Leverage best practice in deployment of business intelligence solutions.
• Design, develop and deploy reports/dashboards and data products as per business needs in IMETA (ensuring data accuracy and stability). Also accountable for what products are deployed into the functional BI Product Suite and ensuring they align with the functional strategy and regional strategy.
• Drive best practice implementation to improve the product offering to business stakeholders.
• Lead strategy initiatives undercovering opportunities based on data trends.
• Complete required documentation for reports/dashboards/data products created to ensure knowledge management best practice are met.
• Propose enhancements on new/current reports (standardization, usability, workload).
• Frequently ensure that reports/dashboards/databases are timely updated and in accordance with set standards to ensure business has the most updated in time reports, dashboards, etc.
• Lead various projects at once across various regions for the function/s within the individuals accountability.
• System reporting owner for systems linked to the function.
• Mentor more junior analysts in the team.
• Own and lead the function/s within the Business Intelligence Product Suite end to end.

Measures

• Implementation of business intelligence products against the project plan and ad hoc business requirements; and within timelines agreed. Alignment of the BI products to the functional strategy.
• Ensure downtime of dashboards, reports, data products, ETL packages and other BI related items no more than 5% of the time.
• Ensure reports and dashboards are developed as per customer requirements and backend implementation done according to agreed best practice.
• Drive customer usage of products developed.
• Collaborate, drive and lead the deployment and implementation of functional BI Products developed by global teams into the region.
• Customer satisfaction.

Key requirements:

• Technology/Statistics/Information Management/Information Systems/ Financial Management/Computer Science related degree (3 year degree)
• Minimum of 5 years working experience in a similar role (Business Intelligence analyst/Data Engineer/Data Analyst).

Previous business intelligence experience is a non-negotiable specifically in:

• Experience working with large datasets, data modelling and database knowledge (Experience with Amazon RDS is a plus).
• ETL Experience (Design, development and deployment of complex ETL processed).
• Experience in writing complex queries, data modelling and performance tuning based on best practice.
• Experience in merging complex variety of datasets into meaning insights and information for decision making.
• Previously developed complex and advanced business intelligence visualization products specifically PowerBI solutions.
• Experience translating business requirements into powerful business solutions.
• Worked with measures and KPIs.
• Change management.
• Project management experience (manage priorities, standardization, automation, troubleshooting and short-term planning).
• Experience working with senior leaders and alignment on products aligned to driving strategic deliverables or focus areas.
• SAP Business Objects and SAP BW experience (is a plus)
• Good understanding of Finance

Skills and Knowledge

• Strong service orientation
• Very good customer orientated skills
• Extremely flexible and able to work under pressure
• Diplomatic and sensitive when serving customers of a different mentality and culture.
• Can act under time pressure and interact with senior level stakeholders.
• Ability to work autonomously.
• Ability to work with remote teams.
• Driven by results.
• Ability to learn on the fly.
• Problem solver (troubleshooting).
• Ability lead project and streams with little guidance.
• Ability to mentor and guide juniors.
• Ability to contribute to the BIRA strategy, data governance, etc. that will assist in the standards to be implemented in the BI Space.

Technical skills:

• Advanced Analytical Skills.

Full Business Intelligence stack skills:

• SQL (Highly proficient) and SSMS.
• Postgre SQL
• ETL (Proficient) in SSIS.
• Modelling (SSAS).
• Visualization, dashboard development and storytelling (PowerBI (Advanced)). Advanced Proficiency.
• Excel (Advanced skills).