Senior Data Analyst

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 Team

You’ll be joining a team of seasoned data professionals covering data engineering, analytics engineering, and analytics. We’re collaborative, curious, and passionate about applying data to solve one of society’s most pressing issues.

About the Role

In this role, you will work cross-functionally with Finance, Product, and Go-to Market teams to design dbt data models, build compelling dashboards, and source relevant data from various SaaS applications. You will not only draw insights from disparate data sets through compelling visualizations but also partner with teams to guide decision making, forecasting, and execution. You’ll partner with data engineering to ensure data is available and work closely with analytics engineers and analysts to follow dbt and Looker best practices. You will report to the Director of Analytics.

Your Impact

• Translate data in insightful dashboards to drive decision making

• Design and evolve logical and scalable dbt data models that reflect company KPIs 

• Design and maintain Looker dashboards

• Partner with other analysts to ensure adherence to dbt/Looker best practices, QA dashboards/models, and learn/support other domains’ data needs

• Engage with cross-functional teams to understand their data requirements; help scope and prioritize these requirements to develop analytics projects and dashboards

What You Bring

• 3+ years of analyst experience using SQL to develop data models and deliver insights

• 1+ years of experience working with Looker and dbt

• Solid experience designing and optimizing dbt and Looker models based on business and performance requirements

• Advanced problem-solving skills

• Proven ability to communicate effectively to technical and non-technical audiences

• Experience in full-stack data modeling and owning the end-to-end process ensuring data quality with a focus on back-end data modeling

• Demonstrated success examining issues, opportunities, and problems, with the ability to work under their own initiative

• A collaborative mentality with a proven record of engaging with multiple collaborators across different business areas

Nice to Haves

• Python forecasting experience

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.