What You’ll Do
- As an analytics engineer at Brightwheel, you will be responsible for building and maintaining the data layer for our analytics stack, top to bottom. Part data engineer, part data analyst, and part the connective tissue in-between, your responsibilities will span from raw data, up through cleaned, organized and analyzable data. You’ll apply software engineering practices like version control, automated testing, documentation, code review and continuous integration to our data stack. In a particular week, you will find yourself:
- Writing 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
- Collaborating with business users and data analysts, designing and building data models that unlock their data discovery and analyses
- Working with engineers to understand existing, complex data models and implementing new, simpler 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
Required Qualifications, Skills, & Abilities
- 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.
Preferred Experience
- 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
Similar Jobs
Senior Software Security Engineer
Director, Architecture
Engineering Manager - Applied Intelligence
Software Engineer (Voice Team)
Research Engineer (Must be in UK)
Software Engineer - Solution Integrations (Must be in UK)
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 401 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got about 70,000 jobs from 5,000 vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 5,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say