Staff Analytics Engineer
Aurora Solar · Remote · United States ·
COMPENSATION
$164k – $217k
Listed on the employer's job board (Ashby)
- Staff level role
- Fully remote (Global)
- dbt + Looker stack
- Solar energy industry
- 100% medical premiums
Join Aurora Solar's data team to design trusted data foundations and deliver actionable insights. You will collaborate with Finance, Product, and Go-to-Market stakeholders to transform complex datasets into intuitive reporting solutions. Your work will support the company's mission to accelerate the transition to clean energy through accurate and scalable analytics.
What you'll do
- Design and evolve scalable dbt data models representing key business metrics
- Develop intuitive Looker dashboards for stakeholder decision-making
- Partner with cross-functional teams to translate requirements into analytics solutions
- Collaborate with Data Engineering to ensure reliable and high-quality data pipelines
- Establish best practices for dbt and Looker usage across the organization
- Analyze complex datasets to uncover insights for forecasting and operations
- Scope and execute analytics initiatives that deliver measurable business value
What you'll need
- 4+ years of experience in analytics or analytics engineering using SQL
- 2+ years of production experience with dbt and Looker
- Strong skills in designing and optimizing scalable data models
- Advanced SQL and analytical problem-solving abilities
- Experience leveraging AI tools for analysis and troubleshooting
- Proven ability to own the end-to-end analytics lifecycle
- Excellent communication skills for technical and non-technical audiences
Nice to have
- Experience building forecasting models using Python
- Background in Finance, Revenue Operations, or SaaS analytics
- Familiarity with Snowflake or similar cloud data warehouses
- Experience with Fivetran or similar ELT tools
Stack
- SQL
- dbt
- Looker
- Python
- Snowflake
- Fivetran
How you'll work
- Fully remote position
- Teams located in US, Canada, Poland, and Germany
- Flexible PTO policy
- Company-wide Energize Fridays for recharging
What you get
- 16 weeks parental leave with full base salary
- $500-$750 initial WFH stipend depending on role
- $300 monthly coworking stipend
- Up to $100 monthly connectivity stipend
- $720 annual learning and development budget
- 100% covered medical, dental, and vision premiums