ISP Power BI Developer

Purpose of Role

This role is responsible for creating and reviewing, maintaining, and optimizing existing   reports and data models using Microsoft Power BI.

This role will involve collaborating with stakeholders to bring group-wide performance/progress data to life, ensuring it is fit for purpose against a backdrop of an increasing number of schools and evolving business intelligence requirements. This is a hybrid role, working two days a week from our Wimbledon office.

ISP Principles

Begin with our children and students. Our children and students are at the heart of what we do. Simply, their success is our success. Wellbeing and safety are both essential for learners and learning. Therefore, we are consistent in identifying potential safeguarding and Health & Safety issues and acting and following up on all concerns appropriately.

Treat everyone with care and respect. We look after one another, embrace similarities and differences and promote the well-being of self and others.

Operate effectively. We focus relentlessly on the things that are most important and will make the most difference. We apply school policies and procedures and embody the shared ideas of our community.

Are financially responsible. We make financial choices carefully based on the needs of the children, students, and our schools.

Learn continuously. Getting better is what drives us. We positively engage with personal and professional development and school improvement.

ISP Power BI Developer Key Responsibilities

• Design, develop, and maintain reports and data models in Power BI.
• Ensure data requirements are clearly and consistently defined and understood and the process for doing so is consistent with other business requirements.
• Identify the relevant business processes and associated data sources relevant for meeting data requirements and work with the BI team and Lead Data Engineer to ensure organisational discipline around data capture.
• Create and optimize data models within Power BI to ensure efficient data retrieval and performance, which may involve reviewing and improving existing Power BI data models.
• Create wireframes and lead the design of business intelligence reports and dashboards relevant for end users.
• Ensure that KPIs (Data Points) and reports are well documented and understood by the wider business.
• Ensure data accuracy and consistency through QA and UAT on reports and models developed by third parties.

Skills, Qualifications and Experience

• Degree level in a numerate subject (e.g. Maths, Statistics, Economics, Operational Research or Computer Science) 
• Certified in Power BI Data Analyst Associate – PL300
• 5+ years proven experience in developing Power BI reports. Proficiency in Microsoft Power BI Desktop, Power Query,DAX (Data Analysis Expressions), and Power BI Service.
• Experience of using external Power BI tools such as Tabular Editor and DAX Studio.
• Strong understanding of data modeling and data transformation.
• Experience with data visualization best practices and principles.
• Experience in working in teams using CICD and multiple development environments.
• Experience in setting standards surrounding the use of data to create business intelligence that leads to insight, decision making and action.
• Excellent stakeholder management skills.
• Excellent communication and teamwork skills.
• Experience in collaborating with senior business leaders and functional / regional heads to translate business requirements into tangible data solutions.
• An understanding of SQL/database management.
• Exposure to DevOps and Databricks.
• Experience in creating notebooks/views in Databricks to create datasets that are ready for reporting.

ISP Leadership Competencies

You consistently demonstrate and role-model the ISP Leadership Competencies in all that you do.

1. Collaboration. Takes an active part in leading their school or region; is cooperative and a genuine team player, developing positive, supportive relationships with colleagues to solve problems and maximise opportunities.

1. Learning & Getting Better. Continually demonstrates personal commitment and passion for learning and getting better using evidence and feedback, supporting others in their continual learning, development, and growth.

1. Innovation Leadership. Is good at creating an environment where ideas for learning initiatives and services are generated and is able to motivate and inspire others through the process of creation through to completion.

1. Outcome driven. Can be counted on to find solutions. Is consistently looking to exceed goals and is focused on KPIs.

1. Resilience. Can deal with setbacks and challenges calmly and effectively.

1. Community Focus. Is committed to meeting and exceeding the needs and expectations of our students and their families.

1. Integrity & Ethical Management. Has the ability to work ethically and with integrity; helps others feel valued; upholds and models the ISP Vision, Purpose and Principles.

ISP Commitment to Safeguarding Principles

ISP is committed to safeguarding and promoting the welfare of children and young people and expects all staff and volunteers to share this commitment.

All post holders are subject to appropriate vetting procedures, including an online due diligence search, references and satisfactory Criminal Background Checks or equivalent covering the previous 10 years’ employment history. 

ISP Commitment to Diversity, Equity, Inclusion, and Belonging

ISP is committed to strengthening our inclusive culture by identifying, hiring, developing, and retaining high-performing teammates regardless of gender, ethnicity, sexual orientation and gender expression, age, disability status, neurodivergence, socio-economic background or other demographic characteristics. Candidates who share our vision and principles and are interested in contributing to the success of ISP through this role are strongly encouraged to apply.