Analytics Engineer

Capital on Tap; Greater London; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A fintech company is seeking an Analytics Engineer to join their Data Platform team in London. You will be responsible for building and maintaining a state-of-the-art data platform, ensuring seamless access to high-quality data for various business teams. The ideal candidate will have expert SQL skills, familiarity with Python, and experience with cloud data warehouses such as Snowflake. This is a hybrid position requiring attendance in the London office two days a week.

Benefits

Private Healthcare

Worldwide travel insurance

28 days holiday

Annual Learning and Wellbeing Budget

Dog Friendly Offices

Learning and Wellbeing Budget

Enhanced Parental Leave

Cycle to Work Scheme

Season Ticket Loan

Free therapy sessions

Dog Friendly Offices

Free drinks and snacks

Qualifications

• Expert SQL skills required for building and optimizing data pipelines.
• Familiarity with Python would be a bonus.
• Experience with data modeling and cloud data warehouses like Snowflake is essential.
• Experience working with a cloud data warehouse.
• Strong analytical skills to support data needs of multiple teams.

Responsibilities

• Support end users of our data platforms including Snowflake and dbt.
• Own the data flow through our Cloud Data Warehouse.
• Build out and maintain custom data pipelines using Python.
• Create and maintain well-designed data marts.
• Work with stakeholders for data-related issues.

Skills

Expert SQL skills

Familiarity with Python

Strong analytical skills

dbt

ELT Tools

Cloud Data Warehouse

BI Tools

Analytical Skills

Tools

Snowflake

dbt

Looker

Git

Fivetran

Job description

Overview

Were Capital on Tap

Capital on Tap was founded with the mission to help small business owners and make their lives easier. Today we provide an all-in-one business credit card & spend management platform that helps business owners save time and money. Capital on Tap proudly serves over 200000 businesses across the world and our goal is to help 1 million small businesses by 2030.

Why Join Us

We empower you to be innovative and solve complex problems. Take ownership make an impact and thrive in our scaling and agile environment.

This is a Hybrid role 2 days per week in our London office

Analytics Engineer at Capital on Tap

Located in our growing Data Platform team Analytics Engineers play a central role in how data moves around the business. They are responsible for building maintaining and optimising our modern data platform from design through to end product. You will be focused on giving seamless access to high quality tested and documented data throughout the organisation.

What Youll Be Doing

• As an Analytics Engineer you will support end users of our data in all our platforms including Snowflake dbt Looker and Azure Devops. Our Data Analysts and Data Scientists will receive optimal data delivery architecture consistently throughout ongoing projects. You are self-directed and comfortable supporting the data needs of multiple teams systems and products.
• With responsibility for all business side data infrastructure and delivery this is a hands-on position requiring solid technical skills as well as excellent interpersonal and communication skills.
• We work with Fivetran Snowflake dbt and Looker - you will be owning the data stack for our global business
• Own the flow of data through our Cloud Data Warehouse and component parts
• Create and maintain well designed data marts through organised and well tested dbt models
• Build out and own custom data pipelines using Python and the Azure platform
• Assemble large complex data sets that meet business requirements
• Identify design and implement internal process improvements : Github CI / CD automating manual processes optimising data delivery etc.
• Work with stakeholders across the business including the Executive Risk Commercial Fincrime Finance and Engineering teams to assist with data-related issues
• Keep our data efficient and consistent at a global level maintaining our warehouse environments over multiple regions
• Create and manage tools for our team of analysts and data scientists that assist them in building and optimising our product

Were Looking For

• Expert SQL skills
• Familiarity with Python a bonus
• Knowledge of data modelling approaches (e.g. Kimball dimensional modelling)
• Experience with dbt (or similar) and Git for building SQL based pipelines
• Experience with ELT tools and components required (we currently use Fivetran)
• Experience working with a cloud data warehouse (we work with Snowflake)
• Familiarity developing / building within a BI tool (e.g. Looker Omni Tableau)
• Strong analytical skills - analysts will be your customer!

Diversity & Inclusion

We welcome consider and encourage applications from anyone who shares our commitment to inclusivity. Join us in creating a space where authenticity thrives and everyone can do their best work.

Great Work Deserves Great Perks

We try not to take ourselves too seriously (all the time) so we make sure our office is decked out with a pool table arcade machine beer tap and a couple of office dogs thrown in for good measure. Check out our benefits :

• Private Healthcare including dental and opticians services through Vitality
• Worldwide travel insurance through Vitality
• Anniversary Rewards (-week fully paid sabbatical)
• Salary Sacrifice Pension Scheme up to 7% match
• Octopus EV Salary Sacrifice Scheme
• 28 days holiday (plus bank holidays)
• Annual Learning and Wellbeing Budget
• Enhanced Parental Leave
• Cycle to Work Scheme
• Season Ticket Loan
• 6 free therapy sessions per year
• Dog Friendly Offices
• Free drinks and snacks in our offices

Check out more of our benefits values and mission here.

Interview Process

• First stage: 30 minute intro and values call with Talent Partner (Video call)
• Second stage: 45 minute CV overview with Team Manager (Video call)
• Final stage: 60 minute technical assessment with Head of Department (In person)

Other Info

Check out our Top Tips for interviewing.

Keep updated on new job opportunities by following us on Linkedin.

Email if you have any questions.

Excited to work here Apply!

If youd like to progress your career within our fast growing profitable fintech then click apply and we will aim to get back to you within 3 working days (during busy periods this could take up to 5 working days.)

Key Skills

Adobe Analytics,Data Analytics,SQL,Attribution Modeling,Power BI,R,Regression Analysis,Data Visualization,Tableau,Data Mining,SAS,Analytics

Employment Type

Full Time

Experience

years

Vacancy

1