Analytics Engineer / BI Developer

Job Description

Twenty7tec transforms financial advice through technology. We partner with businesses of all sizes who share our ambition to simplify, streamline and digitise financial services in the mortgage and wealth markets. All our partners are different, so our technology can be customised to meet both the needs of the business and the needs of the client. As such, we need talented people to join our growing team and are excited we have new opportunities to do so.

We now have an exciting opportunity for an Analytics Engineer/BI Developer to join our friendly team.

In this role you will transform raw data into clean, reliable, and easily consumable datasets and then build compelling visualizations and reports that empower business users to make data-driven decisions.

About Us

The power and benefits of great financial advice are unquestionable. Twenty7tec, through our Velocity platform, is committed to designing and building exceptional technology that supports mortgage, protection, and wealth advisers in delivering exceptional client outcomes. Our technology is used by advisers, lenders, product providers, and financial institutions to underpin the effective delivery of financial advice to millions of consumers in the UK. On a daily basis, over 16,000 mortgage, protection and wealth advisers utilise our Velocity platform.

Twenty7tec is a diverse employer, and we understand that everyone is unique. If you require additional information or reasonable adjustments to help you with your application or interview, we would be very happy to assist. If your application is successful and you are invited to an interview, we will provide you with an information sheet giving insight into our interview process, so you know what to expect.

Recruitment Process

Applications for this role may require a short online assessment to establish competency in certain skill areas. If your application is successful, you will be invited to a short telephone screening call with a member of our HR team. This is an informal conversation to find out a little more about you and your expectations ahead of potentially moving on to a formal interview. If you are invited to an interview, this may be carried out at our Bournemouth office, or online via a video call depending on your location. Interviews are conducted with the line manager for this role. A second interview may be required depending on the specific job role and may be attended by a member of senior management where required. Don’t worry though, we’re all very friendly!

Job Requirements

About You

You will have:

• Degree in Data Science, Technology, Computer Science or related field, or equivalent practical experience.
• Extensive SQL Proficiency: 3+ years of hands-on experience writing complex SQL for data manipulation, transformation, and querying (e.g., window functions, CTEs, performance tuning). We have a large bank of transformation logic pre-existing.
• Proven experience in designing and implementing data models for analytical purposes.
• 2+ years of in-depth experience developing dashboards and reports with at least one major BI tool (e.g., Tableau, Power BI, Looker, Qlik Sense). We use Sigma but any major platform will do.
• Experience with modern data transformation frameworks (e.g., dbt - highly preferred, Airflow for orchestration, Dataform). We use Kleene.ai but other configurations are acceptable.
• Hands-on experience with cloud data warehouses/lakehouses (e.g., Snowflake, Google BigQuery, Amazon Redshift, Databricks). We use Snowflake.
• Experience with Git/GitHub for collaborative code management.
• Previous roles as a Data Analyst, BI Developer, or Analytics Engineer, demonstrating a strong understanding of business metrics and analytical methodologies.
• Stakeholder Interaction: Experience gathering requirements from non-technical business users and translating them into technical solutions.
• ETL/ELT Concepts: Solid understanding of data extraction, loading, and transformation processes, including the classic medallion architectural pattern.

Job Responsibilities

You will:

Data Modeling and Transformation:

o Design, develop, and maintain robust data models within the data warehouse (Snowflake) to optimise for analytical queries.

o Write, optimise, and maintain complex SQL queries and data transformation logic (we have pre-build tools and a library of scripts) to clean, enrich, and aggregate raw data into analytics-ready datasets.

o Implement data quality checks and validation processes to ensure the accuracy and reliability of transformed data.

BI Solution Development & Visualization:

o Design, develop, and maintain interactive dashboards, reports, and analytical tools using leading BI platforms (e.g., Sigma, Tableau, Power BI, Looker).

o Translate complex business questions into clear, intuitive, and visually appealing data stories.

o Develop and manage key performance indicators (KPIs) and metrics, ensuring consistent definitions and calculations across the business.

• Collaboration and Requirements Gathering:

o Work closely with business stakeholders (e.g., product, marketing, finance, operations) to understand their analytical needs and translate them into technical requirements for data modelling and reporting.

o Collaborate with Developers to understand upstream data sources, discuss data ingestion strategies, and address data pipeline issues.

o Provide guidance and support to data analysts and other business users on how to effectively use data products and BI tools for self-service analytics.

• Documentation & Governance:

o Create and maintain comprehensive documentation for data models, transformation logic, report definitions, and data dictionaries to ensure data discoverability and understanding.

o Adhere to and promote data governance best practices, including data quality, security, and access control.

• Performance Optimisation & Automation:

o Monitor and optimise the performance of data transformations and BI reports to ensure fast query times and efficient data delivery.

o Identify opportunities for automation in data pipelines and reporting processes to reduce manual effort and improve data freshness.

The above is not an exhaustive list of duties and you will be expected to perform additional or other duties as necessary to meet the needs of the business.

Job Benefits

You'll be joining a company that looks after its people. Twenty7tec is currently ranked as a "Best Technology Company" to work for and holds a Best Companies "Outstanding Company to Work For" official accreditation

• Performance Bonus
• Flexible working location (Hybrid)
• Increase on length of service up to a maximum of 28 days holiday plus bank holidays
• Enhanced Maternity and Paternity Leave
• Pension scheme
• Death In Service Insurance
• Financial coaching and salary advance platform
• Cycle to work scheme
• Learning and development opportunities, including a Udemy for Business Licence
• Wellbeing programme, including access to Mental Health First Aiders
• Health care plan (dependent on length of service)
• Dog-friendly office
• In-person and remote social events throughout the year
• Salary Range - £50,000 - £65,000 GBP