Brightwheel is hiring a
Lead Analytics Engineer

Summary

Join Brightwheel as a remote Analytics Engineer to build out a foundational data environment that can scale beyond ad-hoc analytics to automated reporting, advanced analytics, experimentation, and eventually data science. The role requires 6+ years of work experience in analytics engineering, data engineering, or data analysis, with strong SQL scripting skills and experience with dbt.

Requirements

• 6+ years of work experience as an analytics engineer, data engineer or data analyst
• 4+ years of advanced SQL scripting, within a version controlled repository, with a demonstrated ability to refactor highly complex SQL queries to optimize performance
• 3+ years of coding in dbt or similar transformation tools

Responsibilities

• Build and maintain the data layer for our analytics stack, top to bottom
• Write SQL in dbt to build robust, extensible, and performant data models in a cloud-based data warehouse that will drive business intelligence for the company
• Work alongside business users and data analysts, designing and building data models that unlock their data discovery and analyses
• Work with engineers to understand existing data models and implementing new data structures to unlock business insights and data comprehension for all
• Improve organizational capacity by owning data discovery and cataloging tools that create visibility into business processes, especially for non-technical users
• Troubleshoot, improve and scale existing data models and reports

Preferred Qualifications

• 3+ years experience with data warehouse cataloging with proven ability to deliver end-to-end visibility and maximize the value of data
• 2+ years experience building data models with dbt in a cloud based data warehouse platform

Benefits

• Premium medical, dental, and vision benefits
• Generous paid parental leave
• A flexible paid time off policy
• A monthly wellness and productivity stipend
• A Learning & Development stipend