Investec is a distinctive Specialist Bank serving clients principally in the UK and South Africa. Our culture gives us our edge: we work hard to find colleagues who'll think out of the ordinary and we put them in environments where they'll flourish. We combine a flat structure with a focus on internal mobility. If you can bring an entrepreneurial spirit and a desire to learn and collaborate to your work, this could be the boost your career deserves.

Investec is looking for a seasoned technology leader who holds experience in Data Engineering for their Data & Insights team in the CXT/CDX Division. We are seeking an experienced and driven leader who excels at building strong relationships whilst being able to challenge the status quo and bring in new ideas.

The candidate will be responsible for managing all stages of the data engineering process, including data ingestion, transformation, modelling, and warehousing, and building self-service data products on Investec's Azure data platform (One Data Platform) using their Azure knowledge, in line with the Investec Data Experience (IDX) Azure standards.

The primary function of the data engineering role is to deliver high-quality data to business and end users across the entire Bank. This can be achieved either through self-service data products or by collaborating closely with the Analytics squad to provide modelled data warehouses for reporting and analytics purposes. In addition to this you will be providing technical oversight and thought leadership to other CXT/CDX teams in India – Collaborating with rest of the teams within CDX locally and globally to leverage effective design and solutions to our clients.

The role primarily operates in cloud environments, particularly in Azure, but also occasionally involves on-premises environments. The long-term goal being to migrate all on-premises systems to the cloud and eventually decommission them.

The Data Engineering squad falls under Group Channel Data and Insights team. In addition to working closely with the Analytics squad, the candidate will collaborate with Architecture, DevOps, Database Administrators, all other Data Engineering squads and upstream Application teams.

The role will include:

• Translating architecture designs into technical implementations.
• Building dynamic meta-data driven data ingestion patterns using Azure Data Factory and Databricks.
• Building and maintaining the Enterprise Data Warehouse (using Kimball methodology)
• Building and maintaining business focused data products and data marts.
• Building and maintaining Azure Analysis Services databases and cubes.
• Ad hoc data analysis and ‘data wrangling' using Azure Synapse Analytics and Databricks.
• Implementing and delivering to all stages of the data engineering using Investec Data Experience (IDX) templates into ODP (One data platform).
• Playing a supporting and mentoring role to junior data engineers.
• Develop, implement, and maintain relevant documentation, guidelines, checklists, and policies to promote continuous integration, ensure and improve data security, and reduce the possibility of “human error.
• Sharing support and operational duties within the team.
• Working closely with end-users to understand their business and their data requirements.

Experience, skill and capability

Experience in the following technologies is key to this role:

• Knowledge of distributed data mesh deployment methodology.
• 10+ years of experience as a data engineer.
• Experience in building robust and performant ETL processes.
• Excellent data analysis and exploration using T-SQL
• Demonstrated expertise in developing and optimising large-scale data processing applications using Apache Spark. Proficient in writing complex Spark jobs to process and analyse vast datasets efficiently.
• Skilled in leveraging Pandas for data manipulation and analysis tasks. Capable of transforming raw data into actionable insights by utilising Pandas' powerful data structures and functions.
• Extensive experience with SQL Server and SSIS
• Knowledge and experience of data warehouse modelling methodologies (Data Vault 2.0, Kimball)
• Experience in Azure – one or more of the following: Azure Data Factory, Databricks, Azure Synapse Analytics, ADLS Gen2
• Understanding and experience in Azure bicep templates for automating deployment of pipelines.
• Python and SQL (stored procedures, functions)
• Agile Methodology
• Build and maintain Analysis Services databases and cubes (both multidimensional and tabular)
• Experience in using source control, preferably GIT.
• Basic knowledge in Infrastructure as Code (IaC) - scripting and automation via Azure CLI, PowerShell, Bash, Bicep and JSON ARM and Bicep templates.
• Understanding and experience of DevOps deployment pipelines
• Effective communication and collaboration skills to work in cross-functional teams, participate in code reviews, and communicate technical concepts to non-technical stakeholders.
• willingness to learn new technologies, keep up with industry trends, and adapt to evolving development practices and tools.

Exposure in the following technologies would be preferred:

• C# and .NET framework / .NET Core
• React JS and Angular (or any modern JavaScript Framework)
• Micro-services architecture
• Asyncronous integration patterns such as event sourcing / event driven architecture
• API frameworks such as the Web API
• Mobile Development technologies such as React Native, Swift / Objective C, Andriod Java
• Container tools such as Docker or Podman

Required Qualifications

• Bachelor's degree in computer science or related field from an accredited university and/or equivalent work experience
• Microsoft Azure certifications (Mandatory AZ900, DP900, DP201, DP202), Preferred (Databricks Fundamentals, Databricks Azure Databricks Platform Architect)

As part of our collaborative & agile culture, our working week is 4 days in the office and one day remote.

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.

Embedded in our culture is a sense of belonging and inclusion. This creates an environment in which everyone is free to be themselves which helps to drive innovation, creativity and ultimately business performance. 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.

Research shows that some candidates can be reluctant to apply to a role unless they meet all the criteria. We pride ourselves on our entrepreneurial spirit here and welcome you to do the same – if the role excites you, please don't let our person specification hold you back. Get in touch!

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.