Lead Data Engineer (Snowflake/ETL)

Who are Tide: At Tide, we are dedicated to saving businesses time and money. We are the top provider of UK SME business accounts and one of the fastest-growing FinTechs in the UK. Employing the latest technology, we design solutions with SMEs in mind, transforming the business banking market with our member-driven financial platform. We provide not only business accounts and related banking services but also a comprehensive suite of highly interconnected administrative tools for businesses. Tide is about pursuing your passion. We are in search of individuals to join us on our dynamic expansion journey and be an integral part of something extraordinary. We want committed Tideans to drive innovation and help to develop a top-tier platform to serve our members. You should be able to comfortably navigate ambiguous situations and understand the evolving FinTech landscape. Envision molding how millions of Tide members interact with business banking platforms on a global scale. What we're looking for: In this team, you will be tasked with establishing and managing the data pipelines and services necessary to support business functions/reports/dashboards. We rely heavily on Snowflake, Airflow, Fivetran, dbt, and Looker for our business intelligence, and we partner closely with AWS across our engineering teams. As an Analytics Engineer, you'll be responsible for: - Developing ETL/ELT Pipelines in collaboration with Data Analysts from various business functions. - Designing, developing, and deploying scalable, automated processes for data extraction, processing, and analysis within a Data Mesh architecture. - Mentoring junior engineers on the team. - Acting as an expert in data technologies and solutions. - Providing immediate troubleshooting and diagnosis for architectural and design challenges. - Resolving technical issues as they occur. - Exploring ways to improve both the what and how of data pipeline delivery by the department. - Translating business requirements into technical requirements, such as entities requiring modeling, DBT models needing to be built, timings, tests, and report delivery. - Conducting exploratory data analysis to identify data quality issues early in the process and implement tests to prevent them in the future. - Working with Data Analysts to optimize and ensure the availability of all data feeds at required times. This might involve Change Capture, Change Data Control, and other "delta loading" approaches. - Discovering, transforming, testing, deploying, and documenting data sources. - Upholding, defining, and advocating data warehouse governance: data quality, testing, best coding practices, and peer review. - Building Looker Dashboard for use cases when necessary. What makes you a great fit: - You have over seven years of extensive development experience using Snowflake or a similar data warehouse technology. - You have practical experience with dbt and other technologies of the modern data stack, such as Snowflake, Apache Airflow, Fivetran, AWS, git, Looker. - You are familiar with agile processes such as SCRUM. - You have extensive experience writing advanced SQL statements and tuning them for performance. - You have experience in data ingestion using custom or SAAS tools like Fivetran. - You understand data modeling and can optimize existing/new data models. - You have experience in data mining, data warehouse solutions, ETL, and using databases in a business setting with extensive, complex datasets. - Experience in designing analytical databases (in a Data Mesh architecture) is a plus. - You have experience working in an agile cross-functional delivery team. - You uphold high development standards, especially for code quality, code reviews, unit testing, continuous integration, and deployment. What you'll get in return: We are open to new ways of working and support flexible working arrangements. Through our "Working Out of Office" (WOO) policy, our colleagues can work remotely from anywhere within their assigned Indian state. Furthermore, you can work from another country or Indian state for 90 days in a year. In addition to this flexibility, you’ll get: - Competitive salary. - Health Insurance for you and your family. - Term and Life Insurance. - OPD Benefits. - Plumm for your mental wellbeing. - Learning and Development Budget. - WFH Setup allowance. - 15 days of privilege leaves. - 12 days of casual leaves. - 12 days of sick leaves. - 3 paid days off for volunteering or L&D activities. Tidean Ways of Working: At Tide, we prioritize our members and place high importance on data, but above all, we are one team. Our WOO policy allows you to work from anywhere in the world for up to 90 days a year. We embrace remote working, but our offices are always available and equipped to the highest standard for any collaborative work or socializing with colleagues. We trust our employees to complete their work well and efficiently, respecting the timelines that suit them and their team. Tide is a place for everyone: At Tide, we believe in success through diversity. We welcome Tideans from all backgrounds and experience levels. We value everyone regardless of their ethnicity, religion, sexual orientation, gender identity, family or parental status, national origin, veteran status, neurodiversity, or disability. We believe that these differences enrich our culture and make us more efficient at problem-solving. We are one team and promote a transparent and inclusive environment where everyone's voice matters.