Instructure Senior Analytics Engineer at Instructure building data models in dbt and Snowflake to support business analytics across multiple functions. Owns full model lifecycle and partners with business leaders.
Responsibilities
Design, build, and maintain dimensional models in dbt and Snowflake that support reporting and analysis across Finance, Operations, Product Management, and other business functions.
Translate business questions into clear data requirements by working directly with senior leaders across the company.
Own the full model lifecycle: source ingestion patterns, staging, intermediate and mart layers, tests, documentation, and deployment.
Set and enforce modeling standards, including naming conventions, grain definitions, slowly changing dimension handling, and testing practices.
Tune Snowflake performance and cost through smart materialization choices, clustering, and warehouse sizing.
Partner with data engineers and business systems teams to make sure upstream data arrives in a shape we can model well.
Review pull requests, mentor analysts and engineers, and raise the quality bar across the team.
Explain data definitions and tradeoffs to non-technical audiences in plain language, and push back when a request would produce a misleading metric.
5+ years of experience in analytics engineering, data engineering, or a similar role.
A bachelor's degree in Computer Science, Information Systems, Finance, or another quantitative field is preferred.
Deep, hands-on experience with dbt, including macros, packages, incremental models, snapshots, and testing.
Strong Snowflake skills, with advanced SQL and a good sense of performance and cost.
Qualification
What success looks likeIn 90 daysIn 6 monthsIn a year
Required
5+ years experience in analytics engineering or similar role
Bachelor's degree preferred in Computer Science, Information Systems, Finance, or quantitative field
Deep hands-on experience with dbt including macros, packages, incremental models, snapshots, and testing
Strong Snowflake skills with advanced SQL and performance tuning
Proven experience designing dimensional models and data architecture
Preferred
Experience modeling data from CRM and other business systems such as Salesforce.
Familiarity with orchestration tools such as Airflow or dbt Cloud.
Experience with a BI tool such as Tableau, Looker, or Power BI.
Background in a SaaS or education technology company.
What success looks like
In 90 days, you've shipped your first production models and built working relationships with partners in several business functions.
In 6 months, you own a major domain in our data model and the business trusts the numbers it produces.
In a year, you've shaped our modeling standards and made the whole team faster.