Aurorasolar

Staff Analytics Engineer

United States, Remote. Posted 4 months ago

The role

You will design scalable dbt data models and build Looker dashboards. You will partner with Finance, Product, and Go-to-Market teams to transform complex datasets into insights.

What you will do

  • Design, build, and evolve scalable dbt data models
  • Develop and maintain intuitive Looker dashboards
  • Partner with Finance, Product, Go-to-Market, and other cross-functional teams
  • Collaborate with Data Engineering to ensure reliable, high-quality data
  • Partner with analytics engineers and analysts to establish dbt and Looker best practices
  • Perform quality assurance on data models and dashboards
  • Analyze complex datasets to uncover actionable insights
  • Help scope, prioritize, and execute analytics initiatives

Required qualifications

  • 4+ years of experience in analytics, analytics engineering, or a similar data-focused role using SQL
  • 2+ years of experience working with dbt and Looker in a production environment
  • Strong experience designing, building, and optimizing scalable dbt models and Looker dashboards
  • Advanced SQL and analytical problem-solving skills
  • Experience leveraging AI tools to accelerate analysis, troubleshoot data issues, and support complex data modeling workflows
  • Experience owning the end-to-end analytics lifecycle
  • Excellent communication skills
  • Demonstrated ability to work cross-functionally, influence stakeholders, and independently drive projects

Nice to have

  • Experience building forecasting models using Python
  • Experience supporting Finance, Revenue Operations, or SaaS business analytics
  • Experience working with modern cloud data warehouses such as Snowflake
  • Familiarity with Fivetran or similar ELT tools

Benefits

  • Flexible PTO
  • Parental Leave
  • WFH Stipend
  • Coworking Stipend
  • Energize Fridays
  • Connectivity Stipend
  • Learning & Development
  • Medical, Dental, and Vision

About the company

Aurora is on a mission to create a future of solar for all. Their software helps solar professionals sell, design, and install residential and commercial solar arrays.