Analytics Engineer
Ref: JO-2611-364626
- South Africa, Cape Town
- Software Development & Engineering, Technology
- IT
- 5,000+ Employees
- ZAR 0.00 - ZAR 800.00 per annum
- Environment: Hybrid
- Contract Type: Contract
- Starts: 2027-01-04
- Duration: 6-months
Analytics Engineer, Portfolio Intelligence | Contract | Cape Town
About the Role
A leading global investment firm is looking for an exceptional Analytics Engineer to sit between the business and its data platform. You’ll turn the way investment, finance, and portfolio teams think about performance into governed, trusted, well-modelled data that is ready to use in BI tools.
This is a hands-on role. You’ll build the semantic layer, shape the BI products on top of it, and be a confident voice with business stakeholders. It calls for high autonomy and strong collaboration skills, within one of the most transformative teams in the industry.
Due to the high volume of applications expected, candidates who have not received feedback within two weeks of applying should consider their application unsuccessful.
Key Responsibilities
- Design, build, and own the semantic layer, with consistent metric definitions, dimensions, and business logic that BI tools consume
- Develop and maintain transformation pipelines and data models in dbt on Snowflake, following software engineering best practice (testing, documentation, version control, CI/CD)
- Build and optimise reports and dashboards in Sigma, working to a “model once, use everywhere” principle
- Work directly with investment professionals, finance, and portfolio operations to understand requirements, challenge assumptions, and translate them into data requirements and technical delivery
- Translate financial and portfolio concepts, such as charts of accounts, fund and entity structures, KPIs, valuations, and cash flows, into clean, reconcilable data models
- Standardise and harmonise data across a broad portfolio of assets and source systems
- Use AI to deliver high-quality analytics solutions at pace and help the team find better ways of working
- Own the solutions you deliver, including data quality, documentation, and ongoing support
- Promote data literacy, stewardship, and knowledge sharing across business and technical teams
- Challenge and elevate the team’s ways of delivering analytics
Requirements
- 5+ years of experience in analytics engineering, data engineering, BI development, or related fields
- Expertise in SQL, including complex analytical queries, performance tuning, and dimensional modelling
- Hands-on, production experience with dbt (models, tests, macros, documentation, CI/CD)
- Strong hands-on BI tool experience, with a track record of delivering dashboards used by senior stakeholders (competence across multiple BI tools is valuable, Power BI in particular)
- Demonstrable experience building and maintaining a semantic layer, whether in the transformation layer (dbt models, metric definitions) or the BI layer (Sigma data models, Power BI semantic models), including metric governance
- Strong data modelling expertise, translating the real world into an information structure
- Ability to gather requirements from non-technical stakeholders, challenge them constructively, and communicate technical solutions clearly
- Experience in private equity, asset management, investment banking, fund administration, or related financial domains, including the ability to read a chart of accounts and financial statements
- Proficiency in data management, governance, and compliance standards
- Bachelor’s or Master’s degree in Computer Science, Data Engineering, Finance, or a related field
Advantageous
- Hands-on experience with Sigma
- Hands-on experience with Snowflake
- Python for data transformation
- Fivetran or similar ELT tooling
- Familiarity with fund reporting concepts (NAV, IRR/MOIC, capital calls and distributions, portfolio company KPIs)
- Experience using AI-assisted tooling to accelerate analytics development
- Agile or Scrum delivery experience
What Makes Someone Successful Here
You’re highly motivated, proactive, and resourceful. You can drive data stewardship and knowledge sharing, and you work as comfortably with investment professionals as you do with engineers.
Role Details
- Employment type: Contract
- Location: Cape Town – Newlands – Hybrid
- Rate: Depending on experience
Salt is acting as an Employment Business in relation to this vacancy.

Share: