Staff Analytics Engineer, Aurora Solar
$135.5-200.5k
Offers equity and bonus. Salary dependent on location
Software solutions for the solar product lifecycle
Job no longer available
Software solutions for the solar product lifecycle
501-1000 employees
Job no longer available
$135.5-200.5k
Offers equity and bonus. Salary dependent on location
501-1000 employees
Company mission
To create a future of solar energy for all.
Role
Who you are
- 5+ years as an analytics engineer, data engineer, data analyst/scientist, or similar data role
- 3+ years experience using DBT
- A passion for full-stack data modeling and leading the end-to-end process ensuring data quality with a focus on back-end data modeling
- Expert in SQL and relational database design
- Expert-level Python experience in both data analysis and scripting for data engineering
- Prior experience in designing, implementing, and optimizing dbt and Looker models based on business and performance requirements
- Prior experience with Snowflake, Fivetran, Looker, and Mode
- A can-do attitude towards examining complex issues, opportunities, and problems, with the ability to work under their own initiative
- A collective approach with a consistent record of engaging with multiple collaborators across different business areas
- Passionate about documenting your work
What the job involves
- In this role, you will own our analytics data architecture, be a leader in data modeling best practices, and optimize the ingestion and transformation of internal and external data to support accurate, timely, and easy analysis.
- This is a key role that will help restructure our DAG, rethink our job schedule, map use cases to model design and help us achieve scalable teaching processes
- If you are keen to help build an analytics framework and create meaning out of customer touchpoints, this role is well-positioned for you. You will report to the Director of Analytics
- 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 best practices and enhance our data infrastructure
- Own 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
- In partnership with analysts, design and implement data marts to address specific departmental data needs
- Manage 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
- Help maintain our data catalog as a scalable resource to support self-service and single-source-of-truth analytics
Our take
Aurora Solar is a SaaS company helping solar sales companies remotely assess and manage solar installation projects. Solar energy is becoming both a more attractive and more financially viable path for large and smaller scale projects, as prices drop and eco-consciousness rises.
There's considerable market opportunity, with the solar installation industry expected to grow significantly over the next decade, and Aurora Solar is enabling these installations. Aurora wisely offers products that contribute all along the supply chain of solar developments; such as solar sales, engineering design, and automated operations. It has also delivered AI-enabled solutions aimed at streamlining residential solar lead generation, project design, and sales processes.
Aurora Solar has seen significant investment that has allowed it to operate at the front of the sector as it develops, and in 2022 reached the milestone of generating its 10 millionth solar roof design. It has been working to develop new partnerships and integrations, such as with Dividend, Mosaic, and Sungage Financial, to further advance its goal of accelerating solar adoption.
Freddie
Company Specialist at Welcome to the Jungle
Insights
51% employee growth in 12 months
Company
Funding (last 2 of 5 rounds)
Feb 2022
$200m
SERIES D
May 2021
$250m
SERIES C
Total funding: $520.2m
Company benefits
- Health Plans: Medical, Dental, and Vision plans are 100% covered
- Flexible PTO: Take the time when you need it
- Remote: We are a remote first team with office options too.
- Parental Leave: 16 weeks of parental leave at 100% base salary
- Stipends: WFH/Connectivity/Co-working available for all eligible employees
- Energize Fridays: Company-wide days to log off and recharge
Company HQ
Union Square, San Francisco, CA
Leadership
Samuel Adeyemo
(Boardmember)Spent 7 years at JPMorgan, and worked as President of Vituo Technologies.
Christopher Hopper
(CEO)Co-Founder and former Chairman of e.quinox, and a founding member of BBOXX.
Share this job