Description

The Credit Risk Tech team develops and maintains technology solutions that help financial institutions assess, monitor, and manage credit risk. This role involves working closely with risk stakeholders to build tools, models, and systems that evaluate borrowers' creditworthiness, automate credit assessments, ensure regulatory compliance, and support decision-making through data integration and analytics.

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.

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 – but we are only part way along that journey.

Key responsibilities include:

•    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

Experience, skill and capability

•    Proven engineering expertise
•    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

Investec Culture 

At Investec we look for intelligent, energetic people filled with passion, integrity and curiosity. We value individuals who in turn value our culture that is, a flexible attitude comfortable to live with ambiguity and willing to challenge the status quo. Diversity, talent and leadership are respected in pursuit of the growth of our business. People who can manage themselves and build strong relationships in order to get things done, will perform in out of the ordinary ways in our environment. 

We are committed to diversity and inclusion when recruiting internally and externally.