Skip to content

Staff Analytics Engineer

Aurora Solar LogoAurora Solar
View Organization

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

Compensation

  • Tier 1: San Francisco, CA - New York City, NY$157K – $208.1K • Offers Equity • Offers Bonus
  • Tier 2: Seattle, WA - Los Angeles, CA - Washington DC$143.9K – $190.7K • Offers Equity • Offers Bonus
  • Tier 3: All Other US Locations, Including Colorado$130.8K – $173.4K • Offers Equity • Offers Bonus

‌