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
• 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
• Exposure to dbt or similar ETL tools
• 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
dmg :: events is an equal opportunity employer, should you not hear back from us within 14 days, please consider your application as unsuccessful at this time.
