Senior Analytics Engineer
Company
Brightwheel
Location
USA
Type
Full Time
Job Description
- 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
- Working alongside business users and data analysts, designing and building data models that unlock their data discovery and analyses
- Working with engineers to understand existing data models and implementing new data structures to unlock business insights and data comprehension for all
- Improving organizational capacity by owning data discovery and cataloging tools that create visibility into business process, especially for non-technical usersÂ
- Troubleshooting, improving and scaling existing data models and reports
- 3+ years of work experience as an analytics engineer, data engineer, data analyst or DBA.
- 3+ years of advanced SQL scripting, within a version controlled repository
- Demonstrated ability in refactoring highly complex SQL queries to optimize performance.
- 2+ 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
- Preliminary experience with monitoring and/or troubleshooting ETL pipelines within Airflow / Python.
- 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
- Experience with deploying DBT data models with CI/CD.
- Building data warehousing from large scale transactional data stores and 3rd party systems.
- Hubspot / Salesforce / Mixpanel (Clickstream data analytics)
- Embedded analytics / BI reporting data models (e.g. looker / cubejs)
- Knowledge of database permissions management
Date Posted
05/15/2024
Views
58
Similar Jobs
Senior Platform Engineer - Infrastructure - Kalepa
Views in the last 30 days - 0
This job posting describes a senior infrastructure engineer role with competitive compensation and equity options The position involves working on clo...
View DetailsSenior Interior Designer (10+ years experience) - CID Design Group
Views in the last 30 days - 0
This job offers a collaborative role in design with opportunities for growth and a positive work environment including benefits like wellness programs...
View DetailsStaff Security Engineer - Modern Health
Views in the last 30 days - 0
This job description highlights a key role in ensuring security and privacy at Modern Health offering impactful opportunities and comprehensive benefi...
View DetailsSenior Sales Trainer - Vonage
Views in the last 30 days - 0
This job description outlines a Senior Sales Trainer role focused on developing sales training programs collaborating with teams and ensuring alignmen...
View DetailsNetwork & Systems Administrator - MetroSys
Views in the last 30 days - 0
This job posting seeks a Network Systems Administrator for fractional IT support requiring expertise in patch management vulnerability assessments an...
View DetailsSales Development Representative - Inspectiv
Views in the last 30 days - 0
Inspectiv seeks a Sales Development Representative to drive growth through outbound outreach and lead generation The role offers competitive compensat...
View Details