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.
We’ve been named one of "The Best Remote Companies" by BuiltIn.com and have been recognized for the second time as a Certified Green Business (CGB) with the city of San Francisco. We’re in this together to support the world’s transition to solar.
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 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.
Skills Required
- 4+ years of experience in analytics, analytics engineering, or similar using SQL to develop data models and generate business insights.
- 2+ years of production experience with dbt and Looker.
- Design, build, and optimize scalable dbt models and Looker dashboards based on business and performance requirements.
- Advanced SQL and strong analytical problem-solving skills.
- Experience leveraging AI tools to accelerate analysis, troubleshoot data issues, and support complex data modeling workflows.
- Experience owning end-to-end analytics lifecycle: data modeling, validation, quality assurance, and delivery of trusted reporting.
- Excellent communication skills; able to explain technical concepts and insights to technical and non-technical stakeholders.
- Demonstrated ability to work cross-functionally, influence stakeholders, and independently drive projects from concept through implementation.
- 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.
Aurora Solar Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Aurora Solar and has not been reviewed or approved by Aurora Solar.
-
Healthcare Strength — Health plans are described as fully employer‑paid for employees with strong dependent coverage on base plans. This breadth bolsters overall compensation value alongside cash components.
-
Parental & Family Support — Paid parental leave is outlined at full base pay for all parents with a gradual return‑to‑work program. Caregiving leave is also referenced, reinforcing family support.
-
Wellbeing & Lifestyle Benefits — Mental‑health resources, wellness programming, and gym access are emphasized as part of the package. Stipends for home office, connectivity, and co‑working further support day‑to‑day wellbeing.
Aurora Solar Insights
What We Do
Aurora is creating a future of solar for all. We’re putting the power of data and technology into the hands of every solar professional to make solar adoption simple and predictable. Our cloud-based platform uses data, automation, and AI to streamline workflows and grow solar businesses faster. As a fast-growing Series D company, we’re disrupting the clean energy industry and changing the course of history with our award-winning, industry-leading software. This software doesn’t just design millions of solar projects, but designs a better tomorrow, empowering solar companies to sell, design, and install residential and commercial solar arrays accurately, seamlessly, and at scale. More than 7,000 of the industry's top organizations rely on Aurora and over 10 million solar projects have been designed with our platform globally. For more information, visit www.aurorasolar.com and follow us on LinkedIn.
Why Work With Us
We aim to reflect inclusivity in the people who imagine and build our product by creating an environment where diversity is cherished and where anyone—regardless of background—can thrive. We strive to always do better and know that by empowering people, we can power the planet.
Gallery









