Senior Data Analytics Engineer

Summary

Join Tide's growing team as a Data Analytics Engineer and build data pipelines and services supporting marketing, business functions, reporting, and decision-making. You will develop end-to-end ETL/ELT pipelines, design scalable data processes, translate business requirements into technical specifications, and troubleshoot architecture and design challenges. Responsibilities include optimizing data feeds, discovering and transforming data sources, applying data warehouse governance, and building Looker dashboards. Tide offers a flexible workplace model supporting both in-person and remote work.

Requirements

• You have 6+ 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 in 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

Responsibilities

• 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
• Translating business requirements into technical requirements, such as entities that need to be modelled, DBT models that need to be built, timings, tests and reports
• Ability to provide on the ground troubleshooting and diagnosis to architecture and design challenges and resolving technical issues as they arise
• Looking for ways of improving both what and how data pipelines are delivered by the department
• 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

Preferred Qualifications

• 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
• Experience with marketing attribution and Media Mix Modelling is an advantage
• Experience working with regulated industries is a significant advantage

Benefits

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