Analytics Engineer

At Instructure, we believe in the power of people to grow and succeed throughout their lives. Our goal is to amplify that power by creating intuitive products that simplify learning and personal development, facilitate meaningful relationships, and inspire people to go further in their education and careers. We do this by giving smart, creative, passionate people opportunities to create awesome solutions. And that's where you come in:   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. What you will be doing: 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. What you will need to know/have: 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 Gen in on all the awesome at Instructure: A fun, friendly, and helpful company culture Competitive compensation Restricted Stock Unit Program Private Medicover healthcare + cafeteria plan/SZEP card Employee Stock Purchase Program Wellness motivation through PandaFit An extra week off for the whole company every year Employee recognition program through Motivosity Goal-setting, proactive reviews, and internal training Employee assistance program We’ve always believed in hiring the most awesome people and treating them right. We know that the more diverse we are, the more diverse our ideas will be and when we openly welcome those ideas, our environment is better and our business is stronger.   All Instructure employees are required to successfully pass a background check upon being hired. Apply for this job