Business Intelligence Analyst, Data Engineer

This role is part of the Integration team - part of Data Management (DM) team - which builds the enterprise data warehouse from the Data Lake. The OU is going through a vast transformation programme to migrate its data capability to the cloud and build trust in the data as well as to transform the student digital experience through a test and learn approach.

The role holder will have a wide range of technical skills, fully mastering ETL techniques and system analysis using industry standard tools. Additionally, the role holder will manage key stakeholders, collaborate on business solutions and strategic analyses with teams across the university and build customer relationships, to ensure our Enterprise Data Warehouse delivers insight and value.

The role holder will adhere to policies and procedural guidelines and contribute to discussions to improve them when appropriate., Systems analysis and development

• In consultation with other stakeholders, develop and disseminate agreed business rules.
• Analysis required to design efficient and easily maintainable processes delivering an Enterprise Data Warehouse which addresses a wide range of information needs.
• Analysis of business requirements to design and build a data model that will deliver to analytical and reporting products.
• Analysis of source systems and business processes to evaluate the data against the analytical and reporting data requirements.
• Provide coding support to the team, contributing to the development of skills.
• Champion common approaches such as re-usable code, definitions templates, etc. to improve the standardisation and transparency of code.
• Apply appropriate project management and systems development methodologies.
• Investigate new techniques to improve the processing and quality of MI data.
• Ensuring that any data transformations and data models are build meeting the data governance and protection policies.

Systems maintenance

• Maintain and enhance all aspects of the solution focused integration platform.
• Update systems to take account of changes in requirements or operational data and systems.
• Liaise with stakeholders on operational data extracts.
• In collaboration with data management and data governance, ensure tools are in place to help making the warehouse a transparent and responsive source of information and integrate the use of these tools into standard working methods.
• Maintain documentation to agreed standards.

Projects

• Contribute analytical, programming and systems expertise to DSA and collaborative projects.
• Contribute to the delivery of the University's Data Warehouse, specifically in the provision of the integration of data and provision of the enterprise data model.

Future developments

• Identify opportunities and developments of new big data and cloud-based analytics infrastructure capabilities within MS Azure in collaboration with IT and other units, using your expertise in end-to-end processes within the Integration team.

Line management of staff

• Manage workload and priorities.
• Set objectives and identify development needs., You can view your progress and application communications when you are logged into our recruitment system. Please check your spam/junk folders if you do not receive associated email updates.

Do you have experience in Spark?, Do you have a Bachelor's degree?, Essential:

• Substantial data warehousing experience: Designing solutions for business requirements; Understanding data modelling effects on performance. Building, reviewing and optimising warehouse workflows.
• Demonstratable analytical skills: Understanding how to relate business to data. Understanding data quality issues. Identify and resolve issues, perform impact analysis.
• Proven leadership and change management skills: Lead on development. Provide guidance and support to developers.
• Outstanding presentation and interpersonal communication skills: Communicate effectively and clearly to communicate data issues to the business. Able to work under pressure and working well in a team.
• Undergraduate degree with strong engineering, mathematics or computing elements or equivalent.

Desirable:

• MS Azure Integration training or similar.
• Experience of developing and maintaining MI systems to support decision making and management information needs.
• Experience of working within IT release management frameworks.
• Experience in data analysis tools such as Python/R, cloud-based data analytics expertise AWS, Big Data technologies-Hadoop/Spark, Data Viz/BI tools-SAS EG, SAS VA, Power BI.
• Knowledge of Higher Education sector and data.

We are open to discussions about flexible working. Whether it's a job share, part time, compressed hours or another working arrangement. Please reach out to us to discuss what works best for you.

It is anticipated that a hybrid working pattern can be adopted for this role, where the successful candidate can work from home and the office. However, as this role is contractually aligned to our Milton Keynes office it is expected that some attendance in the office will be required when necessary and in response to business needs. We'd expect this to be on average 1-2 times per month. Next steps in the Recruitment process

We anticipate that interviews for this role will be taking place online via Microsoft Teams during the week commencing 8 December 2025. Early closing date notification

The Open University is the UK's largest university, a world leader in flexible part-time education combining a mission to widen access to higher education with research excellence, transforming lives through education. Find out more about us and our mission by watching this short video (you will be taken to YouTube by clicking this link).