Senior Analytics Engineer (Snowflake/DBT) at Tide

ABOUT TIDE At Tide we help SMEs save time (and money) in the running of their businesses by not only offering business accounts and related banking services, but also a comprehensive set of highly usable and connected administrative solutions from invoicing to accounting. Tide is transforming the small business banking market with over 1.8 million members globally across the UK, India, Germany and France. Using advanced technology, all solutions are designed with SMEs in mind. With quick onboarding, low fees and innovative features, we thrive on making data-driven decisions to serve our mission: to help SMEs save both time (and money) so they can get back to doing what they love. Tide facts: • Tide is available for UK, Indian, German and French SMEs • Over 1.8 million members: 800,000 UK and 1,000,000 in India and growing rapidly • Over $300 million raised in funding • Over 2,500 Tideans globally - we’re diversity champions! • We have offices in Central London, with a member support and technology centre in Sofia, Bulgaria, technology centres in Serbia, Romania, Lithuania and Hyderabad and offices in Gurugram and New Delhi, and in Berlin, Paris and Luxembourg. ABOUT THE ROLE: As part of the team, you will be responsible for building and running the data pipelines and services that are required to support business functions/reports/dashboard.. We are heavily dependent on BigQuery/Snowflake, Airflow, Stitch/Fivetran, dbt , Tableau/Looker for our business intelligence and embrace AWS with some GCP. As a Senior Data Engineer you’ll be: • Developing end to end ETL/ELT Pipeline working with Data Analysts of business Function.\ • Designing, developing, and implementing scalable, automated processes for data extraction, processing, and analysis in a Data Mesh architecture • Mentoring Fother Junior Engineers in the Team • Be a “go-to” expert for data technologies and solutions • Ability to provide on the ground troubleshooting and diagnosis to architecture and design challenges • Troubleshooting and resolving technical issues as they arise • Looking for ways of improving both what and how data pipelines are delivered by the department • Translating business requirements into technical requirements, such as entities that need to be modelled, DBT models that need to be build, timings, tests and reports • Owning the delivery of data models and reports end to end • Perform exploratory data analysis in order to identify data quality issues early in the process and implement tests to ensure prevent them in the future • Working with Data Analysts to ensure that all data feeds are optimised and available at the required times. This can include Change Capture, Change Data Control and other “delta loading” approaches • Discovering, transforming, testing, deploying and documenting data sources • Applying, help defining, and championing data warehouse governance: data quality, testing, coding best practices, and peer review • Building Looker Dashboard for use cases if required WHAT WE ARE LOOKING FOR: • You have 4+ years of extensive development experience using snowflake or similar data warehouse technology • You have working experience with dbt and other technologies of the modern data stack, such as Snowflake, Apache Airflow, Fivetran, AWS, git ,Looker • You have experience in agile processes, such as SCRUM • You have extensive experience in writing advanced SQL statements and performance tuning them • You have experience in Data Ingestion techniques using custom or SAAS tool like fivetran • You have experience in data modelling and can optimise existing/new data models • You have experience in data mining, data warehouse solutions, and ETL, and using databases in a business environment with large-scale, complex datasets • You have experience architecting analytical databases (in Data Mesh architecture) is added advantage • You have experience working in agile cross-functional delivery team • You have high development standards, especially for code quality, code reviews, unit testing, continuous integration and deployment • You have strong technical documentation skills and the ability to be clear and precise with business users • You have business-level of English and good communication skills • You have basic understanding of various systems across the AWS platform ( Good to have ) • Preferably, you have worked in a digitally native company, ideally fintech • Experience with python, governance tool (e.g. Atlan, Alation, Collibra) or data quality tool (e.g. Great Expectations, Monte Carlo, Soda) will be added advantage Our Tech Stack: • DBT • Snowflake • Airflow • Fivetran • SQL • Looker WHAT YOU WILL GET IN RETURN • 25 days paid annual leave • 3 paid days off for volunteering or L&D activities • Family-Friendly Leave (according to statutory) • Personal L&D budget in the amount of 500 EUR per year • Work from home budget to set up your space • Mental wellbeing platform Plum • WFH equipment allowance • Share options TIDEAN WAYS OF WORKING At Tide, we champion a flexible workplace model that supports both in-person and remote work to cater to the specific needs of our different teams. While remote work is supported, we believe in the power of face-to-face interactions to foster team spirit and collaboration. Our offices are designed as hubs for innovation and team-building, where we encourage regular in-person gatherings to foster a strong sense of community. #LI-BK1 TIDE IS A PLACE FOR EVERYONE At Tide, we believe that we can only succeed if we let our differences enrich our culture. Our Tideans come from a variety of backgrounds and experience levels. We consider everyone irrespective of their ethnicity, religion, sexual orientation, gender identity, family or parental status, national origin, veteran, neurodiversity or differently-abled status. We celebrate diversity in our workforce as a cornerstone of our success. Our commitment to a broad spectrum of ideas and backgrounds is what enables us to build products that resonate with our members’ diverse needs and lives. We are One Team and foster a transparent and inclusive environment, where everyone’s voice is heard. At Tide, we thrive on diversity, embracing various backgrounds and experiences. We welcome all individuals regardless of ethnicity, religion, sexual orientation, gender identity, or disability. Our inclusive culture is key to our success, helping us build products that meet our members' diverse needs. We are One Team, committed to transparency and ensuring everyone’s voice is heard. Disclaimer It has come to our attention that individuals or agencies are falsely claiming to represent Tide and are reaching out to candidates regarding job opportunities. Please be aware that: • Tide does not charge any fees at any stage of the recruitment process. • All official Tide job opportunities are listed exclusively on our Careers Page and applications should be submitted through this channel. • Communication from Tide will only come from an official @tide.co email address. • Tide does not work with agencies or recruiters without prior formal engagement, and we do not authorize third parties to make job offers on our behalf. If you are contacted by anyone misrepresenting Tide or requesting payment, please treat it as fraudulent and report it to us immediately at [Upgrade to PRO to see contact] Your safety and trust are important to us, and we are committed to ensuring a fair and transparent recruitment process. Tide leverages AI to enhance our hiring experience. You can read more about how we use AI in our recruitment process in our AI Policy. Your personal data will be processed by Tide for recruitment purposes and in accordance with Tide's Recruitment Privacy Notice.