Analytics Engineer

🏡🏢This is a Hybrid role, this team works from our London (Shoreditch) Offices 1 day per week.

What You’ll Be Doing

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.

• 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 pipeline architectures, mainly 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, Credit, 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, Mode, 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 (£250, £500, £750, 4-week fully paid sabbatical)
👛 Salary Sacrifice Pension Scheme up to 7% match
🏖️ 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.