BI Reporting Manager

About Us

MSI Reproductive Choices is one of the world’s leading providers of sexual and reproductive healthcare. We believe that everyone should have the right to choose. From contraception to safe abortion and life-saving post-abortion care, we are committed to delivering compassionate, affordable, high-quality services for all.

Today, our organisation has over 9,000 team members working in 37 countries across the world. Our success lies in the fact that MSI teams are locally led, entrepreneurial and results-driven, and are passionate about delivering high quality, client-centered care in their own communities. As a social business, we focus on sustainable delivery, efficiency, and funding models that are built to last, so that the women and girls we serve today will have a choice in the future too.

We know that access to reproductive choice is life changing. For some, it can mean the ability to complete an education or start a career. For others, it means being able to look after the family they already have. For everyone, it means the freedom to decide their own future, creating a fairer, more equal world.

About the Role

MSI is in the process of rolling out a Global Data Warehouse (GDW) using the Microsoft Modern Data Warehouse (MDW) suite of applications, principally Azure Synapse, Azure Analysis Services, Azure Data Factory, Logic Apps, Power Apps and Power BI. The aim is to produce a single repository of global data, and to improve & modernise MSI’s reporting, ensuring it is fit for both Global Head Office and the Country Programmes’ strategies and operating models.

This is a 12-month fixed term role to act as a technical expert within the BI Reporting team on the GDW project. The successful candidate will report into the Project’s technical lead assisting with the design, development and delivery of requirements as prioritised by the Project Board.

About You

We recruit talented, dynamic people with diverse backgrounds and experiences, all united by a belief in our mission and a focus on delivering measurable results. We’re proud to be an equal opportunities employer and are committed to creating a fully inclusive workplace, where everyone feels able to participate and contribute meaningfully. You must be open-minded, curious, resilient, and solutions-oriented, and committed to promoting equality, and safeguarding the welfare of team members and clients alike.

To perform this role, it is essential that you have the following skills:

• Ability to work in a diverse and inclusive environment, respecting and collaborating with all individuals equally, and with a commitment to overcome bias and prejudice. Excellent knowledge of Microsoft’s Modern Data Warehouse suite of applications (chiefly Azure Synapse, Azure Analysis Services and Power BI).
• Proficiency in SQL for data extraction and transformation
• Proficiency in using Python programming
• Good understanding of how BI applications and systems fit into the wider company infrastructure.
• Knowledge of database design and creation principles
• Knowledge of development technologies, especially agile/scrum.
• Ability to analyse and present information to employees from a non-IT background.
• Excellent numerical, analytical and data visualisation skills.
• Effective facilitator – ability to work with a group of stakeholders to identify business needs and wishes.
• Strong attention to detail.
• Good presentation and training skills in all senses (written, verbal, visual etc).

To perform this role, it is essential that you have the following experience:

• Business experience either in a commercial or not-for-profit environment.
• 5+ years’ experience developing BI solutions, some of which was using Microsoft’s Modern Data Warehouse suite of applications
• Experience in implementing PySpark transformation and action
• Experience in establishing and managing on-premises data connections, between on-premises databases and cloud-based environments.
• Knowledge of data gateway configurations to facilitate seamless communication between on-premises and cloud data sources.
• Experience of training system administrators to maintain solutions
• Experience of training end users to use solutions
• Experience of working to tight deadlines and managing conflicting priorities

Personal Attributes:

We seek exceptional individuals who are aligned to MSI’s mission and entrepreneurial mindset. You must be a strong communicator, self-motivated and solutions-seeking, committed to driving social change in an environment that measures sustainable results and impact at an individual and global level. You must be able to work effectively with and across diverse teams and be comfortable with ambiguity.

For this role, we’re looking for an individual who is:

• Committed to the protection of team members and clients, with a focus on vulnerable groups.
• Able to role-model inclusive and culturally sensitive attitudes and behaviours.
• Highly committed to the MSI Reproductive Choice Mission “Pro-Choice”.
• Self-starter – looking to build on and improve existing processes, creating lasting change.
• Committed to the protection of team members and clients, with a particular focus on vulnerable groups. Able to role-model inclusive and culturally sensitive attitudes and behaviours.
• Actively seeks feedback on performance with a view to continuously learning and developing as a leader.

For more information about the role, please view the job description and person specification on our website.

Location: London Support Office (hybrid working) or where any MSI country programme operates.

Full-time: 35 hours a week, Monday to Friday (UK contracted hours)

Contract type: 12-month fixed term contract

Salary: £40,000 – £48,000 per annum for UK based candidates. Discretionary bonus + benefits. For all other locations, the role will be banded within national context.

Closing date: 31st January 2024 (midnight GMT). Interviews may take place before this date for exceptional candidates.

For internal employees applying from an MSI country programme, the role will be positioned within the existing salary structure of the country. Local terms and conditions of the country will apply.