BI Reporting Manager
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 transformations and actions
- 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 any country where MSI operates.
Full-time: 35 hours a week, Monday to Friday (UK contracted hours).
Contract type: 12 month fixed term contract.
Salary: £40,000 - £44,000 per annum for UK based candidates. Discretionary bonus + benefits. For all other locations, the role will be banded within national context.
Salary band: BG 9
Please see the job description
Closing date: 2nd May 2024 (midnight GMT+1). 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.
Other details
- Job Family MSI
- Job Function Non-Clinical
- Pay Type Salary
- 1 Conway St, Fitzroy Square, London W1T 6LP, UK