Analytics Engineer

• We follow a modern ‘Extract, Load, Transform (ELT)’ approach, and as an Analytics Engineer you will focus on the crucial ‘T’. Your primary focus will be designing, building, and maintaining robust and scalable data models in the GoHenry and Acorns data warehouses, as well as the semantic layer in our agentic analytics platform. You will partner with people across Product, Marketing, Operations, and Finance to turn raw data into actionable intelligence. • Designing, building, testing, deploying and monitoring data models and semantic models, following all best practices and team standards and processes. • Collaborating with and enabling data analysts to build effective models to power their analysis and reporting. • Taking a leading role in data observability, supporting data analysts to use the tools available to them to monitor the metrics they own. • Keeping our documentation up-to-date. • Performing regular proactive maintenance and housekeeping on the data warehouses. • Responding to incidents arising from data transformation pipeline failures. • Sharing knowledge with other team members, and playing an active role in the wider Acorns/GoHenry data community. • Contributing to the continuous improvement of our data practices and taking on new challenges as the team grows. • An advanced level of data modelling experience in a data warehouse environment. • Experience using a data transformation tool such as dbt or Dataform. • A curiosity and desire to learn how GoHenry and Acorns works, and gain a deep understanding of the product structure and business models. • Previous experience working as a data analyst, to be able to design data models to meet the needs of data analysts and other data warehouse users. • An engineering mindset, with knowledge of DataOps. • An excellent understanding of data warehousing concepts and best practices. You will be equally comfortable starting with a blank canvas and extending complex existing solutions. • Ability to write advanced analytical SQL queries. • A team player fluent in English with excellent written and verbal communication skills. • Good working knowledge of Databricks and BigQuery. • Experience building semantic models/knowledge graphs, or a desire to learn.