Investec – Where Out of the Ordinary Happens

At Investec, we do things differently. We're a leading international bank and wealth manager built on a culture of curiosity, entrepreneurial spirit and human connection. Ideas are heard, ambition is celebrated, and impact is encouraged. As part of a team that challenges convention and strives for outperformance, you'll help shape bold solutions for clients who expect something more than the ordinary.

We are seeking a highly skilled Data Analyst to deliver and evolve domain-aligned analytics products within a centrally governed Microsoft data platform.
This role involves working closely with various stakeholders to understand their data needs and delivering high-quality, performant reports / dashboards and visualisations.
Key Responsibilities:
Business Logic & Data Product Definition
•Translate business requirements into structured analytical specifications.
•Define KPIs, metric calculations, and validated business rules.
•Collaborate with Data Engineers to ensure transformations accurately reflect domain logic.
•Validate outputs during SQL-to-Lakehouse modernization.
•Contribute to the lifecycle management of domain data products.Semantic Modeling & Analytics Layer Ownership
•Design and maintain Fabric semantic models aligned to enterprise standards.
•Implement star schemas optimized for Power BI performance and self-service.
•Refactor legacy SSAS and reporting logic into governed semantic layers.
•Ensure metric consistency across dashboards and analytical assets.
•Balance performance, usability, and governance in semantic design.Power BI & Insight Delivery
•Conduct exploratory data analysis to identify trends, patterns, and anomalies.
•Apply statistical techniques and models to interpret data and generate insights.
•Design, develop, and maintain interactive Power BI dashboards and reports as per persona/stakeholder requirements.
•Develop complex DAX calculations, KPIs, and time-intelligence metrics.
•Optimize report performance and implement row-level security (RLS).
•Monitor adoption and usage of analytics products.
•Continuously refine reports based on business feedback.
Reusable scripts/ Reports/ CI/CD
•Develop Python scripts for automation, data processing, and advanced analytics.
•Integrate Power BI with external systems and APIs.
•Automate recurring reports and data refresh workflows.
•Implement version control and documentation for BI solutions.
Self-Service Analytics Enablement
•Partner with the Analytics Enablement team to define and document self-service playbooks.
•Design semantic models that are intuitive and consumption ready.
•Support the creation of reusable datasets and governed templates.
•Contribute to documentation, training materials, and usage guidelines.
•Promote responsible and governed self-service practices within the domain.
Conversational & AI-Driven Analytics
•Collaborate with the Analytics Enablement team to define playbooks for AI agents and conversational analytics.
•Ensure semantic models support natural language querying and AI interpretation.
•Structure datasets to enable accurate AI-generated insights.
•Validate AI-driven outputs against business logic and KPI definitions.
•Identify high-value use cases for AI-enhanced analytics within the domain.
Legacy BI Transition Support
•Support migration of reports and analytical assets from:
oSSRS
oSSAS
oSQL-based reporting environments
•Validate modernized outputs against legacy results.
Contribute to structured decommissioning of legacy BI artifacts.
Continuous Improvement:
•Stay updated on industry trends, tools, and best practices in data analysis.
•Suggest improvements to data processes and methodologies for enhanced efficiency.
•Develop and promote reuse, standards and practices via playbooks
•Collaborate with COE community to drive group analytics context within /across teams via knowledge sharing sessions
•Cultivate & participate in culture focused on data quality, data governance, data security best practices

Core Skills & Competencies :

As part of our collaborative & agile culture, our working week is 4 days in the office and one day remote. We believe that being together enables us to live our values and support our clients and communities in an extraordinary way.

Investec offers a range of wellbeing benefits to make our people feel healthier, balanced and more fulfilled in their lives inside and outside of work. You can find a list of our benefits here

Embedded in our culture is a sense of belonging and inclusion. At Investec we want everyone to find it easy to be themselves, and to feel they belong. It's a responsibility we all share and is integral to our purpose and values as an organisation. We believe that innovation thrives when everyone feels respected, included, and empowered to contribute.

We actively seek out diverse talent and foster an inclusive environment, encouraging applications from people of all backgrounds and experiences. Here, you'll find networks, benefits, and development opportunities designed to support your career journey, wherever it may lead.

If this role excites you but you don't meet every requirement, we'd still love to hear from you. Your unique perspective and experience could be exactly what we are looking for.  Get in touch!

At Investec, we're deeply invested in our clients, our colleagues, and our communities. It's more than a mindset; it's how we show up every day.

Be part of something Out of the Ordinary.

Recite Me

We commit to ensure that everyone is fairly assessed during our recruitment process. To assist candidates in completing their application form, Recite Me assistive technology is available on our Careers pages. This can be accessed by clicking on the ‘Accessibility Options' link at the top of the page.

The Recite Me tool includes a screen reader, styling and customisation options, a series of reading aids, a translator and more.

If you have any form of disability or neurodivergent need and require further assistance in completing your application, please contact the Careers team at [email protected] who will be happy to assist.