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.
Your CV has been submitted successfully.
Complete form below to directly Send your CV / Linkedin Profile to Redshift Data Warehouse Developer at dmg events.
@
You will receive all responses from employer on this email
Example: Application for the post of 'Accountant'
Example: Introduce your self and give purpose of your application
*All fields are mandatory.
Loading...
DMG EVENTS 20 jobs found
Event Director - Energy at dmg events
Dubai, United Arab Emirates
Senior Sales Manager - Saudi Launches at dmg events
Dubai, United Arab Emirates
Head of Marketing at dmg events
London, United Kingdom
Operations Executive at dmg events
London, United Kingdom
Conference Producer at dmg events
London, United Kingdom
Data Analyst at dmg events
London, United Kingdom
Head of Content at dmg events
London, United Kingdom
Redshift Data Warehouse Developer at dmg events
London, United Kingdom
Conference Producer at dmg events
London, United Kingdom
Exhibition Coordinator - Constructions at dmg events
