Analytics Engineer, GoHenry

• 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

Desirable

• GoHenry is seeking an experienced and self-driven Analytics Engineer to be a pivotal part of our Data Platforms team
• You won't just be building data models; you'll be shaping the insights that drive our product forward and help millions of kids and teens build good financial habits
• As part of our central group, you will manage data platforms for GoHenry and our parent company, Acorns, working with key technologies like dbt, Dataform, BigQuery, and Databricks
• We follow a modern ‘Extract, Load, Transform (ELT)’ approach, and as our new Analytics Engineer, you will own the crucial ‘T’
• Your primary focus will be designing, building, and maintaining robust and scalable data models in the GoHenry and Acorns data warehouses
• 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, 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
• Keeping our documentation up-to-date
• Performing regular proactive maintenance and housekeeping on the data warehouses
• Working with colleagues from other teams to monitor and improve data quality within the warehouse
• 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