Data Integration Specialist

The Data Integration Specialist designs and implements the technical infrastructure needed to consolidate the schools data into a centralized repository. This role develops and maintains automated data pipelines integrates multiple systems and ensures data is structured for reporting. The specialist also supports the creation of dashboards and visualizations in Looker Studio Power BI or custom web applications enabling stakeholders to make informed decisions.

Responsibilities

• Integrate data from multiple school systems and data pipelines (APIs CSV ETL processes cloud-based tools) reducing manual work and improving accuracy.
• Build and manage automated ETL processes (APIs SQL Python scripts CSV workflows).
• Use Microsoft cloud tools (e.g. Data Factory Power Automate) to streamline and automate and reports delivered in Looker Studio Power BI or custom-built web applications.
• Maintain and enhance data-oriented web applications based on front-end frameworks (e.g. Angular React) and backend development (e.g. Python ).
• Document data structures pipelines and integration standards to ensure long-term sustainability.
• Collaborate with the Systems & Data Admin to validate that technical outputs meet business needs.
• Ensure solutions are cost-effective and appropriate for a K12 international school context.

Qualifications :

Candidates should bring most or all of the following:

• Solid experience in a similar role.
• Experience with relational databases (MSSQL PostgreSQL or similar).
• Ability to design data models and schemas for technical skills in data integration (APIs SQL CSV ETL).
• Proficiency with visualization tools (Looker Studio Power BI).Proficiency with Python for data manipulation and system integration.
• Familiarity with cloud automation tools (Microsoft Data Factory Power Automate).
• Ability to support and maintain custom dashboards and webapps (Azure Python Angular Bootstrap).Use of Git/version control and documentation for maintainability.
• Apply data quality assurance practices: cleaning validating monitoring pipelines.
• Shows humility and confidence.
• Tech positive - see upsides and opportunities in using tech for learning

Additional Information :

Avenues is deeply committed to diversity equity and inclusion throughout our organization. We strive to uphold a culture in which every colleague feels that they belong are trusted and are valued. We welcome applications from candidates of all backgrounds and strongly encourage candidates from traditionally underrepresented communities or groups to apply. Avenues offers competitive compensation and a generous benefits package. 

Avenues upholds the highest standards for safeguarding the physical and emotional wellbeing of children. As an essential aspect of this commitment all offers are contingent upon successful completion of careful reference and background checks. 

Avenues is deeply committed to diversity equity and inclusion throughout our organization. We strive to uphold a culture in which every colleague feels that they belong are trusted and are valued. We welcome applications from candidates of all backgrounds and strongly encourage candidates from traditionally underrepresented communities or groups to apply. Avenues offers competitive compensation and a generous benefits package. 

Avenues upholds the highest standards for safeguarding the physical and emotional wellbeing of children. As an essential aspect of this commitment all offers are contingent upon successful completion of careful reference and background checks. 

Remote Work :

No

Employment Type :

Full-time