Hymans Robertson

Internship – Data Engineer

This opportunity is powered by the #BlackInterns Program which is a Black Professionals United Kingdom (BPU) initiative.

We are creating internship opportunities for members of the Black community across UK.

About Us

Hymans Robertson LLP is a leading financial services company employing 1,000 people across the UK.  Our clients are employers, trustees and financial services institutions. We offer independent pensions, investments, benefits and risk consulting services as well as data and technology solutions.

Our firm invests in the very latest technologies to facilitate the delivery of our ground-breaking business solutions.  Our team are passionate about working at the cutting edge and you will have the chance to work with the most up to date Microsoft tools and technologies on Azure. You will be part of a team that employs an agile approach to software design and implementation.

The Opportunity

The role sits within the Third Party Administration (TPA) Systems team, and will focus on the modernisation and continuous improvement of data transformation and analysis within this business area.

  • Your initial focus will be on modernising an existing key business solution, and rearchitecting for Azure for analytical processing.
  • You will take a pragmatic, well-structured approach to designing and developing data storage solutions adhering to the firm’s Information Security standards, policies, and procedures.
  • You will identify requirements and develop data solutions with key stakeholders and other members of wider data team within the our Azure Lakehouse.
  • You will keep abreast of the latest developments in data tooling, promoting best practice and guidance to the wider business. We love learning at Hymans so you will have freedom and flexibility to look at new technology and bring your own stamp to what we are doing.

About You

You will be comfortable working as part of a team, as well as having the initiative to explore solutions on your own.  The position offers an excellent opportunity for a commercially experienced data engineer or developer to work with the latest tools whilst also contributing to architectural and technical design decisions. You will also enjoy collaborating with software developers, data engineers, core IT and the wider business to deliver high quality solutions.

To succeed in, and enjoy this role, you will either be working with Azure tools already or have an established background in Microsoft SQL database technologies and be excited about transitioning these skills to the cloud.

Highly Desirable

  • Comfortable dealing with large volumes of data, generally time series and numeric data
  • Experience within a highly transactional data environment and developing solutions to minimise data loss and maintain data integrity
  • A background in SQL database technologies utilising both on-premise and cloud infrastructure
  • Experience of (or willing to learn) Azure Data technologies and services including
    • Azure Databricks
    • Azure Synapse Analytics
    • Azure SQL DB
    • Azure Data Factory
    • Azure Data Lake
  • Experience building robust, production ready, scalable data pipelines
  • Be familiar with optimising strategies, pipeline architectures, datasets and ETL/ELT processes
  • Confidence to engage constructively in a multi-disciplined team environment

 Great to Have

  • Experience or familiarity with some of the following:
    • Visualisation tools such as Power BI or similar
    • Coding in R, Python, Scala or .net
    • Microsoft Power Apps
    • Data Modelling and data science practices
    • NoSQL technologies
    • Experience with data orchestration platforms like Airflow, Prefect or Dagster
  • Understanding and experience of provisioning APIs for data consumption
  • Familiarity with continuous integration, continuous delivery, agile methodologies and Azure DevOps

You Will Likely Be:

  • Passionate about technology including the Hymans chosen technology stack (Microsoft development stack, Azure Cloud computing, Data Analytics/Data Science technologies)
  • Self-motivated with a drive to learn and share knowledge
  • Focused on continuous learning and improvement
  • An effective communicator and a great team player
  • Able to forge strong and professional relationships at all levels
  • Able to think expansively and seek new perspective

REPORTING TO: Principal Engineer

Hours per week:  35 hours

Duration: up to 12 weeks

Commencing: 3 June 2024

Remote/Office/Hybrid: Hybrid, min 2 days per week in office (Edinburgh or Glasgow)

Location: Glasgow or  Edinburgh

SALARY: £420 per week

How do I apply?

  1. If you are not already a BPU member, register for free with Black Professionals United Kingdom by following this link https://blackprofessionals.uk/register/
  2.    Send a CV (2 pages max) and cover letter (250 words max) to workplacements@blackprofessionals.uk.
  3.    In the subject field of your application email, simply type “BPU018 – Name” Eg. If your name is John Mensah, kindly type “BPU018 – John Mensah


To apply for this job email your details to workplacements@blackprofessionals.uk