Business intelligence analyst
Summary
Design and maintain Power BI dashboards and SQL-based reports to deliver business insights for Woolworths Financial Services, extracting and transforming data from databases and warehouses.
To leverage data effectively to support business areas in decision-making and operational management while delivering meaningful and valuable insights to aid in the strategic delivery of Woolworths Financial Services. To ensure timely and precise generation of both standard and on-demand reports and dashboards.
Key Responsibilities Design, develop, and maintain analytical tools and dashboards using Power BI to visualise and report business metrics and continuously upkeep and distribute data visualisations, prototypes of reports, and data-driven analyses and insights. Extract, load, and transform data from various databases and data warehousing systems using SQL to ensure data is accessible and reliable. Conduct ad-hoc analyses and present results clearly to technical and non-technical stakeholders. Monitor analytics and metrics results, perform root cause analysis on data anomalies. Converting business requirements into technical specifications and documenting them accordingly. Establish suitable and impactful business relationships while engaging with key stakeholders. Stay current with industry trends and developments in BI technology and practices, adopting best practices wherever possible. Requirements Competencies Strong analytical and problem-solving abilities. Stakeholder Management Effective time management and organizational skills. Good business acumen. Ability to communicate complex data in a simple, actionable way. Minimum Qualifications Matric/Grade 12 with mathematics. Degree / Diploma in Finance, Business, Information Systems, Statistics, or data related field. Experience Required 2-5 years’ experience within Banking, Financial services, or retail industry as a BI/Data analyst Practical expertise in analytics, data visualisation, or reporting functions. Proficient in Microsoft Power BI for creating dashboards, reports, dataflows etc. Strong experience with SQL and relational databases, including advanced queries and stored procedures. Working knowledge of Data Management. Ability to work with various data sources and data tables. Experience with AWS services related to data storage, data processing, and analytics