Senior Analytics Engineer
Instructure, Inc.6 days ago
Base Salary
$145k - $155k/yr
Responsibilities
- Design, build, and maintain dimensional models in dbt and Snowflake for reporting and analysis.
- Translate business questions from senior leaders into clear data requirements and reliable data solutions.
- Own source ingestion, staging, intermediate, mart, testing, documentation, and deployment workflows.
- Define and enforce standards for naming, grain, slowly changing dimensions, and data testing.
- Tune Snowflake performance and cost through materialization, clustering, and warehouse-sizing decisions.
- Partner with data engineers and business systems teams to improve upstream data quality and structure.
- Review pull requests, mentor analysts and engineers, and improve team-wide data quality.
- Explain data definitions and tradeoffs to non-technical stakeholders and challenge misleading metrics.
Requirements
- At least 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 macros, packages, incremental models, snapshots, and testing.
- Strong Snowflake skills, advanced SQL, and experience with performance and cost optimization.
- Experience designing dimensional models including star schemas, facts, dimensions, and conformed dimensions.
- Strong data architecture knowledge covering layered modeling, grain, lineage, data contracts, and maintainable project structure.
- Working knowledge of business functions such as finance, sales, operations, and product, ideally in a SaaS company.
- Ability to discuss business issues with directors, VPs, and executives and turn them into data solutions.
- Strong written and verbal communication skills, including documentation.
- Experience with Git-based workflows and CI/CD for data projects.
- Experience modeling CRM and other business-system data such as Salesforce is preferred.
- Familiarity with Airflow or dbt Cloud is preferred.
- Experience with Tableau, Looker, or Power BI is preferred.
- Background in a SaaS or education technology company is preferred.
Benefits
- Competitive compensation and participation in the ownership program for full-time employees.
- Remote, hybrid, and in-office work arrangements vary by role, team, and location.
- Generous time off, local holidays, and an annual late-December “Dim the Lights” period based on departmental needs.
- Comprehensive wellness programs and mental health support.
- Learning and development resources, professional development tools, and tuition reimbursement.
- Technology and tools needed to perform the work.
- Motivosity employee recognition program.
- Inclusive culture focused on support and meaningful connection.
- Background checks and identity verification are part of the hiring process.
About Instructure, Inc.
Instructure builds Canvas, a cloud learning management system, along with tools for assessment, video learning, credentials, and analytics for K–12, higher education, and corporate training. It sells these products as SaaS subscriptions with related services. Founded in 2008 and headquartered in Salt Lake City, the company trades on the NYSE and expanded its credentials offering by acquiring Parchment in 2024.