Aurora Solar

Aurora Solar

Staff Analytics Engineer

United States · Staff+

Sponsorship not specified$164k-$217kDetected 119 days ago
SQLdbtData EngineeringData VisualizationForecastingCommunicationProblem SolvingRenewable Energy

Stay score

odds of building a lasting career here

59Sponsors, lottery-bound
Cap-exempt (no lottery)0
Sponsors this role80
Entry-level history0
PERM / green-card track0
Lottery odds (Level IV)94
Fits your clock70

Sponsors, but it's cap-subject — you still face the weighted lottery (~61% per draw at Level IV). Good if you win; have a cap-exempt backup on your list.

Lottery odds assume a STEM candidate.

Personalize to your clock →

Community outcomes

No reports yet — be the first to help the next applicant.

About the role

  • You'll transform complex datasets into trusted insights that guide business decisions, forecasting, and execution.
  • 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.
  • Analyze complex datasets to uncover actionable insights that improve business performance, forecasting, and operational decision-making.

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.
  • Help scope, prioritize, and execute analytics initiatives that deliver measurable value across the company.
  • 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're in this together to support the world's transition to solar.
  • 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.
  • This allows for financial growth within the role as the employee builds experience and displays a track record of performance success at Aurora.

Requirements

  • 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.
  • Advanced SQL and analytical problem-solving skills, with the ability to independently solve complex data challenges.
  • 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.
  • Experience supporting Finance, Revenue Operations, or SaaS business analytics.
  • Familiarity with Fivetran or similar ELT tools.
  • Strong experience designing, building, and optimizing scalable dbt models and Looker dashboards based on business and performance requirements.
  • Experience leveraging AI tools to accelerate analysis, troubleshoot data issues, and support complex data modeling workflows.
  • 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.

Skills

  • Experience working with modern cloud data warehouses such as Snowflake.

Compensation

  • Our pay ranges are anchored to the median of the market for companies of our size and industry.
  • Our pay for new hires is typically set at the start of the position's pay range.
  • Our current base pay ranges in each zone are:
  • $163,500 - $216,700
  • $149,800 - $198,600
  • $136,200 - $180,600

Benefits

  • 🏖️Flexible PTO - Take the time when you need it
  • 🍼Parental Leave - 16 weeks with 100% base salary + gradual return to work
  • 💰WFH Stipend - An initial $500 (Non-engineers) or $750 (Engineering roles)
  • 🏢 Coworking Stipend - $300 / month if you prefer to be at a coworking facility near you
  • 📶Connectivity Stipend - Up to $100 / month towards internet or phone
  • Learning & Development - $720 / annually to use towards professional development (You have to complete 90 days of employment to receive this stipend)
  • 🩺Medical, Dental, and Vision - Premiums are 100% covered for Aurorans and 90% for dependents

Company info

  • 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.
  • Aurora is on a mission to create a future of solar for all.
  • Compensation Philosophy: At Aurora Solar, we foster an exceptional work environment through inclusiveness and transparency.

Equal opportunity

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

Visa & Work Authorization

  • consider qualified applicants regardless of gender identity, sexual orientation, race, religion, age, national origin, citizenship, pregnancy status, veteran status, or any other differences
Apply directly at Aurora Solar →Create a free account for alerts like thisView Aurora Solar immigration profile

This listing is sourced directly from Aurora Solar's careers page and normalized into a canonical job model.