BI Analyst
Centurion, South Africa
ZAR 384K-420K (estimate) Mid-level Full Time
Tasks
- Automate repetitive Excel reporting tasks with macros VBA or Power Automate
- Build and maintain advanced Excel models using dynamic arrays
- Conduct advanced ad hoc analytics for business questions
- Coordinate analytics demand and manage change requests
- Create and maintain self service reporting solutions
- Design build and maintain Power BI dashboards and reports
- Develop data models and calculated columns in Power BI
- Develop statistical and analytical models for forecasting and scenario analysis
- Implement data quality checks and validation processes
- Implement row level security and workspace governance in Power BI
- Integrate Power BI with Microsoft 365 tools
- Lead migration from Looker Studio to Power BI
- Maintain data dictionaries and consistent definitions
- Perform data collection cleansing reconciliation and transformation
- Perform deep dive analysis to find trends anomalies patterns
- Productionize recurring insights into automated dashboards
- Support FP and A with budgeting forecasting and business reviews
- Translate raw data into structured insights for executives
- Use DAX for reporting requirements
- Work with IT and Data Engineering to ensure data availability integrity and access
Perks/Benefits
- N/A
Skills/Tech-stack
Claude AI | DAX | Data Governance | Data Modeling | Data Quality | Data dictionaries | Dynamic Arrays) | Excel | Excel Dynamic Arrays | Forecasting | Jira | Looker Studio | Macros | Matplotlib | Microsoft Copilot | NumPy | Pandas | Power Automate | Power BI | Power Pivot | Power Query | Prompt engineering | Python | Row Level Security | SQL | Scenario Analysis | Seaborn | Statistical Analysis | VBA
Education
Bachelor of Engineering | Bachelor of Science | Master of Science
Roles
Related jobs
-
Data Analyst ZAR 300K-420KData Visualization | ETL | Machine Learning | Power BI | Predictive AnalyticsMid-level Full TimeStellenbosch, ZA1d ago
-
Data Analyst - AVP ZAR 540K-660KClickView | Credit Risk | Dashboards | Data Governance | Data MappingExecutive-level Full TimeAbsa Towers West, South Africa2d ago
-
Agile | AngularJS | Bootstrap | Business Intelligence | C SharpMid-level Full TimeHybrid in Johannesburg, Gauteng, South Africa R3d ago
-
Business Intelligence | Data Analysis | Data Visualization | Data cleaning | Data reportingCareer development | Growth opportunities | Remote workEntry-level Full TimeMexico - Monterrey R5d ago
-
Asset Inventory | Data Analysis | Data Dictionary | Data Governance | Data StewardshipSenior-level Full TimeCape Town, South Africa5d ago
-
Finance Digitization & Analytics Analyst (Africa) ZAR 360K-420KAccounting | Automation | Calculated Fields | Controlling | DashboardingMid-level Full TimeJohannesburg - Puma Office, South Africa5d ago
-
Data Warehousing | ETL | Looker | Power BI | PythonCareer growth | Flexible UK business hours | Professional development | Remote workMid-level Full TimeSouth Africa - Remote R5d ago
-
Data Cleansing | Data Deduplication | Data Validation | GDPR | Microsoft ExcelApprenticeship training | Career progression path | MentorshipExecutive-level Full TimeSouth Africa - Remote R6d ago
-
OM Bank - Credit Quantitative Analyst ZAR 336K-420KBack Testing | Credit Origination Analytics | Credit Risk | Credit origination | Credit risk analyticsEntry-level Full TimePinelands, South Africa6d ago
-
OM Bank - Senior Credit Quantitative Analyst: Impairment, Credit & Regulatory Reporting ZAR 576K-624KBacktesting | Credit Risk | Credit risk analytics | Data Analysis | Data VisualizationSenior-level Full TimePinelands, South Africa6d ago
-
Quantitative Analyst ZAR 420K-480KBasel capital | Business Writing | Credit Risk | Credit Risk RWA | Data AnalysisHybrid workMid-level Full TimeJohannesburg, ZA6d ago
-
Data Analyst & Performance Management Specialist ZAR 300K-420KBusiness Analytics | Business Intelligence | Dashboard Development | Data Analysis | Data GovernanceMid-level Full TimeSouth Africa7d ago
-
Executive Head: Pricing & Analytics ZAR 660K-840KARPU | Analytics | Big Data | Business planning | ChurnExecutive-level Full TimeMidrand, ZA7d ago
-
AI analytics | Attribution | Business Intelligence | CRM | Cohort AnalysisHybrid workMid-level Full TimeCape Town, Western Cape, South Africa R9d ago
-
Senior Specialist Analytics & Enablement ZAR 540K-650KAnomaly Detection | Azure Data | Azure Data Factory | Azure Synapse | DAXSenior-level Full TimeSandton, South Africa9d ago
-
Senior Data Analyst ZAR 600K-720KAgile | Data Analysis | Data Cleansing | Data Enrichment | Data MiningSenior-level Full TimeCape Town, WC, ZA11d ago
-
Senior Analytics Engineer ZAR 600K-600KAI analytics | DBT | Dagster | Data Governance | Data ModelingFlexible work schedule | Hybrid work | Life insurance | Matched pension scheme | Paid parental leaveSenior-level Full TimeCape Town, South Africa R12d ago
-
Data Analyst ZAR 360K-420KCohort Analysis | Dashboard Design | Data Dictionary | Data Documentation | Data ModelingMid-level Full TimeSouth Africa13d ago
-
BI Analyst ZAR 420K-480KData Modeling | ETL | Excel | Power BI | Power QueryCareer development opportunities | Employee wellness benefits | Hybrid workMid-level ContractCape Town, South Africa R14d ago
-
Senior-level Full TimeCape Town14d ago
-
Quantitative Analyst – Legal & Financial Structures ZAR 500K-600KArtificial Intelligence | Data Analysis | Excel | Financial Modeling | Machine LearningRemote workExecutive-level Full TimeCape Town, Western Cape, South Africa R14d ago
-
(1797) Associate Economic Statistician - ESD ZAR 360K-426KBusiness Intelligence | Data Management | Data Reconciliation | Data Validation | Economic analysisMid-level Full TimePretoria, South Africa14d ago
-
Mid-level Full TimeFNB Financial Center, United States14d ago
-
Senior-level Full TimeStellenbosch, ZA14d ago
-
Data Analyst - SPARK Schools Support Office - 2026 ZAR 249K-249KAzure | Data Governance | Data Modeling | Data Pipelines | Data QualityAnnual leave | Career growth opportunities | Disability cover | Employee Discount on School Fees | Funeral CoverMid-level Full TimeRandburg, Gauteng, South Africa15d ago