Strategy and Transformation Analyst
Consilio
- ZA-Cape Town
- 2+ years
- Bachelor's degree
- Posted
This job is closed: the employer no longer lists it.
Skills
Required
- Excel
- Model unit economics
- investment returns
- issue trees
- Pyramid
- take a blank template
Preferred
- Power BI
- Problem structuring
- EXCO
- SteerCo
This is a consulting-standard role inside a corporate.
About Consilio
- Consilio's Strategy & Transformation team works directly with the executive leadership team on the questions that shape the business: where to grow, what to build, partner or buy, and how to execute.
- Analysts own the analysis and the storyline behind those decisions across our global business lines and emerging businesses.
- We expect structured thinking, exact numbers and executive-ready slides, delivered with minimal rework.
- Consilio’s True North Values Client Experience We listen for the “why,” clearly define success, maintain accountability, and go the extra distance to create moments that matter.
- We treat everyone with respect, welcome diverse views, and partner across geographies, generations, and teams, rallying around final decisions.
- Innovation We are always curious.
- We challenge the status quo, experiment to fail forward, and build for the future.
- Grit We focus on what matters.
- We work with passion and persistence, think like an owner, and deliver results we’re proud of.
Responsibilities
- Problem structuring and analysis Break ambiguous business questions into MECE issue trees and hypothesis-driven workplans before analysis starts.
- Size markets top-down and bottom-up, triangulate the answer, and make every assumption explicit and defensible.
- Run competitive benchmarking, adjacency assessments, market-entry and build/partner/buy analyses.
- rebuild economics from their drivers rather than relying on headline benchmarks.
- Prepare materials for EXCO, SteerCo and board discussions.
- Execution support Translate recommendations into workplans, KPIs and milestone tracking with the programme team.
Requirements
- Financial and operating models Build clean, auditable Excel models with inputs, calculations and outputs separated, scenario and sensitivity toggles, and error checks.
- Model unit economics, business cases and investment returns; align assumptions with Finance.
- Own production end to end to a board-ready standard: template discipline, consistent formatting, and numbers that tie across model, slides and narrative.
- Qualifications 2 to 4 years in management consulting (strategy house, Big Four strategy, or boutique) or a structured strategy / corporate development team led by ex-consultants.
- Working fluency in MECE, issue trees, hypothesis-driven problem solving, Pyramid Principle / SCQA and first-principles reasoning, with examples of applying them.
- you can take a blank template to a clean, consistent 10-slide deck without a production team. think-cell or equivalent strongly preferred.
- Advanced Excel modelling, including scenario analysis and sensitivity tables.
- you check your own work before it reaches anyone else.
- Bachelor's degree in Business, Finance, Economics, Engineering, Actuarial Science, Mathematics or similar, with a strong academic record.
Preferred
- Honours or master's degree, MBA, or equivalent.
- Power BI or similar visualisation tools.
- How we assess Initial conversation; a timed take-home case (research, market sizing, storyline and a short deck); a case interview where you present your deck and complete a live structuring exercise; final conversation with the Director.
This role is based in Cape Town, South Africa.
Storyline and deck production Write the storyline before building slides: SCQA framing, Pyramid Principle, and a ghost deck agreed with the Director. Write action titles that state the "so what"; one message per slide; every chart labelled and sourced.
Consilio, LLC is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or any other legally protected status. #LI-ML1 #LI-On-site
