Analytics Engineer at Capital on Tap

London, England, United Kingdom -

Full Time

Start Date

Immediate

Expiry Date

09 Apr, 26

Salary

0.0

Posted On

09 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Modelling, dbt, Git, ELT Tools, Cloud Data Warehouse, Snowflake, BI Tools, Analytical Skills, Python, Azure, Data Pipelines, Data Mart, Data Infrastructure, Data Delivery, Stakeholder Management

Industry

Financial Services

Description

We’re 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 200,000 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, 1-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. 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. Responsibilities 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 What do we require? Expert SQL skills 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, PowerBI) 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 (£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 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 careers@capitalontap.com 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.)

Responsibilities

Analytics Engineers are responsible for building, maintaining, and optimizing the data platform, ensuring seamless access to high-quality data. They will support end users across various platforms and assist with data-related issues.