Data Engineer

Overview

· You have 5+ years of extensive development experience using snowflake or

similar data warehouse technology

· You have working experience with dbt and other technologies of the modern

datastack, such as Snowflake, Apache Airflow, Fivetran, Looker, AWS, git.

· 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 having 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

As a Analytics Engineer youll 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 other 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 practises, and peer review

· Building Looker Dashboard for use cases if required

Job Type: Full-time

Pay: ?1,800,000.00 - ?2,040,000.00 per year

Work Location: Remote