• Strong SQL skills and experience working with modern data warehouses (BigQuery, Snowflake, Redshift, or similar)
• Experience designing analytics data models and reporting layers
• Experience building dashboards and data visualisations
• Experience with BI tools such as Superset, Looker, Tableau, or Metabase
• Experience managing data transformations using dbt, Dataform, or similar frameworks
• Ability to structure and analyse data to answer business questions
• Clear communication and collaboration skills
• Comfortable working in a small team environment

Desirable

• We're looking for an Analytics Engineer to develop and maintain the data models and reporting infrastructure used for analytics at Lightning Reach
• Data from our application databases is streamed into BigQuery. You’ll turn that raw data into a scalable, well-structured analytics foundation - defining how data is modelled, organised, and used across the company
• This is a high-ownership role with the opportunity to build the data model from the ground up and set the standard for how we use data to measure performance and impact
• You'll also own our reporting environment, ensuring data is reliable, accessible, and useful for both internal teams and external stakeholders - working closely with engineering, product, and operations to make that happen
• Design and maintain the analytics data model in BigQuery
• Develop and maintain data transformations that convert raw application data into structured analytics datasets
• Define shared metrics and reporting datasets
• Ensure data quality, documentation, and efficient query performance
• Manage datasets and dashboards in Apache Superset for internal and customer-facing reporting
• Perform analysis to support product, operational, and impact reporting
• Work with engineering and other teams to understand data structures and reporting needs
• The role involves using Google Cloud Platform and Cloud SQL

• Apply via Welcome to the Jungle
• First round interview with our Product team
• Take home task, followed by a task assessment call with the team
• Final round interview