Description
At Instructure, we believe in the power of people to grow and succeed throughout their lives.
We're hiring a Senior Analytics Engineer to build data models that teams across Instructure use to run the business. You'll work in dbt and Snowflake daily, collaborating with business leaders to design data that answers their questions. This role supports analytics across Finance, Operations, Product Management, Sales, and other departments.
Responsibilities
- Design, build, and maintain dimensional models in dbt and Snowflake for reporting and analysis.
- Translate business questions into clear data requirements with senior leaders.
- Own the full model lifecycle: source ingestion, staging, testing, documentation, and deployment.
- Set and enforce modeling standards, including naming conventions and testing practices.
- Optimize Snowflake performance and cost through smart materialization and clustering.
- Partner with data engineers and business systems teams to ensure upstream data quality.
- Review pull requests, mentor analysts and engineers, and improve team quality.
- Explain data definitions to non-technical audiences and push back on misleading metrics.
Requirements
- 5+ years of experience in analytics engineering or a similar role.
- Bachelor's degree in Computer Science, Information Systems, Finance, or a quantitative field.
- Hands-on experience with dbt, Snowflake, and advanced SQL.
- Proven experience designing dimensional models and data architecture instincts.
- Ability to converse with directors, VPs, and executives about business issues.
- Strong written and verbal communication.
- Experience with Git-based workflows and CI/CD for data projects.
Nice to Have
- Experience modeling data from CRM and business systems like Salesforce.
- Familiarity with orchestration tools like Airflow or dbt Cloud.
- Experience with BI tools like Tableau, Looker, or Power BI.
- Background in a SaaS or education technology company.
What Success Looks Like
- In 90 days, ship production models and build relationships with partners.
- In 6 months, own a major domain in the data model and earn business trust.
- In a year, shape modeling standards and improve team efficiency.
Benefits
- Competitive compensation and ownership program.
- Flexible work culture and remote work options.
- Generous time off and comprehensive wellness programs.
- Learning and development resources, including professional development tools and tuition reimbursement.