Senior Data Engineer (Snowflake/ETL)

Who is Tide: At Tide, we're on a mission to save businesses time and money. We're the leading provider of UK SME business accounts and amongst the fastest-growing FinTechs in the UK. We use the latest technology to design solutions that cater to SMEs. Our member-driven financial platform is revolutionizing the business banking market. Not only do we offer business accounts and related banking services, but also a comprehensive range of highly connected admin tools for businesses. Tide is about doing what you love. We're looking for someone to join us on our exciting upscaling journey and be part of something special. We need passionate Tideans to drive innovation and help create a top-tier platform to support our members. You should be comfortable in ambiguous situations and capable of navigating the evolving FinTech environment. Imagine shaping how millions of Tide members interact with business banking platforms on a global scale. What we're looking for: As part of our team, you will be responsible for building and running the data pipelines and services to support business functions/reports/dashboard. We depend heavily on Snowflake, Airflow, Fivetran, dbt, and Looker for our business intelligence and utilize AWS across our engineering teams. As an Analytics Engineer, you'll be: - Developing end-to-end ETL/ELT Pipeline in collaboration with Data Analysts of business Function. - Designing, developing, and implementing scalable, automated data extraction, processing, and analysis processes in a Data Mesh architecture. - Mentoring other Junior Engineers in the team. - Being a “go-to” expert for data technologies and solutions. - Troubleshooting and resolving technical issues as they arise. - Looking for ways to improve data pipelines, both in terms of what we deliver and how we deliver it. - Translating business requirements into technical requirements. - Owning the delivery of data models and reports end-to-end. - Performing exploratory data analysis to identify data quality issues early in the process and implementing tests to prevent them in the future. - Collaborating with Data Analysts to optimise data feeds and ensure they are available when needed. - Discovering, transforming, testing, deploying, and documenting data sources. - Applying, defining, and championing data warehouse governance. - Building Looker Dashboard for use cases as required. What makes you a great fit: - A minimum of 5 years of extensive development experience with snowflake or similar data warehouse technology. - Practical experience with dbt and other technologies of the modern data stack, such as Snowflake, Apache Airflow, Fivetran, AWS, git, Looker. - Experience with agile processes. - Advanced SQL statement writing and tuning skills. - Experience with data ingestion techniques using custom or SAAS tools like Fivetran. - Experience in data modelling and ability to optimize existing/new data models. - Experience with data mining, data warehouse solutions, ETL, and using databases in a business environment with large-scale, complex datasets. - Experience architecting analytical databases (in Data Mesh architecture) is an added advantage. What you'll get in return: Tide recognizes the importance of work-life balance and supports flexible working arrangements. With our Working Out of Office (WOO) policy, you can work remotely from home or anywhere within your assigned Indian state. You can also work from a different country or Indian state for 90 days a year. Furthermore, you get: - Competitive salary - Health Insurance for you and your family - Term & Life Insurance - OPD Benefits - Mental wellbeing support through Plumm - A Learning & Development Budget - Work From Home Setup Allowance - 15 days of Privilege leaves - 12 days of Casual leaves - 12 days of Sick leaves - 3 paid days off for volunteering or Learning & Development activities Tidean Ways of Working: At Tide, we prioritize our members, data-driven decisions, and teamwork. You can work from anywhere in the world for up to 90 days a year. While our approach is remote-first, our offices are always open and fully equipped for when you wish to meet, collaborate, or socialize. We trust our employees to complete their work effectively at convenient times for them and their teams. Tide is a place for everyone: Tide understands the value of a diverse workforce. We believe that our differences enrich our culture. Tideans come from a variety of backgrounds and experience levels. We consider everyone, regardless of ethnicity, religion, sexual orientation, gender identity, family or parental status, national origin, veteran, neurodiversity status, or disability status. We believe this is the secret to our problem-solving prowess. At Tide, we foster transparency and inclusivity, ensuring everyone's voice is heard.