Analytics Engineer

Instructure is looking for a qualified Analytics Engineer to join our Enterprise Systems team. Analytics Engineers sit at the intersection of business teams, Data Analytics and Data Engineering and are responsible for bringing robust, efficient, and integrated data models and products to life. Analytics Engineers speak the language of business teams and technical teams, able to translate data insights and analysis needs into models powered by our Enterprise Systems. The successful Analytics Engineer is able to blend business acumen with technical expertise and transition between business strategy and data development.

Responsibilities:

Utilize knowledge of data engineering concepts such as ELT and scripting languages to maintain and / or improve existing data processes
Build robust EL data processes to gather data from various external data sources and store the data in an internal data warehouse or move data between systems
Collaborate with team members to collect business requirements, define successful analytics outcomes, and design data models
Design, develop, and extend dbt code to extend the Enterprise Dimensional Model
Craft code that meets our internal standards for style, maintainability, and best practices (such as the SQL Style Guide) for a high-scale database environment. Maintain and advocate for these standards through code review.
Approve data model changes as a Data Team Reviewer and code owner for specific database and data model schemas
Provide data modeling expertise to Instructure teams through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries in Snowflake.

Requirements:

BS in a technical degree field such as CS, IS, Math, Statistics, or Finance
Positive and solution-oriented mindset
Self-motivated and self-managing, with task organizational skills
3+ years in the Data space as an analyst, engineer, or equivalent
3+ years experience designing, implementing, operating, and extending commercial Kimball enterprise dimensional models
Experience with dbt, AWS, Python, Spark, and Databricks preferred
Experienced in setting up job alerts to address failures, inaccuracies, etc.
Demonstrated capacity to clearly and concisely communicate complex business activities, technical requirements, and recommendations
Demonstrated experience with one or more of the following business subject areas: marketing, finance, sales, product, customer success, customer support, engineering, or people
Able to effectively analyze, review, diagnose, document, and quality check results

Salary: $105,000 - $125,000 a year

‌