Redshift Data Warehouse Developer

at  DMG Events

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.

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

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