Skip to content

Analytics Engineer

Strada Education Foundation LogoStrada Education Foundation
View Organization

Salary

Salary: $90,000 - $110,000 a year

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

‌