Job description

Loading...
  • Location:
    London - 30 Gresham Street
  • Department:
    Central, Trading and Risk
  • Division:
    IBP Digital and Technology
  • Employment Type:
    Full time
  • Salary:
    Competitive

Data Engineer (6151)

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.

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!

Investec is looking for an experienced Data Engineer to join the Specialist Bank Risk Technology team. The successful candidate will have strong experience designing BI solutions using Microsoft stack preferably within Investment banking or Financial services experience (general products and processes knowledge; market, reference and regulatory data).

What will you be doing?

  • Designing and building end to end BI solutions, that will extract data from multiple systems, transforming and loading into multiple reporting data warehouses
  • Working with end users and analysts on requirements and translate them into technical specifications
  • Supporting our existing BI Platform, reverse engineering and improving processes
  • Follow and contributing to departmental development process in terms of standards, methodologies etc
  • Mentor junior members, drive and implement industry best practices, evaluate and introduce new tools, design and improve existing ETL framework, data validation framework
  • Assist in the migration to an off premise Cloud Solution (Specifically Microsoft Azure)

What skills are we looking for?

  • Excellent data analysis and exploration using T-SQL, and strong SQL programming (stored procedures, functions).
  • Knowledge and experience of data warehouse modelling methodologies
  • Microsoft SQL Server performance tuning, backup and recovery, data encryption, capacity planning, understanding of database engine internals and all database objects.
  • Extensive experience of using SSIS, script tasks, custom plugins
  • Significant experience designing solutions following Kimball methodology and good knowledge of data modelling concepts
  • Experience of building solutions with SSAS, advanced knowledge of SSAS, MDX, performance tuning
  • Experience of building reports using SSRS, PowerPivot, integration with SharePoint, building corporate reporting portals, KPIs, dashboards, self-service BI

Some non-essential extras that are advantageous

  • Experience in Azure, in particular Data Factory, Synapse, and Databricks 
  • Good understanding of Data Lakes,
  • Some programming ability (C#, .Net Core)

 

 


 
Loading...
Close map
Location
London - 30 Gresham Street
30 Gresham Street, London, England, GB, EC2V 7QN
Loading...

Meet the recruiter

Laurette Moon

LinkedIn

We commit to ensure that everyone is fairly assessed during our recruitment process.

Let us know if you need any reasonable adjustments to complete your application.

Loading...
Share this page
Share with linkedin
Share with facebook
Share with twitter
Share with email
Job Alerts
Create an alert subscription based on this Job

Benefits

Pension
Private Medical Cover
Virtual GP
Gym Discounts
Psychologist Service
Annual Leave
Life Assurance
Loading