Senior Analytics Engineer
Posted on 1/20/2023
INACTIVE
Locations
United States
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
Data Analysis
Git
R
Snowflake
SQL
Python
Looker
Excel/Numbers/Sheets
Requirements
  • 5 years of advanced analytics experience
  • A passion for full stack data modeling and owning the end-to-end process ensuring data quality with a focus on back-end data modeling
  • Expert in SQL and relational database design
  • Prior experience in design, implementation, and optimization of dbt and Looker models based on business and performance requirements
  • Prior experience with CI/CD pipeline and GitHub
  • Prior experience with Snowflake and S3 Integrations
  • Able to provide ad-hoc data extracts using SQL, Python, R, and Google Sheets
  • Advanced problem-solving skills
  • A can-do attitude towards examining issues, opportunities, and problems, with the ability to work under their own initiative
  • A collective mindset with a proven track record of engaging with multiple stakeholders across different business areas
Responsibilities
  • Own and maintain integration between our tools using best practices to ensure a seamless workflow between Snowflake, dbt, and Looker
  • Own the dbt infrastructure and maintenance in both dbt Cloud and dbt Core
  • Design, build, and improve upon scalable core data models
  • Define and implement engineering best practices including peer code reviews, documentation, and testing to ensure successful deliverables and better team alliance
  • Engage with cross-functional teams to help understand their requirements at a departmental level; help scope and prioritize these requirements to develop analytics programs and projects
  • Create analytics views based on disparate data sets across the commercial functions - sales, marketing, customer success - leveraging business analysts and vendor resources
  • Build a partnership with our infrastructure and engineering teams to help drive best practices and continue to build our data infrastructure
  • Manage and maintain reporting across commercial teams that drive business insights and create actionable next steps
Aurora Solar

201-500 employees

Solar installation & assessment software
Company Overview
Aurora is on a mission to create a future of solar energy for all. Aurora’s cloud-based software transforms solar design, sales, and delivery. With just an address and electric bill, Aurora empowers you to generate a full, accurate, and customizable design for every customer — and close the deal on the spot.
Benefits
  • Medical, dental, & vision plans
  • PTO
  • Fully remote
  • Parental leave
  • Wellness benefits
  • WFH stipends
Company Core Values
  • Build what matters
  • Challenge assumptions
  • Outcome over ego
  • Stay curious. Stay ahead.
  • Power our customers
  • We're in this together