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.



The Data Engineer will be responsible for designing, building, and maintaining the data architecture and infrastructure necessary for effective data processing and analysis. This role involves collaborating with data analysts, and other stakeholders to ensure that data is accessible, reliable, and optimised for use in various applications.




Key responsibilities:



• Work closely with end-users and Data Analysts to understand the business and their data requirements



• Carry out ad hoc data analysis and transform data using Databricks, MS Fabric, or Synapse Analytics.



• Building meta-data driven data ingestion patterns using Azure Data Factory and Databricks, or MS Fabric, or Synapse



• Build and maintain the on-premises SQL Data Warehouse



• Build and maintain business focused data products



• Build and maintain Azure Analysis Services cubes



• Share support and operational duties



• Work with Architecture and Engineering teams to deliver 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.



• Stay up-to-date with industry trends and best practices in data engineering



• Collaborate with Data Engineering Lead, Data Domain Lead and Architect to drive group engineering context within the team continuously



• Drive engineering efficiency and deliver high-quality software quickly within the team



• Cultivate a culture focused on security, risk management, and best practices in engineering



• Actively engage with the business units engineering community to promote knowledge sharing



• Develop and promote exceptional engineering documentation and practices



• Build a culture of development and mentorship within the team



• Provide guidance on technology and engineering practices



• Collaborate with squad leader, Head of, engineers, and architects to ensure cohesive strategies and practices within the team



• Actively encourages creating Investec open-source software where appropriate within the business unit



• Actively encourages team members within the business unit to speak at technical conferences based on the work being done




Core Skills and Knowledge:



• Proven engineering expertise (8+ years)



• 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, in particular Star Schema and Snowflake Schema



• Experience in Azure - one or more of the following: Data Factory, Databricks, MS Fabric, Synapse Analytics, ADLS Gen2



• Experience in building robust and performant ETL processes



• Experience in using source control, CI/CD pipelines, and Azure DevOps



• Build 'infrastructure-as-code' deployment pipelines



• Familiarity with modern engineering practices and data store design, in particular Lakehouse and Medallion architecture.



• Familiarity with the Data as a Product approach



• 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.




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



• Credit Risk knowledge (understanding of credit risk objectives, processes and terminology)



• Finance knowledge (understanding of finance processes and terminology)



• Lending knowledge (understanding of lending products, processes and terminology), 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. We believe that being together enables us to live our values and support our clients and communities in an extraordinary way.



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.