Senior Snowflake Data Engineer

<p><strong>About us </strong></p><p>At Davy, it’s the unique talents of all our people that have been the foundations of our success for almost 100 years. As we continue to grow, so do you. Because you are not just part of our team – you are a key player in shaping our future.  </p><p>At Davy, you are the difference.   </p><p>Established in 1926, the Davy Group sits at the heart of wealth and capital in Ireland, providing a broad range of services to high-net-worth individuals, self-directed investors, small-to-medium enterprises, credit unions, corporations, and domestic &amp; international institutional investors.  </p><p>Our culture is shaped around three values, which are at the heart of everything we do: client success, one Davy, and building a proud legacy. Sharing the same goals, we work together to deliver exceptional outcomes for our clients. As part of a team of over 900, you will be encouraged to learn and to grow, both professionally and personally.  </p><p><strong>About the role</strong></p><p>We’re seeking a Senior Snowflake Data Engineer with deep expertise in Snowflake developments to lead the development of Davy’s cross business data domain. You’ll partner closely with business subject matter experts, analytics teams and other engineers to shape a scalable, robust data foundation, enabling both internal reporting and customer-facing insights</p><p><strong>Key Responsibilities</strong></p><ul><li>Drive the end-to-end development lifecycle, leading efforts to design and maintain data models that power Davy’s internal and customer-facing analytics. You’ll ensure that our Snowflake environment is enabled to scale for growing data volumes and complex reporting needs.</li><li>Guide engineer and analyst teams on Snowflake best practices and cost-efficient solutions, sharing your deep expertise to elevate the entire Product Development lifecycle. Encourage a culture of design and development excellence throughout.</li><li>Work closely with Project Leads, Product Managers to translate business requirements into robust Snowflake solutions.</li><li>You’ll identify and develop processes for monitoring, alerting, and troubleshooting issues.</li><li>Continuously evaluate and adopt new Snowflake capabilities, refining the stack to keep Davy at the forefront of cloud data innovation. You’ll push for automated testing, improved Azure DevOps pipeline deployment, and other forward-thinking approaches to maintain a future-proof data foundation.</li></ul><p><strong>Requirements</strong></p><p><strong>About you  </strong></p><p>We are looking for somebody who has the following background and skills: </p><ul><li>Bachelor’s degree in Computer Science/Information Systems or related field.</li><li>5+ years of experience in data engineering or database architecture, with a proven track record of designing and optimizing Snowflake environments at an enterprise scale</li><li>Expert-level proficiency in Snowflake features and components, such as clustering, micro-partitioning, Streams &amp; Tasks, and performance tuning best practices</li><li>Strong foundation in dimensional data modelling, including Kimball with the ability to develop robust, scalable schemas for complex analytical use cases</li><li>Strong proficiency in Python, SQL, and other data engineering technologies such as DBT. Hands-on experience with cloud platforms (Azure strongly preferred)</li><li>Ability to work cross-functionally with data teams, data analysts, data engineers, and business leaders. Strong communicator, able to explain technical concepts to non-technical stakeholders.</li><li>Familiarity with data governance principles and best practices, including data quality, data lineage, and security standards.</li><li>Excellent communication and collaboration skills.</li></ul><p><strong>Preferred Qualifications:</strong></p><ul><li>Master’s degree in Computer Science/Information Systems or related field</li><li>SnowPro Advanced certification</li></ul><p><strong>Our Data Stack:</strong></p><ul><li>ELT (Snowflake, Kerbi)</li><li>Infrastructure (Azure)</li><li>BI (PowerBI), SNOWFLAKE Dashboards</li></ul><p><strong>Development Environment :</strong></p><ul><li>Azure DevOpS</li></ul><p><strong>What we offer </strong></p><p>At Davy, our people are our biggest investment. In today’s fast-moving world, we know it’s important to feel secure and empowered. That’s why Davy benefits support you through all of life’s stages, offering health and wellness, flexible working options, flexible benefits allowance, learning and development opportunities, through to assisted retirement planning.   </p><p><strong>Health and Wellbeing  </strong></p><p>Psychological safety, emotional wellbeing and support are a priority at Davy. We offer a comprehensive Employee Assistance Programme (EAP) and mental health first aid. Our Sports &amp; Social teams promote physical wellbeing and social connection.  </p><p><strong>Reward and Recognition  </strong></p><p>We offer a competitive