Data Integration Specialist

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 1100 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 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 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 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.