Senior Analytics Engineer

Summary

Join Brightwheel's Analytics team as a Senior Analytics Engineer and build and maintain the data layer for our analytics stack. You will be responsible for writing SQL in DBT to create data models, collaborating with business users and data analysts, working with engineers to improve data structures, and improving organizational capacity by owning data discovery tools. This role requires strong SQL, DBT, and data modeling skills, along with experience in data discovery and analytical skills. You'll need a proven track record of requirements gathering and documenting data models. Brightwheel offers a competitive compensation package, including base salary, equity, and benefits such as premium medical, dental, and vision benefits, generous paid parental leave, flexible PTO, a wellness stipend, and a Learning & Development stipend.

Requirements

• 4+ years of work experience as an analytics engineer, data engineer, data analyst or DBA
• 2+ years of advanced SQL scripting, within a version controlled repository
• Demonstrated ability to refactor complex SQL queries to optimize performance
• 1+ years of coding in dbt
• Excellent data discovery and analytical skills to manage complex business data requirements and data platforms without much guidance
• Strong communication skills with both business and technical stakeholders
• Track record of requirements gathering, solutioning and documenting data models
• Strong understanding of data quality and testing methodologies
• Experience monitoring and/or troubleshooting ETL pipelines within Airflow / Python

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
• Collaborate with business users and data analysts, designing and building data models that unlock their data discovery and analyses
• Work with engineers to understand existing, complex data models and implementing new, simpler 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 process, especially for non-technical users
• Troubleshoot, improve and scale existing data models and reports
• Apply software engineering practices like version control, automated testing, documentation, code review and continuous integration to our data stack

Preferred Qualifications

• 2+ years experience building data models with dbt in a cloud based data warehouse platform
• Experience with deploying DBT data models with CI/CD and automated testing
• Building data warehousing from large scale transactional data stores and 3rd party systems
• Experience building product usage data models and defining product metrics
• Experience modeling and QAing financial data

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