AllShore Talent is hiring a Data & Analytics Engineer to build and optimize data pipelines, ensure data accuracy, and develop insightful dashboards. You’ll focus on education data systems to help schools track student engagement and outcomes, working primarily with Canvas LMS, Salesforce, Snowflake, and Tableau. This role is part of our mission-driven team focused on improving educational outcomes through data, technology, and deep school partnerships.
What You'll Do
- Develop a deep understanding of the current data infrastructure and integrations between Canvas LMS, Salesforce, Snowflake, and Tableau.
- Support the ongoing development and maintenance of dashboards and insights for the current school year.
- Create and maintain data relationships across relevant tables, ensuring accurate field mapping.
- Add new data sources to Tableau Cloud as needed to support reporting requirements.
- Write and optimize SQL queries in Snowflake to define required data sets.
- Schedule and manage automated refreshes for data queries to ensure data timeliness.
- Validate calculated fields and visualizations to ensure accurate representation of desired data points.
- Optimize dashboard performance and load times, identifying and resolving bottlenecks.
- Build new worksheets and dashboards aligned with provided specification documentation.
- Test and validate all metrics and visualizations for accuracy and consistency.
- Design dashboard layouts in alignment with brand and style preferences.
- Analyze the existing Snowflake data architecture, focusing on how Canvas-related data is sourced, modeled, and refreshed.
- Review Canvas Data 2 capabilities, endpoints, and schemas to identify optimal integration strategies.
- Design a proof of concept or technical framework for ingesting Canvas Data 2 into Snowflake (or an equivalent data warehouse), including data ingestion frequency, error handling, and schema mapping.
- Support the development of a comprehensive migration roadmap, outlining technical requirements, costs, risks, dependencies, and implementation timelines.
What We're Looking For
- Advanced proficiency in SQL, including CTEs, window functions, and query optimization.
- Strong understanding of data modeling concepts (star and snowflake schemas) for managing longitudinal student data.
- Hands-on experience building and maintaining ETL/ELT pipelines.
- Experience with Python or R for data transformations, automation, and API interactions.
- Knowledge of data warehousing in Snowflake, including schema design and performance optimization.
- Proficiency in dashboarding tools such as Tableau, Power BI, or Looker.
- Ability to translate education data into actionable metrics (e.g., attendance, assessment performance, engagement) for diverse audiences.
- Strong understanding of FERPA, data privacy, and PII protection standards.
- Experience implementing monitoring and alerting systems for data freshness, completeness, and anomaly detection.
- Proven expertise integrating multiple education data systems (SIS, LMS, assessment platforms) using REST or GraphQL APIs.
- Experience with secure credential management and API authentication flows.
Technical Stack
- SQL
- Snowflake
- Tableau
- Python
- R
- REST APIs
- GraphQL APIs
Work Mode
This is a 100% remote position open exclusively to candidates located in Latin America (LATAM).
AllShore Talent is an equal opportunity employer.
