Analytics Engineer

Key Skills

Java Programming, Python Programming, C++, C Programming, SQL, Cloud computing, Scala Programming, Machine learning techniques, Data science techniques, MATLAB Programming, PyTorch, TensorFlow, R Programming

Job Description

At Capital on Tap, we believe in small businesses and their potential. That's why we are on a mission to build tools for small businesses to help them thrive.

We have helped more than 125,000 small businesses across the UK and the US, and hope to partner with more than 1 million businesses by the end of 2025. We have been named by the Financial Times as one of the Fastest Growing Companies in Europe for 5 years in a row and we have a global team of 350 across London, Cardiff and Atlanta.

Our people (and our office dogs) really are the best thing about working at Capital on Tap. We have built a dynamic, fun and vibrant culture. Your opportunities for growth are as big as your ambitions and we champion you to pilot your own ideas to have an impact and add value to the business!

We are a place where a diverse mix of talented people want to come and do their best work and most importantly feel included and welcome. We foster an environment that allows people to share, engage, learn, support, participate and work towards positive change. We hold regular culture and inclusion events, such as Black History Month, Pride Week and International Women’s Day and have genuine goals to improve every day. You can read more about these events on our blog, and more about our team and our values here.

The Role

Located in the newly formed Analytics Engineering team, Analytics Engineers play a central role in how data moves around the business. They are responsible for expanding, maintaining and optimising our modern data architecture and managing our 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, Fivetran and Hightouch. 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 optimal data pipeline architectures, mainly through well organised and tested dbt models
• Assemble large, complex data sets that meet business requirements
• Identify, design, and implement internal process improvements: automating manual processes, optimising data delivery etc.
• Work with stakeholders including the Executive, Product, Data and Development 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
• Document the company’s data environment, constructing physical and logical diagrams (including data dictionaries)

What do we require?

• Expert SQL skills required
• Experience modelling data (e.g. dimensional modelling)
• Experience with ELT tools and components required (we currently use Fivetran)
• Experience with Analytics Workflow Tool is required (dbt is highly preferred)
• Experience working with a Cloud Data Warehouse (we work with Snowflake)
• Familiarity developing/building within a BI tool - Looker is preferable. (Mode, Tableau etc. is acceptable)
• Familiarity with Python is a bonus
• Strong analytical skills - analysts will be your customer!

What you'll get in return

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.

• Competitive base salary 
• 28 days holiday (plus bank holidays)
• Generous yearly anniversary rewards (including 4 weeks paid sabbatical in year 4)
• We give every employee a learning budget of £1,000 a year to spend on your own personal development (we want to encourage your growth!)
• We contribute 4% to your pension (with up to 7% match) through our pension plan
• Private healthcare through Vitality
• Worldwide Travel Insurance through Vitality
• Six free therapy sessions
• Opportunities for internal career progression
• Free breakfast and snacks every day
• An opportunity to pilot new ideas that impact the growth and direction of the business
• The chance to work for one of the fastest-growing FinTech companies in the UK
• Travelcard loan and/or cycle to work scheme