Staff Analytics Engineer
To see similar active jobs please follow this link: Remote Development jobs
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.
About the job
Staff Analytics Engineer
To see similar active jobs please follow this link: Remote Development jobs
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.