Staff Analytics Engineer

| US +80 more | Remote
By clicking Apply Now you agree to share your profile information with the hiring company.

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 are a remote-first collaborative team of sustainable energy enthusiasts who love what we do. We've been named one of "The Best Mid-Sized Remote Companies To Work for in 2024" by 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 Role
In this role, you will own our analytics data architecture, be a leader in data modeling standard processes, and optimize the ingestion and transformation of internal and external data to support accurate, timely, and easy analysis. If you are keen to help build an analytics framework and a scalable data platform, this role is well-positioned for you. You will report to the Director of Analytics.
Your Impact

  • Own and maintain integration between our tools using standard methodologies to ensure a seamless workflow between Fivetran, Snowflake, dbt, and Looker
  • Partner with our infrastructure and engineering teams to help drive standard processes and enhance our data infrastructure
  • Be responsible for the dbt infrastructure and maintenance in both dbt Cloud and Core
  • Create and maintain CI/CD pipelines using dbt and GitHub
  • Design, build, and optimize scalable data models
  • Support enhancement of python-based forecasting model that drives key company metrics
  • In partnership with analysts, design and implement data marts to address specific departmental data needs
  • Lead and maintain reporting infrastructure to drive business insights
  • Continuously iterate and improve upon how we use dbt including building macros, applying the latest dbt packages, and finding ways to reduce technical debt
  • Define and implement engineering standard processes including code reviews, documentation, testing frameworks and alerting to establish trust in our data
  • Provide technical guidance and training to data analysts
  • Develop data quality monitoring solutions to increase data quality standards and metrics accuracy
  • Consistently improve on the data platform with new tools and technologies

What You Bring

  • 5+ years as an analytics engineer, data engineer, data analyst/scientist, or similar data role
  • Expert in SQL and relational database design
  • Significant experience with Python for analysis, automation, and machine learning technologies (e.g. sklearn for forecasting, clustering, etc)
  • 3+ years experience using DBT, and prior experience with Snowflake, Fivetran, and Looker
  • A passion for full stack data modeling and leading the end-to-end process to ensure data quality
  • Prior experience in designing, implementing, and optimizing dbt and Looker models based on business and performance requirements
  • A can-do attitude towards examining complex issues, opportunities, and problems, with the ability to work under their own initiative
  • Autonomous with an ability to organize colleagues around a problem
  • A collective approach with a consistent record of engaging with multiple collaborators across different business areas

What We Offer

  • 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
  • Energize Fridays - Company-wide days to log off and recharge
  • Connectivity Stipend - Up to $75 / month towards internet or phone
  • Medical, Dental, and Vision - Premiums are 100% covered for Aurorans and 90% for dependents
  • Please take a look at our 2024 U.S. Benefits Booklet for a deeper dive into our offerings

Where Aurorans are: Aurora currently has teams within the US, Canada, Mexico, 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 .
For San Francisco applicants: Pursuant to the San Francisco Fair Chance Ordinance, we will consider qualified applicants with arrest and conviction records for employment.

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Candidate Location Eligibility:
Albuquerque, NM
Ann Arbor, MI
Atlanta, GA
Austin, TX
Baltimore, MD
Baton Rouge, LA
Birmingham, AL
Boise, ID
Boston, MA
Buffalo, NY
Charleston, SC
Charlotte, NC
Chicago, IL
Cincinnati, OH
Cleveland, OH
Colorado, CO
Columbus, OH
Dallas-Fort Worth, TX
Dayton, OH
Des Moines, IA
Detroit, MI
Fayetteville-Springdale-Rogers, AR
Greensboro, NC
Hampton Roads, VA
Hartford, CT
Houston, TX
Huntsville, AL
Indianapolis, IN
Jacksonville, FL
Kansas City, MO
Las Vegas, NV
Lexington, KY
Lincoln, NE
Little Rock, AR
Los Angeles, CA
Louisville, KY
Madison, WI
Memphis, TN
Miami, FL
Milwaukee, WI
Minneapolis–Saint Paul, MN
Nashville, TN
New Orleans, LA
New York City, NY
Ogden, UT
Oklahoma City, OK
Omaha, NE
Orlando, FL
Other US Location
Palm Bay-Melbourne-Titusville
Pensacola, FL
Peoria, IL
Philadelphia, PA
Phoenix – Mesa – Scottsdale, AZ
Pittsburgh, PA
Portland, ME
Portland, OR
Providence, RI
Provo, UT
Raleigh-Durham, NC
Reno, NV
Richmond, VA
Rochester, NY
Sacramento, CA
Salt Lake City, UT
San Antonio, TX
San Diego, CA
San Francisco, CA
San Luis Obispo, CA
Santa Cruz, CA
Seattle, WA
Spokane, WA
St. Louis, MO
Tallahassee, FL
Tampa Bay, FL
Tucson, AZ
Tulsa, OK
Washington DC
Wichita, KS
Wilmington, NC

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
  • People Operations
    • C++Languages
    • GolangLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • TypeScriptLanguages
    • ReactLibraries
    • ReduxLibraries
    • DjangoFrameworks
    • GraphQLFrameworks
    • Ruby on RailsFrameworks
    • TerraformFrameworks
    • MySQLDatabases
    • PostgreSQLDatabases
    • AWS (Amazon Web Services)Services
    • Google AnalyticsAnalytics
    • LookerAnalytics
    • FigmaDesign
    • Monday.comManagement
    • HootsuiteCMS
    • WordpressCMS
    • HubSpotCRM
    • IntercomCRM
    • SalesforceCRM
    • SlackCollaboration
    • ZoomCollaboration
    • Monday.comProject Management

An Insider's view of Aurora Solar

How would you describe the company’s work-life balance?

At Aurora, work-life balance means flexible PTO and work schedules. It’s a shared understanding that we all get our best work done when our mental health and well-being are top of mind. It’s managers who encourage us to take time to care for loved ones when needed and a company that values me as a professional and a mother.


Workplace Experience Program Manager

How do you collaborate with other teams in the company?

At Aurora, cross-functional collaboration flows seamlessly through regular Slack communication and frequent team syncs.
Whether partnering with marketing, operations, or recruiting teams, we work together swiftly, relying on each other's expertise towards our shared mission of accelerating global solar adoption.


BDR Manager

What are some things you learned at the company?

A highlight of my career at Aurora Solar is experiencing the value of teaming and celebration. By recognizing wins - like our tradition of sharing weekly rounds of kudos - we've created a culture of growth and support where everyone is encouraged to do their best. This energizes and elevates our people, while powering us to build what matters.


Head of Social Impact

How do your team's ideas influence the company's direction?

One of Aurora Solar's core values is "outcome over ego", which means that anyone in the company is empowered to speak up and contribute. I have seen the magic that happens when you empower a group of incredibly talented people to solve challenging problems that matter. That, to me, is what makes Aurora Solar a truly special place to work at.



What makes someone successful on your team?

My team is successful when we combine a really good understanding of our customers' needs, their business goals, and solar industry trends, along with deep knowledge of how our product works, and ways to come up with creative solutions that can achieve our customers' goals.


Senior Director, Business Development & Client Solutions

What are Aurora Solar Perks + Benefits

Aurora Solar Benefits Overview

We strive to be the best place for the best people, and that includes the benefits and perks we offer our employees. As a result, we look to offer a holistic program to support and address physical, emotional, financial, and social needs. We offer 100% coverage of medical, dental, and vision insurance, stock options, 401K benefits, generous parental leave for birthing and non-birthing parents, work-from-home stipends for home office setup, internet, and co-working memberships, flexible time off, and wellness programs.

Volunteer in local community
To encourage and support Aurorans in their volunteering efforts, we have a Volunteer Time Off Policy (VTO). VTO hours can be used to support charities, causes, or non-profits of your choosing.
Partners with nonprofits
Aurora partners with nonprofits such as GRID Alternatives, NCCER, and NREL.
Open door policy
OKR operational model
Team based strategic planning
Pair programming
Open office floor plan
Employee resource groups
Employee-led culture committees
In-person revenue kickoff
Summer hours
Employee awards
Flexible work schedule
Remote work program
We are a fully remote team located across the U.S., Canada, and Germany with stipends available for home office setup, internet, and co-working space subscriptions.
Documented equal pay policy
Dedicated diversity and inclusion staff
Highly diverse management team
We have a diverse leadership team and workspace. Our diverse team brings us a great breadth of new perspectives which allows us to continuously facilitate innovation.
Mean gender pay gap below 10%
Diversity employee resource groups
We have a number of Diversity ERGs that are safe spaces for employees to connect and discuss shared experiences and initiatives.
Hiring practices that promote diversity
Diversity is essential to our Talent Team. We practice inclusive interviewing, track diversity metrics, and implement consistent interview processes for all candidates.
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Employees can participate in our Dependent Care, Health Care, and/or Limited-purpose FSA. They can contribute up to the IRS maximum set for that plan year.
Disability insurance
Short-Term Disability insurance is provided with 100% base pay coverage for up to 12 weeks. Long-Term Disability insurance is provided with 60% base pay coverage.
Dental insurance
Our dental plan covers 100% of preventative services expenses.
Vision insurance
The vision benefits plan covers 100% of the plan costs and includes routine eye exams.
Health insurance
Aurora offers medical, dental, and vision plans. We cover 100% of the premiums for individual-only coverage for base plans. Additionally, we cover 90% of the premiums for employees who add dependents.
Life insurance
We offer life insurance with a payout of 1x an employee’s annual salary up to $250000. Additionally, employees receive an additional $25,000 in coverage for basic life and ad&d.
Wellness programs
*New 2024 Benefit* Aurora partners with Gympass. Aurorans in the U.S. and Germany can access the starter plans, allowing them and their dependents to access over 2.9k gyms, streamed classes, & more!
Mental health benefits
*New 2024 Benefit* Aurora offers 8 in-person or virtual therapy sessions and 8 coaching sessions through our mental wellbeing provider, Modern Health & more!
Wellness days
Financial & Retirement
Employees are eligible to participate in a traditional 401k and/or Roth 401k account. Participants are automatically enrolled at 4% of their base salary.
401(K) matching
*New 2024 Benefit* Aurora Solar offers a 50% match to employee’s contributions up to a maximum of $1,200 annually.
Company equity
All full time employees receive equity grants which vest over a standard 4-year period with a 1-year cliff. Employees with a tenure of 2 years have an extended exercise window of 10 years.
Performance bonus
Every full-time employee receives variable pay in their compensation package that's either tied to individual performance, MBOs, or company performance.
Pay transparency
Child Care & Parental Leave Benefits
Generous parental leave
Aurora Solar provides 16 weeks of parental leave for birthing and non-birthing parents. All parental leave is paid at 100% of base salary.
Family medical leave
*New 2024 Benefit* Caregiving leave - Employees are eligible for 12 weeks of caregiving leave to care for an eligible family member. All caregiving leave is paid 100% of the employee’s base salary.
Return-to-work program post parental leave
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Our flexible time off policy encourages team members to take time off when needed for vacation, sick time, mental health, and other required reasons to unplug like jury duty.
Paid volunteer time
All full-time Aurorans are eligible for VTO. You can volunteer up to 8 hours per calendar year with a charity, cause, or non-profit of your choice in accordance with Aurora guidelines.
Paid holidays
Paid sick days
Take days off if you are sick, they do not count against your PTO.
Flexible time off
Floating holidays
Bereavement leave benefits
Hardship benefits
*New 2024 Benefit* Aurora offers a 4-week Return to Work Program post parental leave as well as 100% compensation coverage for Short-Term Disability leave.
Company-wide vacation
Aurora sets four Energize Fridays, where all Aurorans unplug and take time off work.
Office Perks
Commuter benefits
Set aside up to $300/month on a pre-tax basis for commuting and parking-related expenses.
Company-sponsored outings
It’s important for us to get to know the people we work with on a personal level so we host company outings and summits for team members to meet each other.
Free snacks and drinks
For our team members who choose to come to our headquarters, we have a fully stocked kitchen including unlimited snacks, coffee, tea, and all of the flavored water you can handle.
Company-sponsored happy hours
Our workplace experience team organizes company-wide virtual and in-person happy hours. Individual teams are also encouraged to host their own happy hours at their own discretion.
Pet friendly
Your furry friends are always welcome to make an appearance on Zoom! We even have our own dedicated pet directory and pet slack channel. If you have a pet, we want to know about it!
Home-office stipend for remote employees
Employees are provided with a MacBook Pro along with a $500 stipend to set up their home office to create their peak working environment. An additional $100 is provided every 6 months.
Professional Development Benefits
Job training & conferences
Aurora Solar offers employees professional development opportunities to continuously harness new skills and be more involved in the organization.
Lunch and learns
Our people are our best asset and we want to learn from their experience and celebrate the diversity on our team. We have a variety of lunch and learns hosted by our employees and outside speakers.
Promote from within
Mentorship program
Continuing education stipend
Aurora provides each employee with an annual Learning and Development budget that is allocated for professional development!
Continuing education available during work hours
Online course subscriptions available
Customized development tracks
Paid industry certifications
Personal development training
Virtual coaching services

More Jobs at Aurora Solar

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Aurora SolarFind similar jobs like this