Overviewresponsibility 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

Responsibilities

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

We\''re 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 and InclusionCapital 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 and spend management platform that helps business owners save time and money. Capital on Tap proudly serves over 200,000 businesses across the world and our goal is to help 1 million small businesses by 2030.

Why Join Us?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 PerksWe 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 (£250, £500, £750, 4-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

Interview ProcessFirst 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 InfoCheck out ourKeep updated on new job opportunities by following us on .Email if you have any questions.Excited to work here? Apply!If you\''d 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.)

#J-18808-Ljbffr