Analytics Engineer

Capital on Tap is seeking an Analytics Engineer to join their growing Data Platform team. This role is crucial in how data moves around the business, responsible for building, maintaining, and optimizing their modern data platform from design to end product. The position focuses on providing seamless access to high-quality, tested, and documented data throughout the organization.

Key Responsibilities:

• Own the data stack for the global business, working with Fivetran, Snowflake, dbt, and Looker
• Create and maintain well-designed data pipeline architectures, mainly through organized and well-tested dbt models
• Build custom data pipelines using Python and the Azure platform
• Assemble large, complex data sets that meet business requirements
• Implement internal process improvements, including Github CI/CD and automating manual processes
• Work with stakeholders across the business to assist with data-related issues
• Maintain data efficiency and consistency at a global level across multiple regions
• Create and manage tools for analysts and data scientists to optimize product building

Requirements:

• Expert SQL skills
• Familiarity with Python (bonus)
• Knowledge of data modeling approaches (e.g., Kimball dimensional modeling)
• Experience with dbt (or similar) and Git for building SQL-based pipelines
• Experience with ELT tools and components (currently using Fivetran)
• Experience working with a cloud data warehouse (Snowflake)
• Familiarity developing/building within a BI tool (e.g., Looker, Mode, Tableau)
• Strong analytical skills

This is a hybrid role, with the team working from the London (Shoreditch) offices 1 day per week. Capital on Tap offers a range of benefits, including private healthcare, worldwide travel insurance, pension scheme, enhanced parental leave, and more. They are committed to diversity and inclusion, welcoming applications from candidates who share this commitment.