Staff Analytics Engineer

Aurorasolar

United States

Remote

USD 110,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

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

Job summary

Aurora Solar is seeking a Staff Analytics Engineer to partner with Finance, Product, and Go-to-Market to design scalable dbt data models and Looker dashboards, transforming complex datasets into trusted insights for forecasting and execution.

You will work with Data Engineering to ensure high-quality data pipelines and help establish dbt and Looker best practices while supporting analytics needs across the organization.

Qualifications

  • 4+ years of experience in analytics, analytics engineering, or a similar data-focused role using SQL to develop data models and generate business insights.
  • 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, with 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.
  • Excellent communication skills with the ability to explain technical concepts and analytical insights to both 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.

Skills

Analytics experience
SQL
AI tools
Analytics lifecycle
Communication
Cross-functional collaboration

Tools

dbt
Looker
Snowflake

Job description

About Aurora Solar

Aurora is on a mission to create a future of solar for all. Our award-winning software puts the power of data and technology into the hands of every solar professional to make solar adoption simple and predictable. Our software has designed millions of solar projects so far, empowering solar companies to sell, design, and install residential and commercial solar arrays accurately, seamlessly, and at scale.

About the Team

We are a team of experienced data professionals spanning Data Engineering, Analytics Engineering, and Analytics. We work collaboratively across the business to build trusted data foundations, deliver actionable insights, and solve complex problems that help accelerate the transition to clean energy.

About the Role

In this role, you will partner cross-functionally with Finance, Product, and Go-to-Market teams to design scalable dbt data models, build intuitive Looker dashboards, and integrate data from a variety of SaaS applications. You'll transform complex datasets into trusted insights that guide business decisions, forecasting, and execution.

You’ll collaborate closely with Data Engineering to ensure high-quality, reliable data pipelines while partnering with analytics engineers and analysts to establish and maintain dbt and Looker best practices. As a Staff-level individual contributor reporting to the Senior Director of Analytics, you’ll play a key role in shaping Aurora's analytics foundation and enabling data-driven decision-making across the business.

Your Impact
  • 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
What You Bring
  • 4+ years of experience in analytics, analytics engineering, or a similar data-focused role using SQL to develop data models and generate business insights
  • 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, with 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
  • Excellent communication skills with the ability to explain technical concepts and analytical insights to both technical and non-technical stakeholders
  • Demonstrated ability to work cross-functionally, influence stakeholders, and independently drive projects from concept through implementation
Nice to Haves
  • 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
What We Offer
  • Flexible PTO
  • Parental Leave
  • WFH Stipend
  • Coworking Stipend
  • Energize Fridays
  • Connectivity Stipend
  • Learning & Development
  • Medical, Dental, and Vision

Please take a look at our U.S. Benefits Booklet https://www.canva.com/design/DAHZ4lOMzZI/AQypvZvgfYwez2T6x-E07w/view?utlId=hcfc7317911&utm_campaign=designshare&utm_content=DAHZ4lOMzZI&utm_medium=link2&utm_source=uniquelinks for a deeper dive into our offerings

Where Aurorans are

Aurora currently has teams within the US, Canada, Poland, and Germany with additional locations on the horizon. We’re united in our work to support the world’s transition to solar!

Aurora is dedicated to building a diverse and inclusive workforce of people who believe in and are passionate about creating a future of solar energy for all. We are an equal opportunity employer, we welcome and consider qualified applicants regardless of gender identity, sexual orientation, race, religion, age, national origin, citizenship, pregnancy status, veteran status, or any other differences. We encourage you to apply even if you believe that you do not meet all of the above criteria!

Aurora is committed to creating an inclusive and accessible experience for all candidates. If you require a reasonable accommodation that would better enable your success during the application or interview process, please complete this form https://docs.google.com/forms/d/e/1FAIpQLSdIvyjhnxPXVhyK2Pn6Rk-Edu4ZQtcmVo6u-0Mvb4nmDFmgPw/viewform.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Director, Business Systems
Director, Business Systems

Aurora Solar • United States

Remote
USD 180,000 - 240,000
Flexible PTO
WFH Stipend
Learning & Development
+1
Director of Strategic Projects
Director of Strategic Projects

Aurora Solar • United States

On-site
USD 220,000 - 280,000
Flexible PTO
Parental Leave
WFH Stipend
+5
Director, Business Systems
Director, Business Systems

Aurora Solar • United States

Hybrid
USD 180,000 - 240,000
Flexible PTO
Parental Leave
WFH Stipend
+5
Software Engineer, Consumer
Software Engineer, Consumer

Aurora Solar • United States

Hybrid
USD 110,300 - 149,300
Flexible PTO
Parental Leave
WFH Stipend
+6
Enterprise Account Executive
Enterprise Account Executive

Aurora Solar • United States

Hybrid
USD 109,000 - 161,000
Flexible PTO
Parental Leave
WFH Stipend
+5
Mid-Market Account Executive
Mid-Market Account Executive

Aurora Solar • United States

Hybrid
USD 90,000 - 130,000
Flexible PTO
Parental Leave
WFH Stipend
+7
Product Marketing Manager
Product Marketing Manager

Aurora Solar • United States

Hybrid
USD 120,000 - 170,000
Flexible PTO
Parental Leave
WFH Stipend
+5
Staff Software Engineer
Staff Software Engineer

Aurora Solar • United States

On-site
USD 151,000 - 245,200
Flexible PTO
Parental Leave
WFH Stipend
+5
Senior Software Engineer, Sales Mode
Senior Software Engineer, Sales Mode

Aurora Solar • United States

Hybrid
USD 100,000 - 130,000
Staff Analytics Engineer (Fully Remote)
Staff Analytics Engineer (Fully Remote)

Aurora Solar • United States

Remote
USD 95,000 - 135,000
Flexible PTO
16 weeks parental leave
WFH stipend
+5