Data & Reporting Analyst

The Data & Reporting Analyst designs, develops, and optimizes reporting and analytics solutions to ensure stakeholders have access to clear and accurate insights. The role ensures that data is effectively transformed into scalable dashboards and analytical outputs, supporting both operational and strategic decision-making across the federation.

Tasks and Responsibilities

1. Reporting & Data Visualization

• Design, develop, maintain, and improve dashboards and reporting solutions using Power BI and related tools

• Translate business requirements into clear, user-friendly visualizations that support operational and strategic decision-making

• Implement reporting standards to ensure consistency, usability, and quality across reporting solutions

2. Data Modelling & Performance Optimization

• Build and optimize data models (e.g. relationships, measures, filtering logic) for high-performing and scalable reporting solutions

• Develop and maintain advanced calculations and logic (e.g. DAX measures) to support accurate and meaningful analysis

• Monitor and continuously improve dashboard and report performance

3. Data Integration & Governance

• Lead the integration and transformation of data from multiple sources (e.g. databases, ERP systems, external data) into reporting solutions

• Collaborate with ICT and data teams to implement and maintain efficient data pipelines and structures

• Ensure reporting solutions comply with federation-wide data architecture, governance standards, and data quality requirements

4. Data Analysis & Insights Generation

• Conduct advanced analytical and statistical analysis to identify trends, patterns, and insights

• Translate complex datasets into insights for programme improvement, strategy, and donor reporting

• Ensure analytical outputs are understandable by non-technical audiences while maintaining statistical rigor

5. Innovation & Strategic Development

• Contribute to the development of new reporting and analytics solutions, including AI-supported tools and approaches

• Identify opportunities to improve efficiency, automation, and scalability of reporting processes

• Integrate additional datasets (e.g. finance, fund development, external data)

• Stay up to date with emerging trends in data analytics, visualization, and business intelligence

6. Stakeholder Engagement

• Support senior leadership, programme teams, and other stakeholders by providing clear reporting outputs and analysis that inform decision-making

• Support junior analysts, fostering best practices in analytics and reporting

• Coordinate cross-functional collaboration to ensure alignment of reporting solutions with organizational priorities

• Communicate complex analytical concepts clearly to technical and non-technical audiences

Responsibilities to Uphold Safeguarding (standards) and Promote a Safe Environment

As someone working for or on behalf of SOS Children's Villages, you are responsible for helping to create and maintain a safe and protective environment for staff, as well as for the children, young people, and adult programme participants supported and cared for by SOS Children's Villages. You are expected to:

• Commit to the Code of Conduct and reflect on the safeguarding implications of your work on an ongoing basis.

• Actively participate in team discussions to identify risks and share and apply preventative and mitigation measures and strategies.

• Integrate safeguarding principles into your daily decisions and tasks.

• Report any safeguarding concerns promptly and in line with procedures.

• Promote values-based culture, accountability and zero tolerance of harm., * Global collaboration and communication - Working effectively across countries, cultures, and time zones by maintaining clear communication, transparency, and shared understanding within distributed teams.

• Cross-functional collaboration - Working closely with colleagues across different functions and areas of expertise to combine knowledge, solve problems collectively, and deliver meaningful outcomes aligned with the organisation's mission.

• Effective collaboration within matrix structures - Working constructively within solid and dotted reporting lines by maintaining open communication, aligning priorities with both line and functional managers, and ensuring clarity on roles, responsibilities, and expectations to support coordinated delivery across teams.

• Flexibility and adaptability - Remaining responsive to evolving contexts and adjusting priorities, approaches, and ways of collaboration as projects, services, or organisational demand evolve.

• Ownership and accountability - Taking responsibility for advancing tasks and initiatives, proactively addressing obstacles, and ensuring that commitments, decisions, and actions are carried through to completion, taking initiative within your scope of responsibility rather than waiting for direction.

• Strengthening member associations and their autonomy - Ensuring that knowledge, tools, and lessons from projects and services are shared with member associations so they can learn from the work carried out and progressively strengthen their capacity and independence.

• Continuous feedback and transparency - Contributing to a culture where feedback and data are shared openly and constructively, enabling teams and stakeholders involved to reflect, learn, and continuously improve their work and impact.

What We Stand For

SOS Children's Villages is committed to creating and maintaining a caring and protective environment, which promotes its core values, and prevents and addresses child abuse and exploitation. We strongly condemn all forms of child abuse and exploitation, be it within or outside of our organization, and always respond to any case of proven, alleged or attempted abuse within our sphere of influence according to its nature. Efforts ensure that mechanisms are in place to raise awareness, aid prevention, encourage reporting and ease response. They range from human resource development actions such as training and counselling to measures such as suspension, dismissal, and legal action.

SOS Children's Villages is committed to creating and maintaining a safe working environment for our staff, the children and young people and the communities that we work for. The organization prohibits harassment, exploitation and abuses by or of any employee, supervisor, manager, child, young people, community, contractor, applicant, or other individual with whom SOS Children's Villages employees come into contact by virtue of their work. All employees are expected to carry out their duties in accordance with our prevention and protection against Sexual Harassment, Exploitation and Abuse policy.

Do you have a Master's degree?, * Master's degree in Business Informatics, Statistics, Economic or Data Analytics, or related field, or Bachelor's degree with significant experience

• 5-10 years of experience in data analytics, business intelligence, or reporting roles

• Extensive experience creating and maintaining dashboards and reports using Power BI

• Strong experience with SQL, relational databases, and integrating large datasets from multiple sources

• Experience with translating complex data into insights for strategic decision-making

Technical Skills Required

• Power BI (or equivalent) - Advanced: data modelling, DAX measures, dashboard design, report development, and performance optimization

• SQL and databases - Advanced: querying, data transformation, relational databases, and integration from multiple sources

• Data analysis - Advanced: descriptive statistics, trend analysis, segmentation, data validation, and interpretation of results

• Requirements and workflow management - Intermediate: documenting requirements, tracking tasks and issues, maintaining backlogs, and supporting workflow coordination using Jira or equivalent tools

Desired

• Statistical methods and tools - Basic: e.g. regression, clustering, forecasting, and hypothesis testing, using Python, R, or similar tools; openness to AI-supported tools

• Data integration / ETL / ELT - Basic: data pipelines, transformations, and integration concepts, e.g. Databricks

• Cloud-based data platforms - Basic: Azure, Databricks

Other competencies and soft skills

• Analytical thinking to design and drive reporting solutions

• Problem-solving mindset to address complex data and reporting challenges

• Collaboration to work effectively with ICT, programme, finance, and external partners

• Stakeholder engagement and communication (Desired)

• Knowledge of development sector and programme needs to contextualize reporting solutions (Desired), Successful candidates will have to submit a criminal record certificate, current within the last three years. In accordance with the organisation's child protection policy, these positions will be subject to criminal record checks.

SOS Children's Villages, founded in 1949, is the world's largest non-governmental organization focused on supporting children and young people without parental care, or at risk of losing it. Child neglect, abuse and abandonment are everywhere. Families are at risk of separation. Locally led, we work in more than 130 countries and territories to strengthen families who are under pressure so they can stay together. When this is not in a child or young person's best interests, we provide quality care according to their unique needs. Together with partners, donors, communities, children, young people and families, we enable children to grow up with the bonds they need to develop and become their strongest selves. We speak up for each child's rights and advocate for change so all children can grow up in a supportive environment. They contribute to the leadership of SOS Children's Villages International (CVI) including enabling sound budgeting and financial management by leaders and managers in the two units: FCS (Federation Secretariat) and IDS (International Development Support).