Lead Snowflake Engineer

Qualifications, knowledge and skills:

 

Qualifications:

Relevant professional qualifications in Data Engineering or related specialism

Knowledge:

• Highly proficient across the domains of data engineering, including ELT/ETL, metadata management, data integration, data management in transit and at rest & data streaming.
• Uses Kimball modelling techniques to design databases & data warehousing solutions that conform to the standards adopted by DataOps & shows other how to do this.
• Fully competent in the cloud data warehousing paradigms specific to our platform, with a good awareness of alternatives.
• Uses modern project delivery methodologies to plan, lead & deliver solutions (Agile, Waterfall etc) & manages team resource in partnership with the Product Owners.
• Expert in one of SQL or python and proficient in the other.
• Has expert & detailed working knowledge of the tools & platforms used by the Engineering Team. dbt Cloud, Snowflake, Azure

Experience:

• Demonstrates logical and lateral thinking considering all angles in their decision making. Supports others to do this.
• Uses technology to solve business problems & has a proven track record of delivering data engineering solutions alone and as part of a team.
• Uses Kimball dimensional data warehouse techniques to design & build data solutions & demonstrates to others how to do this.
• Identifies opportunities for innovation and continuous improvement in existing services by understanding current market offerings in the data engineering space.
• 4+ years of coal-face data engineering experience using the tools adopted by DataOps; Snowflake, Azure Synapse/Data Factory, dbt Cloud, Azure DevOps.
• 10+ years using SQL

Leadership:

• Ability to communicate to all levels of stakeholders to demonstrate  complex data engineering issues to non-technical stakeholders & technical colleagues alike.
• Creates an inspiring vision and clear direction that nurtures an open and honest & collaborative team ethos.
• Recognises and appreciates the efforts of others.
• A mentor for engineers, demonstrating the facilitation of team activities, supporting technical issues, offering support, development guidance and coaching to less experienced engineers and conducting regular touch-points with your team