A

Aurora Solar

PV design and sales software platform

Staff Analytics Engineer

Data Engineering +1Confirmed live in the last 24 hours
Full-timeRemote in USA$136.2k - $216.7k /yrRemote

About the Job

Requirements

  • At least 4 years of experience in analytics, analytics engineering, or a similar data-focused role using SQL to develop data models and generate business insights.
  • At least 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 based on business and performance requirements.
  • Advanced SQL and analytical problem-solving skills, including the ability to independently solve complex data challenges.
  • Experience leveraging AI tools to accelerate analysis, troubleshoot data issues, and support complex data modeling workflows.
  • Experience owning the end-to-end analytics lifecycle, including data modeling, validation, quality assurance, and delivery of trusted reporting.
  • Ability to explain technical concepts and analytical insights to technical and non-technical stakeholders.
  • Demonstrated ability to work cross-functionally, influence stakeholders, and independently drive projects from concept through implementation.

Responsibilities

  • Design, build, and evolve scalable dbt data models that accurately represent company KPIs and business metrics.
  • Develop and maintain intuitive Looker dashboards that enable stakeholders to make informed, data-driven decisions.
  • Partner with Finance, Product, Go-to-Market, and other cross-functional teams to understand business requirements and translate them into scalable analytics solutions.
  • Collaborate with Data Engineering to ensure reliable, high-quality data is available for reporting and analysis.
  • Partner with analytics engineers and analysts to establish dbt and Looker best practices, perform quality assurance on data models and dashboards, and support analytics needs across the organization.
  • Analyze complex datasets to uncover actionable insights that improve business performance, forecasting, and operational decision-making.
  • Help scope, prioritize, and execute analytics initiatives that deliver measurable value across the company.

Desired Qualifications

  • 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.

About the Company

Aurora Solar

PV design and sales software platform

Aurora Solar provides cloud-based software for solar installers to design, quote, and sell PV systems. Its core product creates detailed 3D models of residential and commercial properties, runs performance simulations, and performs financial analyses, all from a subscription-based platform. The software automates many steps in the design process, enabling users to generate accurate system layouts quickly and prepare proposals for customers. Unlike generic design tools, Aurora Solar focuses specifically on the solar industry and offers tailored features, scalable plans, and ongoing updates to support installers as they grow their business. The company’s goal is to help solar companies design and sell more systems efficiently, reducing time and cost while promoting solar energy adoption.

Company size
201-500
Company stage
Series D
Total funding
$520.2M
Headquarters
San Francisco, CA
Founded
2013

Recently Posted Jobs

Explore more opportunities at Aurora Solar

See more jobs