Back to Jobs
Recently postedAnyTechnology

Data Warehouse Engineer

Hays DT - MidlandsBirmingham🇬🇧United Kingdom

Quick overview

Salary£63.0k/yr
SeniorityMid Senior
Employment typeAny
Work modeHybrid
LocationBirmingham, United Kingdom
SQLTeamCityGitETLScrumSnowflakeTableauGraphQLJenkinsKanbanPythondbtRESTAzurePower BIAgileCI/CDAzure DevOpsAzure Data Factory

Job description

Grade 8 salary up to £62,994 per annum, 12-month fixed-term contract until December 2027, 40 days leave inclusive of bank holidays and university closure days, hybrid working (2 days on-site), generous pension scheme and many other generous benefits

Hays Technology is recruiting for an experienced Data Warehouse Engineer to join a leading organisation within the Higher Education sector.

Our client is seeking a Data Warehouse Engineer with extensive experience of Snowflake Cloud-based data platforms. The primary focus of this role will be the development of a Snowflake data warehouse environment and will include using multiple ETL tools and Tableau/Power BI for reporting and data visualisations. As the ideal candidate, you will be adept at working with large data sets to develop advanced, scalable Data Warehouse solutions from end-to-end. The University is still at the early stages of building a Cloud-based Data Warehouse based on Snowflake hosted on MS Azure.

The basic architecture has been established and various system components talk to each other but there is still a lot to do and this will be a huge opportunity for the right person to take ownership of the Data Platform and take it to the next level.

The successful candidate will be a hands-on Data Engineer who thrives on working in a varied and challenging environment and will use their technical knowledge to advise on how they are ingesting data, what they are ingesting and how they are using insights to drive key business decision-making.
You will have strong experience using a variety of data architecture/data modelling techniques.
You must also have a proven ability to design, develop and implement advanced data warehousing solutions and be comfortable working with a wide range of stakeholders and functional teams to understand business needs.

Knowledge, Skills, Qualifications & Experience required in order to apply:

  • Preferably Snowflake certified however must have relevant hands-on experience
  • ETL tools - how to build data pipelines using cloud ETL Tools (Azure Data Factory an advantage) with advanced data ingestion techniques.
  • Tableau/Power BI experience of integration with a cloud warehouse.
  • Data architecture and modelling experience (eg facts and dimensions, materialised views etc)
  • Experience of modelling in Data build tool (DBT)
  • Experience with the Python programming language or similar
  • Experience with source control systems such as GIT
  • Experience of working with agile teams using methodologies such as Scrum or Kanban
  • Experience of supporting junior developers
  • Experience of RESTful and GraphQL API integration
  • Experience of developing and using continuous integration and development. pipelines, with tools such as Azure DevOps, TeamCity or Jenkins
  • Data Warehouse Design - a demonstrable and broad understanding of best practices, common issues and how to solve them
  • Advanced skills in SQL
  • API experience with Change data capture capabilities in Snowflake
  • Ability to present findings in a structured, clear manner with actionable insights
  • Excellent oral and written communication skills for translating data insights into concise executive summaries and presentations.

If you have the relevant experience and would like to apply, please submit your CV.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found on our website.

Similar jobs