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
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