Job Description
Key Responsibilities Data Analysis & Business Insight
Analyse financial, pricing and operational data to identify trends, risks and opportunities
Deliver clear insights that support commercial and strategic decision making
Partner with finance and business teams to translate data into actionable outcomes
Perform profitability, margin and cost analysis across projects, products or business units Pricing, Modelling & Forecasting
Develop and maintain pricing models and scenarios
Build financial and commercial models to evaluate performance and strategic options
Support forecasting and budgeting processes using data driven approaches
Conduct sensitivity, what if and scenario analysis to support management decisions
Monitor actuals vs forecasts and provide variance explanations Scorecards, Dashboards & Reporting
Ensure reports are accurate, automated and aligned to business objectives
Standardise reporting across finance and commercial functions
Improve visibility of performance through intuitive data visualisation
Develop dashboards that integrate financial, operational and project metrics Data Automation & Process Improvement
Automate recurring reports, data pipelines and analytical processes
Reduce manual intervention through tools, scripts and system integration
Improve data quality, consistency and processing efficiency
Document models, logic and processes to ensure sustainability and knowledge sharing Data Management & Governance
Extract, transform and validate data from multiple systems and sources
Ensure data integrity and accurate financial representation
Work closely with IT, finance systems and business users to resolve data issues
Support enhancements to data structures and reporting frameworks PMO & Project Analytics Support
Support the PMO function with data driven reporting and governance
Track project financials including: Budgets Forecasts Actual spend Benefits realisation
Build and maintain project scorecards, milestones and performance dashboards
Monitor delivery progress against timelines, scope and financial targets
Provide consolidated portfolio reporting across multiple projects or initiatives
Support business case development and post implementation reviews
Ensure consistent data standards and reporting across projects Key Performance Areas
Accuracy and reliability of analytical outputs
Timeliness and usefulness of insights delivered
Effectiveness of automation and efficiency gains
Quality of pricing, forecasting and modelling outputs
Business adoption and impact of dashboards and scorecards Minimum Requirements Qualifications BCom – Statistics & Data Science BCom – Financial Sciences BCom – Information Systems Experience
2-5 years’ experience in a data analyst or analytics role
Proven experience working with financial and commercial data
Demonstrated exposure to: o Pricing models o Forecasting and budgeting o Performance scorecards and KPIs Technical & Analytical Skills
Advanced Excel (modelling, formulas, data manipulation)
Experience with data visualisation tools (Power Bi or similar tools)
Strong data modelling and analytical capability
Automation experience using: o Google Appscript, Excel VBA, Javascript, or similar tools
Experience working with ERP / finance systems Financial & Business Knowledge
Strong understanding of: o Financial statements o Profitability and margin analysis o Pricing drivers and cost structures
Ability to link data analysis to real business and financial outcomes
Apply for Financial Systems & Data Analyst
Submit your application for this position at Macrocomm
Ready to Apply?
Submit your application for this position