Data Analytical Engineer

Yapily; London; Hybrid; GBP 50,000 - 90,000; Full time

Job summary

An innovative company is seeking a Data Analytical Engineer to transform data into actionable insights. This role combines data engineering and analysis, ensuring data accessibility through Looker while maintaining business logic for metrics. The ideal candidate will have over 10 years of experience, adept in DBT, BigQuery, and SQL, and will play a pivotal role in supporting finance and commercial teams. Join a dynamic team that values work-life balance with hybrid working options and generous time off, while contributing to the future of financial services through open banking.

Benefits

Competitive Pay & Equity

Generous Time Off

Hybrid Working

Nomad Working

Family First

Private Medical Insurance

Mental Health Support

Future-Ready Perks

Learn & Grow Budget

Cycle to Work Scheme

Team Vibes

Office Snacks & Doggies

Qualifications

• 10+ years of experience in data roles, proficient in DBT, Looker, and SQL.
• Strong communication and presentation skills are essential.

Responsibilities

• Mapping data to billable events and KPIs, ensuring accurate billing.
• Managing dashboards and business logic for key performance indicators.

Skills

DBT

Looker

BigQuery

SQL

Python

Data Analysis

Data Engineering

Communication Skills

Tools

Looker (BI Tool)

DBT

BigQuery

Job description

Who are Yapily

Yapily is on a mission to enable innovative companies to create better and fairer financial services for everyone, through the power of open banking.

Yapily is an open banking infrastructure platform solving a fundamental problem in financial services today: access. Historically, card networks have monopolised the global movement of money, and banks have monopolised the ownership of, and access to, financial data.

Yapily was founded to challenge these structures and create a global open economy that works for everyone. We exist behind the scenes, securely connecting companies - from growth to enterprise - to thousands of banks worldwide, enabling them to access data and initiate payments through the power of open banking.

What we’re looking for:

We are currently looking for a Data Analytical Engineer to join our team. The role plays a crucial part in the management and transformation of data to support decision-making processes within our organisation. The job entails an intersection between data engineering and data analysis, ensuring that data is accessible through Looker (BI Tool), and maintaining and adding to the business logic for our current metrics using DBT. Additionally, the candidate will play a pivotal role in the commercial team and Finance team, by helping price new products and reviewing contracts and ensuring that clients are invoiced correctly.

We are looking for someone who ideally has experience of working in a Data Team and is proficient with DBT, Bigquery and Looker.

Key Responsibilities:

• Building new processes to map Data to billable events and KPIs, working with Data engineers to ensure this.
• Data Mapping, managing the definition and Business logic for KPIs for the company, across Product team, Operations team, Commercial and Customer Success teams, using DBT and Look-ML.
• Will be in charge of dashboarding and will be the owner of Looker, the company’s BI tool.
• Billing infrastructure & System, ensuring all clients are billed correctly according to contracts and in charge of invoicing and revenue stats.
• Working with finance to help calculate commissions & NDR.
• Working with legal to map contracts onto the current billing system, this may include introducing innovative ways to ensure we can bill clients for new products.
• Helping Operations to forecast revenue and cost.
• Compliance, working closely with compliance to report Data to Regulatory bodies.
• Dashboarding, in charge of dashboards to key stakeholders, such as management and finance.
• Responsible for all the data across various systems to be accurate, includes pushing data to different systems.

The ideal candidate has:

• A minimum of 10 years of relevant working experience.
• Experience of working with Looker, Look-ml code.
• Experience with DBT.
• Experience with SQL & Big query.
• Experience with Python.
• Excellent communication and presentation skills.

Why You’ll Love Working With Us

• Competitive Pay & Equity – We offer a great base salary plus equity, so you’ll own a part of what we’re building together.
• Generous Time Off – Enjoy 25 days of holiday each year (plus bank holidays if you’re in the UK), and earn an extra day each year after your first, up to 5 more!
• Hybrid Working – Life’s about balance. All we ask is for 2 days in the office every week.
• Nomad Working – Feel like a change of scenery? Work from anywhere or up to 30 days each year.
• Family First – We offer enhanced Maternity and Paternity leave because your family matters.
• Private Medical Insurance – You’ll get cover through BUPA, because your health is a priority.
• Mental Health Support – Access personalised mental wellness support through our award-winning partner.
• Future-Ready Perks – Including a solid company pension, life assurance, and income protection.
• Learn & Grow – A £200 annual budget for learning and personal development. Invest in you!
• Cycle to Work Scheme – Commute the healthy way with support from our cycle to work programme.
• Perks Hub Access – Enjoy exclusive discounts and offers through the Yapily Benefits Hub.
• Refer a Friend – Bring someone great onboard and earn £1,000 with our referral scheme.
• Team Vibes – Monthly socials, team lunches, and a budget to hang out and have fun (yes, pizza included).
• Office Snacks & Doggies – Daily snacks to keep you going, and yes – we’re proudly a dog-friendly office.