BI Analyst

Boardroom Appointments; Stellenbosch; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Boardroom Appointments seeks a highly analytical Business Intelligence Analyst to explore complex data and make informed business recommendations. The role involves building data-driven solutions, dashboards, and reports, collaborating with cross-functional teams, and ensuring data quality.

Banking sector experience is preferred, with expertise in Power BI, SQL, ETL, and cloud platforms. The ideal candidate will transform large datasets into actionable insights, communicate effectively to

Qualifications

• Bachelor's degree in business, computer science, mathematics or a related field.
• Certification in data warehousing, BI and data visualization tools such as Power BI, SQL.
• Experience with ETL processes and data extraction/transformation/loading.
• Strong communication and ability to work with both technical and non-technical stakeholders.
• 5+ years in a BI/Analytics role, preferably in Banking.

Responsibilities

• Collaborate with cross-functional teams to identify business opportunities through data insights.
• Develop data-driven solutions to improve client experience.
• Collect, transform and analyse large datasets to identify trends and insights.
• Design and implement data visualizations, reports, and dashboards for a non-technical audience.
• Ensure data accuracy and quality via ongoing validation and maintenance.
• Stay current on BI trends, technologies, and best practices.

Skills

Analytical thinking

Communication

Team collaboration

Education

Bachelor's degree in business, CS, math, stats

Tools

Power BI

SQL

ETL tools

AWS/Azure

Jira

Power Automate

UiPath/Alteryx

Python/R

Job description

We are seeking a highly analytical and detail-oriented Business Intelligence Analyst to join our team. The ideal candidate will have a passion for exploring and unpacking complex data sets to make informed business recommendations.

Duties and responsibilities:

• Collaborate with cross-functional teams to identify business opportunitiesthrough the reengineering processes, data flows and insights
• Develop data-driven solutions to improve the client experience
• Collect, transform and analyse large data sets to identify trends, patterns, andinsights that support business goals and objectives
• Collect, transform, and analyse client data (propensity trends and patterns)to build business relevant insights
• Design and implement data visualizations, reports, and dashboards thateffectively communicate complex information to a non-technical audience
• Ensure data accuracy and quality by performing ongoing data validation andmaintenance
• Knowledge of data privacy and security regulations and best practices
• Stay current on industry trends, technology, and best practices in businessintelligence, data analysis, infonomics, automation and visualisation
• Understanding and or experience in change management methodology(ADKAR)
• Help create a culture that promotes data-driven decisions backed byinvestigation and collaboration around data

Qualifications and experience:

• Bachelor's degree in business, computer science, mathematics, statistics, or arelated field
• Certification in data warehousing, business intelligence, and data visualizationtools such as Power BI, and SQL
• Experience with data extraction, transformation, and loading (ETL) processes
• Ability to work independently and in a team-oriented environment
• At least 5 plus years experience in a similar role within the Banking sector(preferably)
• Understanding of project management methodologies and experience withproject management tools such as Jira
• Strong written and verbal communication skills and ability to communicateeffectively with both technical and non-technical stakeholders

Technical skills:

• Proficient in using data visualization tools such as Power BI (Desktop andCloud Service) + Power Query Editor
• Experience with data extraction, transformation, and loading (ETL) processes
• Strong SQL skills for querying large and complex data sets
• Experience with data warehousing
• Familiarity with cloud computing platforms, such as Amazon Web Services(AWS) or Microsoft Azure
• Preferably have AWS Cloud Practitioner certification
• Experience in process automation using tools such as Power Automate, AgilePoint, Power Apps, UiPath or Alteryx
• Ability to use scripting languages such as Python or R for data analysis andmanipulation
• Advanced functions and concepts in Power BI DAX
• Knowledge of AutoML using Power BI or AWS Sagemaker
• Advanced Excel and Power Query editor
• Version Control (Git) Microsoft productivity suite (Power Point, Word, Excel, OneDrive, Sharepoint)