> job detail
C
📐Analytics Engineer
Analytics Engineer
Capital on Tap · London
// classified as
Analytics Engineer (dbt, semantic layer, transformation.)
posted
40d ago
location
London
languages
python, sql
tools
azure, dbt, fivetran
> stack
pythonsqlazuredbtfivetranlookersnowflakedbt
> description
<div class="content-intro"><p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong>We’re Capital on Tap 👋<br></strong></span><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">💳 Capital on Tap started because small businesses were underserved. Big banks were slow, their products weren't fit for purpose, and small business owners often couldn't access what they needed. We set out to fix that.</span></p>
<p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Today we're a financial platform - not just a credit card company. We offer a best-in-class business credit card, SME-focused spend management platform, a savings product that hit £1 billion in funds within its first year, and a growing suite of tools and financial products that make running a small business easier. </span></p>
<p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">1,000+ employees, £20bn in annual card spend, 200,000+ customers, 17,000+ Trustpilot reviews averaging 4.7 stars, and we're profitable. We’ve done a pretty good job so far, but we’re just getting started! </span></p></div><p> </p>
<p data-path-to-node="2"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">📍 London | 🏢 Hybrid (1-2 days per week in office)</span></p>
<p data-path-to-node="3"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="3" data-index-in-node="0">Data Platform Team 🚀</strong> Located in our growing Data Platform team, Analytics Engineers play a central role in how data moves around the business. You will be responsible for building, maintaining, and optimising our modern data platform from design through to end product, ensuring seamless access to high-quality, documented data.</span></p>
<p data-path-to-node="4"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="4" data-index-in-node="0">What You’ll Be Doing 🗃️</strong></span></p>
<ul data-path-to-node="5">
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="5,0,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Own the global data stack including Fivetran, Snowflake, dbt, and Looker.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="5,1,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Create and maintain well-designed data marts through organised and tested dbt models.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="5,2,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Build out and own custom data pipelines using Python and the Azure platform.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="5,3,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Assemble large, complex data sets that meet specific business requirements.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="5,4,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Implement internal process improvements like Github CI/CD and automation.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="5,5,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Partner with stakeholders across Executive, Risk, Commercial, and Engineering teams.</span></p>
</li>
</ul>
<p data-path-to-node="6"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="6" data-index-in-node="0">Our Values & Culture 🌞</strong></span></p>
<ul data-path-to-node="7">
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="7,0,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="7,0,0" data-index-in-node="0">Just Pilot:</strong> We never settle for “good enough”. We pilot new ideas fast, ask questions to figure it out, and scale quickly.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="7,1,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="7,1,0" data-index-in-node="0">Why Not Today?</strong> Fast is as slow as we go - speed and simplicity gives us a competitive advantage.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="7,2,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="7,2,0" data-index-in-node="0">Be a Buddy:</strong> We tap in from day one to help the team, we do the right thing even if it’s hard.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="7,3,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="7,3,0" data-index-in-node="0">Owners and Dates:</strong> We don’t chase people. If you own a task and agree to a date, the expectation is that it gets done.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="7,4,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="7,4,0" data-index-in-node="0">Feedback:</strong> We want our employees to flourish, so we regularly provide direct and constructive feedback.</span></p>
</li>
</ul>
<p data-path-to-node="8"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="8" data-index-in-node="0">We’re Looking For 🔎</strong></span></p>
<ul data-path-to-node="9">
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="9,0,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Expert SQL skills and knowledge of data modelling (e.g., Kimball).</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="9,1,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Hands-on experience with dbt and Git for building SQL-based pipelines.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="9,2,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Experience with ELT tools (Fivetran) and cloud data warehouses (Snowflake).</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="9,3,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Familiarity developing within BI tools like Looker, Omni, Tableau, or PowerBI.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="9,4,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Strong analytical skills with a customer-centric approach toward Data Analysts.</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="9,5,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Excellent interpersonal skills to translate technical concepts for stakeholders.</span></p>
</li>
</ul>
<p data-path-to-node="10"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="10" data-index-in-node="0">Diversity & Inclusion 🌈</strong> 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.</span></p>
<p data-path-to-node="11"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="11" data-index-in-node="0">Great Work Deserves Great Perks</strong> 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</span></p>
<p data-path-to-node="12"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="12" data-index-in-node="0">Check out more of our benefits, values and mission here:</strong> <a class="ng-star-inserted" href="https://capitalontap.enterprise.slack.com/docs/T045920RU/F075KUERCF9" target="_blank">https://capitalontap.enterprise.slack.com/docs/T045920RU/F075KUERCF9</a> <a class="ng-star-inserted" href="https://www.notion.so/capitalontap/Values-Benefits-Guide-Technology-104ea9fc06d180a0902ae1f7dbd2d180" target="_blank">https://www.notion.so/capitalontap/Values-Benefits-Guide-Technology-104ea9fc06d180a0902ae1f7dbd2d180</a></span></p>
<p data-path-to-node="13"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="13" data-index-in-node="0">Interview Process 🤝</strong></span></p>
<ol data-path-to-node="14">
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="14,0,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="14,0,0" data-index-in-node="0">First stage:</strong> 30 minute intro and values call with Talent Partner (Video call).</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="14,1,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="14,1,0" data-index-in-node="0">Second stage:</strong> 45 minute CV overview with Hiring Manager (Video call).</span></p>
</li>
<li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">
<p data-path-to-node="14,2,0"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="14,2,0" data-index-in-node="0">Final stage:</strong> Technical assessment with Team Leads and a “Meet the Team” session — 60 minutes each (Video call).</span></p>
</li>
</ol>
<p data-path-to-node="15"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="15" data-index-in-node="0">Other Useful Info 👍</strong> 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.</span></p>
<p data-path-to-node="16"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong data-path-to-node="16" data-index-in-node="0">Excited to work here? Apply!</strong> 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.</span></p>
<p> </p><div class="content-conclusion"><p><strong><span style="font-size: 12pt; font-family: verdana, geneva, sans-serif;">Other Info<br></span></strong><span style="font-size: 12pt; font-family: verdana, geneva, sans-serif;">👍Check out our <a href="https://www.capitalontap.com/en/blog/posts/acing-your-interviews-with-capital-on-tap/">‘Top Tips’ for interviewing.</a><br></span><span style="font-size: 12pt; font-family: verdana, geneva, sans-serif;">✔️Keep updated on new job opportunities by following us on <a href="https://www.linkedin.com/company/capital-on-tap">Linkedin</a>.<br></span><span style="font-size: 12pt; font-family: verdana, geneva, sans-serif;">📧Email <a href="mailto:careers@capitalontap.com">careers@capitalontap.com</a> if you have any questions.</span></p>
<p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong>Excited to work here? Apply!<br></strong></span><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">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.)</span></p></div>