• Analizar y solucionar incidentes y problemas relacionados con datos • Investigar discrepancias de datos y determinar causas raíz • Documentar, comunicar y proporcionar análisis de problemas de calidad de datos • Crear y ejecutar consultas SQL para validación y verificación de datos • Revisar el código de la aplicación e identificar soluciones técnicas o alternativas cuando sea necesario • Monitorear tendencias de datos y comunicar hallazgos y recomendaciones de manera efectiva • Colaborar con equipos multifuncionales para apoyar las operaciones de producción y solicitudes de cambio • Aplicar mejores prácticas de soporte operativo, incluidos procesos basados en ITIL.

• Develop advanced Excel solutions using formulas, pivot tables, macros, and VBA. • Integrate and consolidate large volumes of data from multiple sources. • Map operational processes and identify opportunities for automation. • Develop, implement, and maintain Robotic Process Automation (RPA) workflows. • Automate repetitive tasks to increase efficiency, improve quality, and reduce errors. • Monitor and continuously improve existing automations. • Support business areas in data analysis and in building solutions that support decision-making.

• Serve as the primary analytics partner for Community Marketing and Client Development. • Help define the analytics roadmap and key measurement priorities for Community programs. • Partner with Community Marketing leadership to prioritize opportunities based on business impact. • Develop hypotheses, business cases, and recommendations that inform strategic decisions. • Lead analyses across advisor referrals, client referrals, COI programs, events, specialty initiatives, advisor-sourced opportunities, and emerging Community programs. • Diagnose performance trends and identify root causes of business challenges and opportunities. • Conduct market-level, advisor-level, and program-level analyses to uncover growth opportunities and performance gaps. • Evaluate lead quality, conversion performance, pipeline contribution, and program ROI. • Translate complex findings into clear, actionable recommendations that influence decision-making. • Own the development, maintenance, and ongoing enhancement of Community Power BI dashboards, executive scorecards, reporting packages, and self-service reporting tools. • Develop scalable reporting solutions that reduce manual effort and increase visibility into Community performance. • Partner with Business Intelligence, Salesforce, and Operations teams to improve data quality, reporting automation, and measurement capabilities. • Identify gaps in tracking, attribution, reporting logic, and operational processes. • Help standardize KPIs, reporting definitions, and performance methodologies across Community programs. • Leverage AI-enabled tools, including Claude, to accelerate analysis, reporting, insight generation, and workflow automation. • Own recurring business reviews, executive scorecards, performance updates, and operating cadences for Community Marketing. • Drive the weekly Community Program Office (PO) process, including agenda development, initiative tracking, status reporting, action item management, and follow-up. • Provide executive leadership with clear visibility into program performance, priorities, blockers, risks, dependencies, and areas requiring support or intervention. • Support quarterly business reviews, annual planning, and strategic planning efforts through reporting, analysis, and recommendations. • Develop forecasts for leads, SQLs, opportunities, pipeline, and revenue. • Establish success metrics and measurement frameworks for Community programs and new initiatives. • Monitor performance, identify optimization opportunities, and partner with program owners to drive improvements. • Support annual planning, goal setting, and performance tracking activities. • Build strong partnerships across Community Marketing, Client Development, Revenue Partner leadership, Salesforce, Operations, and Business Intelligence. • Act as a trusted advisor to Community program owners and leadership teams. • Drive a culture of accountability, measurement, and continuous improvement through data-driven decision making.

• Build and maintain data ingestion, processing, and integration pipelines from multiple sources (educational assessments, school management systems, and public databases such as the School Census and INEP). • Model relational databases and analytical structures that support efficient, scalable queries. • Automate routines for data updating, validation, and quality checks. • Develop and maintain panels, dashboards, and data visualization interfaces for use by education secretariat managers and internal teams. • Translate analytical needs of non-technical users into clear, intuitive visualization solutions. • Iterate on data access and navigation features based on user feedback. • Work closely with the technology team to define data architecture and system integrations. • Document technical processes, database structures, and indicator logic to ensure maintainability and continuity. • Support the specification of technical requirements for new analytical features with vendors or the development team. • Produce exploratory analyses and indicators to inform studies and reports for the monitoring, evaluation, and research (MER) area. • Support the methodological validation of predictive models and learning indicators. • Provide technical support to users of data tools, including training and troubleshooting.