Staff Analytics Engineer

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