Staff Data Engineer (Snowflake/ETL)

Who is Tide: At Tide, we are dedicated to saving businesses time and money. We are the UK's leading provider of SME business accounts and one of the fastest-growing financial tech companies in the UK. Employing the latest technology, we design solutions with SMEs in mind, and our member-driven financial platform is transforming the business banking market. Not only do we offer business accounts and related banking services to our members, but we also provide a comprehensive selection of highly connected administrative tools for businesses. Tide is about doing what you love. We are in search of individuals who are interested in joining us on our exciting journey and becoming a part of something special. We need passionate Tideans to drive innovation and help build a top-tier platform for our members. You must be comfortable working in ambiguous situations and be able to navigate the constantly changing FinTech environment. Imagine helping shape how millions of Tide members discover and interact with business banking platforms, and doing this on a global scale. What we’re looking for: As part of the team, you will be responsible for building and managing the data pipelines and services needed to support business functions/reports/dashboards. We rely heavily on Snowflake, Airflow, Fivetran, dbt, and Looker for our business intelligence and see AWS as a crucial partner across our engineering teams. As an Analytics Engineer you'll be: - Designing and architecting complex Data Warehousing/Data Lake solutions on Snowflake - Designing, developing, and implementing scalable, automated processes for data extraction, processing, and analysis in a Data Mesh structure - Mentoring Junior Engineers on the team - Acting as a "go-to" expert for data technologies and solutions - Capable of troubleshooting and diagnosing architecture and design challenges - Responsibly troubleshooting and resolving technical issues as they arise - Seeking ways to improve both the quality and delivery of data pipelines from the department - Optimising and fine-tuning complex SQL queries on Snowflake, including a deep understanding of various data partition strategies - Collaborating with Data Analysts to ensure all data feeds are optimised and available when needed. This may include Change Capture, Change Data Control, and other "delta loading" methodologies - Supporting data governance, data improvement, and other data platform initiatives - Designing solutions for data integration, data management, metadata management, and data quality - Discovering, transforming, testing, deploying, and documenting data sources - Applying, defining, and promoting data warehouse governance, including data quality, testing, coding best practices, and peer review What makes you a great fit: You have 10-12 years of experience with increasing responsibilities implementing data solutions with a focus on snowflake or similar warehouses. You have an in-depth understanding of Data Warehouses, ETL concepts, and data modelling principles. You possess sound knowledge of Data modelling approaches like Kimball and Datavault etc., along with strong Data Warehousing and Data Modelling fundamentals such as Star Schema, Snowflake Schema, Dimension Tables, and Fact Tables. You have a thorough knowledge of Cloud-based data solution components and architecture covering data ingestion, data processing, data cataloguing, security, devops, consumption, etc. You have experience implementing core Snowflake concepts such as data sharing, UDFs, zero copy clones, time travel, micro partition, stored procedures, data import/export, external tables. You have experience designing analytical databases in Data Mesh architecture. You have the ability to solve problems and proactively engage with other cross-functional teams to resolve issues and blockers. You can consider alternative solutions/components and make design decisions backed by justification. You are able to drive technical discussions/demos/presentations with client stakeholders, demonstrating deep expertise and quality of designs. You can perform design/code reviews of the team to identify issues/risks and mitigations. You have experience with python, governance tools (e.g., Atlan, Alation, Collibra) or data quality tools (e.g., Great Expectations, Monte Carlo, Soda) which would be an added advantage. Strong analytical and problem-solving skills are essential as well. You have experience with Agile Development methodology and excellent communication skills. What you’ll get in return: Work flexibly in a way that suits you! We embrace novel ways of working and support flexible work arrangements. Our Working Out of Office (WOO) policy allows colleagues to work remotely from home or anywhere in their home country. Moreover, you can work from a different country for up to 90 days a year. In addition to this, you'll receive: - Competitive salary - Self & Family Health Insurance - Term & Life Insurance - OPD Benefits - Mental wellbeing support through Plumm - Learning & Development Budget - WFH Setup allowance - 25 Annual leaves - Family & Friendly Leaves Tidean Ways of Working At Tide, we place our members first and drive our efforts with data. Above all, we are One Team. Our Working Out of Office (WOO) policy allows you to work from anywhere in the world for up to 90 days per year. We are primarily remote-oriented, but we have offices available and equipped to the highest standard for times when you want to meet new people, collaborate with your team, or simply want to spend time with your colleagues. Tide is a place for everyone At Tide, we believe that our success lies in embracing our differences to enrich our culture. Our Tideans come from a variety of backgrounds and experience levels. We welcome everyone regardless of their ethnicity, religion, sexual orientation, gender identity, family or parental status, national origin, veteran, neurodiversity status or disability status. We believe these are the factors that make us exceptional at problem-solving! We are One Team and foster a transparent and inclusive environment, where everyone's voice is heard.