Description
Who You Are
Brightwheel is seeking a Analytics Engineer to join the Data Engineering team.
You are passionate about data and possess deep SQL and data modeling skills. You enjoy deep data discovery based on business problems, and want to build scalable data models to enable self-service analytics. You have experience juggling multiple projects with shifting priorities while continuing to deliver value to the business. You are a curious, detail oriented, self-starter who wants to take full ownership of high impact projects with visibility throughout the organization.
Who You Are
Brightwheel is seeking a Analytics Engineer to join the Data Engineering team.
You are passionate about data and possess deep SQL and data modeling skills. You enjoy deep data discovery based on business problems, and want to build scalable data models to enable self-service analytics. You have experience juggling multiple projects with shifting priorities while continuing to deliver value to the business. You are a curious, detail oriented, self-starter who wants to take full ownership of high impact projects with visibility throughout the organization.
What You’ll Do
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 companyWorking alongside business users and data analysts, designing and building data models that unlock their data discovery and analysesWorking with engineers to understand existing data models and implementing new data structures to unlock business insights and data comprehension for allImproving 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
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 repositoryDemonstrated ability in refactoring highly complex SQL queries to optimize performance.2+ years of coding in dbtExcellent data discovery and analytical skills to manage complex business data requirements and data platforms without much guidanceStrong communication skills with both business and technical stakeholdersTrack record of requirements gathering, solutioning and documenting data modelsStrong understanding of data quality and testing methodologiesPreliminary experience with monitoring and/or troubleshooting ETL pipelines within Airflow / Python.
Preferred Experience
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 platformExperience 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
Please mention that you found this job on remotewlb.com. Thanks & good luck!
