Data Integration Specialist

Avenues The World School; São Paulo; Presencial; BRL 60.000 - 90.000; Tempo integral

Resumo da oferta

An innovative educational institution located in São Paulo is looking for a Data Integration Specialist to design and implement technical infrastructure for consolidating data. The role involves developing automated data pipelines and supporting dashboard creation in tools like Looker Studio and Power BI. The ideal candidate should have solid experience in data integration, proficiency in visualization tools, and knowledge of cloud automation. A commitment to diversity and a commitment to safeguarding children's wellbeing are core values of the organization.

Serviços

Competitive compensation

Generous benefits package

Qualificações

• Solid experience in a similar role.
• Strong technical skills in data integration.
• Ability to support and maintain custom dashboards and webapps.

Responsabilidades

• Integrate data from multiple school systems into a centralized repository.
• Maintain and manage automated ETL processes.
• Document data structures and pipelines for sustainability.

Conhecimentos

Data integration (APIs, SQL, CSV, ETL)

Proficiency in visualization tools (Looker Studio, Power BI)

Python for data manipulation

Cloud automation tools (Microsoft Data Factory, Power Automate)

Front-end frameworks (Angular, React)

Descrição da oferta de emprego

Company Description

Welcome to Avenues São Paulo! Since our doors opened in August 2018, we’ve been on a mission to provide a truly transformative educational experience. Through immersive English language learning and dynamic interdisciplinary projects, we prepare our students to become future worldwise leaders uniquely equipped to understand and solve global‑scale problems. As part of the Nord Anglia Education network, we’re proud to stand alongside Avenues New York, shaping the future of education together. With a vibrant community of over 1,100 students, ranging from as young as 18 months old through to graduation, our campus buzzes with a culture of innovation, creativity, collaboration, and state‑of‑the‑art technology. Join us as we embark on a journey of lifelong learning and growth and discover why there’s no place quite like Avenues São Paulo.

Job Description

The Data Integration Specialist designs and implements the technical infrastructure needed to consolidate the school’s 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 spreadsheets. Automated 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 workflows. Dashboards 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 or .NET).
• 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

• Solid experience in a similar role.
• Experience with relational databases (MSSQL, PostgreSQL, or similar).
• Ability to design data models and schemas for reporting. Strong 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 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.