InsideTrack Analytics Engineer

We’re looking for a talented Analytics Engineer to join our analytics team! At InsideTrack, we are passionate about student success. We partner with colleges and universities to improve enrollment, persistence, completion and career readiness. Our student support methodology uncovers first-hand feedback about student goals and challenges. Through strategic guidance, staff training and student coaching, we help institutions turn this feedback into actionable insights that drive exceptional student outcomes. As a non-profit organization, our partners turn to us as thought leaders in higher education. We offer these partners access to a comprehensive range of student success solutions as well as the latest research and insights impacting the industry. We’ve proudly supported more than 3.5 million learners since 2001 and currently serve over 380 partners, empowering our partners to uplevel their student success outcomes. Join us and the leading institutions, foundations and others working to bring the transformative power of education to all individuals.

The Analytics Engineer is part of a remote work team that is responsible for real-time business metrics aggregation, data warehousing and querying, schema and data management as well as a number of other analytics infrastructure systems. The incumbent, along with the remote work team, will strive to architect, develop, and deploy world-class data systems to empower every tier of our mission-driven company, as well as build scalable systems that enable self-service access to sophisticated data and analyses.

Essential Job Functions: :
• Design, build, and maintain data models foundational to the company’s internal and client-facing reporting and analytics.
• Investigate bug root causes and implement fixes.
• Design, build, and support a data warehouse for the company’s business.
• Create and support various ELT scripts, jobs, and technologies.
• Tune and optimize data storage technologies.
• Review pull requests and test team member’s code and features.
• Interact with data analysts and power users to define metrics to build data models.
• Collaborate with team members to remove blockers and design new features.
• Function as data expert to advise users on the usage of structured and unstructured data.
• Support APIs, tools, and 3rd party products to extract data from Cloud/SaaS applications.

Education Requirements::
• Bachelor’s degree in Computer Technology, Information Systems or related field (preferred)

Experience Requirements: :
• Minimum of two (2) years of applicable work experience
• Knowledge and experience with data warehousing architecture and data modeling best practices
• Ability to build and optimize data sets and architectures Experience with cloud base data warehousing such as Snowflake
• Ability to clean and transform data for use in analytics and reporting
• Exposure to one or more EL tools and a solid understanding of pipelines; understanding of third-party data integration tools such as Fivetran, Stitch
• Ability to build processes that support data transformation, workload management, data structures, dependency and metadata
• Expert knowledge of SQL
• Experience with dbt
• Excellent analytic skills associated with working on structured datasets
• Care deeply about data quality and governance; able to document data and definitions
• Experience with Github and CI/CD practices
• Experience working in an Agile software development environment that is highly collaborative
• Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement
• Able to prioritize, work independently in a less structured, remote work setting
• Team player and receptive to giving and receiving feedback, with the ability to effectively collaborate with and communicate complex topics to an audience of diverse backgrounds and skills

Experience Preferences::
• Background and experience in higher education
• Experience with Looker and LookML
• Experience with Salesforce Education Data Architecture
• Experience with Infrastructure as code such as Terraform

TYPICAL PHYSICAL & MENTAL DEMANDS: Requires prolonged sitting with some bending, stooping and stretching; eye-hand coordination and manual dexterity sufficient to operate a keyboard, telephone, and other office equipment. Requires sufficient range of hearing and eyesight to record, prepare and communicate appropriate reports on a laptop computer. Also requires moderate to intense concentration due to complexity and/or need to meet deadlines, and flexibility to readily adapt to a changing environment.

We really want to get to know you as a person, and the unique skills and gifts that you can bring to the position. Therefore, we highly encourage you not to use an AI program during the application/consideration process.