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 and Analytics Engineer who is enthusiastic to enable data engineers and data analysts by practically demonstrating best value focused usage of data, Data engineering in Fabric and build data analytics in Power BI.

This role involves working closely with various stakeholders to understand their data needs , enable them for data engineering as per best practices and delivering high-quality, performant reports / dashboards and visualisations.

Key Responsibilities:

Data Sourcing and Lakehouse Engineering in Microsoft Fabric and Databricks

• Build and maintain bronze, silver, and gold layers in Microsoft Fabric and Databricks.
• Develop ingestion and transformation pipelines using:

• Notebooks
• Spark (PySpark preferred)

• Implement incremental loading and change data capture patterns from on-prem SQL to Fabric or Databricks.
• Optimize Delta tables for performance and cost efficiency.
• Ensure datasets align with defined data contracts and platform standards.

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

• Define and document self-service playbooks.
• Design semantic models that are intuitive and consumption ready.
• Support the creation of reusable datasets and governed templates.
• Create documentation, training materials, and usage guidelines.
• Promote responsible and governed self-service practices within the domain.

Conversational & AI-Driven Analytics

• 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.
• Identifiy high value use cases for AI-enhanced analaytics within domain.

Legacy BI Transition Support

• Share best practices and approaches for migration of reports and analytical assets from:

• SSRS
• SSAS
• SQL-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 practices,

Core skills and knowledge:

• 5-10 years of relevant experience as a Data engineer and Analyst
• Strong Engineering skills and product mindset with experience of having buit or contributed to Framework, template, library, accelerator, standards or shared semantic model.
• Analytical Skills and Power BI Reporting skills
• Ability to translate business requirements into data and technical design artifacts.
• Strong programming skills in python and sql.
• Proven experience in Azure Data Platform technologies:

• Microsoft Fabric, Spark , spark SQL , Python , Power BI, SQL

• Experience developing or supporting executive-level reporting or dashboards.
• Strong documentation skills to prepare content for enablement, create / record video
• Strong communication skills, Community engagement, Hands-on lab, workshop, mentoring, onboarding
• Good understanding of data warehousing, data modelling, Data Visualization
• Familiarity with Agile delivery and data governance frameworks.
• Solid understanding of dimensional modeling, including star schema and Kimball-based methodologies.
• Experience designing and optimizing semantic models for enterprise analytics platforms such as Power BI
• Experience working in enterprise-scale or regulated environments with disciplined delivery practices.

Desirable Skills:

• Good to have Power Automate/ Alerting knowledge
• Good to have AI/ML Model building experience and Azure ML/Python/R.
• Experience with Spark (PySpark preferred) for distributed data transformation, Python notebooks.
• Familiarity with CI/ CD tools - github / Azure repo
• Familiarity with SSIS, SSRS, and SSAS, including modernization of legacy BI assets.
• Experience in Fabric Agents, Power BI to Fabric Migration,
• Understanding of KPIs in Banking/ financial services / capital markets (e.g., balance sheet metrics, profitability, risk indicators).
• Exposure to AI/ML data preparation worlflows.
• Experience with statistical analysis and forecasting.
• Contributions in engineering community/guild,
  Community leadership, champion network, hackathon, knowledge article, repository or forum.

Preferred Qualifications:

• Microsoft certifications ( DP-700 Microsoft Certified: Fabric Data Engineer Associate/ Azure Databricks Data Engineer Associate (Exam DP-750/Azure Fabric Data Analyst - DP600, Power BI Analyst - PL300)

Bachelors or Masters in Computer Science / Engineering

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.