Data Engineer

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.

Description of role and key responsibilities

Primary function of the role is to deliver high quality data engineering solutions to business and end users across Private Client Transactional and Lending teams – either directly via self-service data products, or by working closely with the Analytics team, providing modelled data products on which they can add reporting and analytics.

Reporting to the Private Client Data Domain Lead, this role will fill a crucial role in bridging the gap between business needs, the requirements from the data analytics team and translating these into engineering delivery.

The candidate will be required to deliver to all stages of the data engineering process – data ingestion, transformation, data modelling and data warehousing, and build self-service data products. The role is a mix of Azure cloud delivery and on-prem (SQL) development. Ultimately all on-prem will be migrated to cloud and decommissioned.

The role will work closely with our Architect, Engineering lead, Analytics team, DevOps, DBAs, and upstream Application teams in Private Client Technology

Specifically, the person will:

• Work closely with end-users and Data Analysts to understand the business and their data requirements
• Carry out ad hoc data analysis and 'data wrangling' using Synapse Analytics and Databricks
• Building dynamic meta-data driven data ingestion patterns using Azure Data Factory and Databricks
• Build and maintain business focused data products and data marts
• Build and maintain Azure Analysis Services databases and cubes
• Share support and operational duties within the wider engineering and data teams
• Work with Architecture and Engineering teams to deliver on these projects. and ensure that supporting code and infrastructure follows best practices outlined by these teams.
• Help define test criteria to establish clear conditions for success and ensure alignment with business objectives.
• Manage their user stories and acceptance criteria through to production into day-to-day support
• Assist in the testing and validation of new requirements and processes to ensure they meet business needs
• Stay up-to-date with industry trends and best practices in data engineering

Core skills and knowledge

• Excellent data analysis and exploration using T-SQL
• Strong SQL programming (stored procedures, functions)
• Extensive experience with SQL Server and SSIS
• Knowledge and experience of data warehouse modelling methodologies (Kimball, dimensional modelling, Data Vault 2.0)
• Experience in Azure – one or more of the following: Data Factory, Databricks, Synapse Analytics, ADLS Gen2
• Experience in building robust and performant ETL processes
• Build and maintain Analysis Services databases and cubes (both multidimensional and tabular)
• Experience in using source control & ADO
• Understanding and experience of deployment pipelines
• Excellent analytical and problem-solving skills, with the ability to think critically and strategically.
• Strong communication and interpersonal skills, with the ability to engage and influence stakeholders at all levels.
• To always act with integrity and embrace the philosophy of treating our customers fairly
• Analytical, ability to arrive at solutions that fit current / future business processes
• Effective writing and verbal communication
• Organisational skills: Ability to effectively manage and co-ordinate themselves.
• Ownership and self-motivation
• Delivery focus
• Assertive, resilient and persistent
• Team oriented
• Deal well with pressure and highly effective at multi-tasking and juggling priorities

Any other attributes that would be helpful, but not essential for the role.

• Deeper programming ability (C#, .Net Core)
• Build 'infrastructure-as-code' deployment pipelines
• Asset Finance knowledge
• Vehicle Finance knowledge
• ABL and Working Capital knowledge
• Any financial services and banking experience

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.