Redshift Data Warehouse Developer

About us

dmg events is an international exhibitions and publishing company. We attract more than 425,000 visitors to our global portfolio of 80 exhibitions each year. Through our global events, our aim is simple. We want to accelerate business through face-to-face events, which is why we work so hard to bring people together, creating opportunities for them to network, learn and do business. dmg events is part of the Daily Mail Group Trust (DMGT). DMGT Manages a diverse, multinational portfolio of companies with total revenues of £2bn, that provide businesses and consumers with compelling information, analysis, insight, events, news, and entertainment.

Introduction

We seek an experienced data warehouse developer to join our ever-expanding data team. In this role, you will be responsible for designing, deploying and maintaining the ETL structures in our data warehouse housed in Redshift. You will collaborate with other teams to ensure our cloud environment meets all architectural, operational and integration requirements.

Responsibilities:

• Developing, testing and documenting procedures to bring new data into the warehouse
• Model and create new facets of the warehouse as and when we ingest new data types and sources
• Take ownership of the ETL migration to dbt
• Optimise and tune SQL queries for best performance
• Monitor performance and troubleshoot problems in conjunction with the business
• Contribute and reinforce the best practice model for database design
• Work with stakeholders to understand their needs and design robust but dynamic models to fulfil their requirements
• Keep track of and recommend new software components in the broader datasphere that will help us to achieve our goals more effectively
• Participate in peer review processes across the data team
• Undertake periodic architectural reviews to ensure efficiency and benefit analysis

Skills/Qualifications:

• Proven experience as a SQL database developer, preferably in a cloud environment such as Redshift or Snowflake
• Proficient SQL programming and database management
• Experience with dbt is essential
• Strong understanding of relational databases and data modelling concepts
• Experience in performance tuning, including indexing and distribution keys
• Knowledge of database security practices
• Familiarity with the ELT approach to data
• Experience in Python would be beneficial
• Understanding of data quality principles, governance and BI toolsets
• Familiarity with version control systems such as GitHub

'Please take the time to read the job description, you must meet all the criteria set out above for your application to be considered. We do check all applications and suitable candidates will be contacted within 5 days. If you are not contacted by us within 5 working days, please consider your application unsuccessful at this time.'

#LI-DNI