Business Intelligence Analyst / Data Engineer - WFH - £45-50K

About the Role

The Business Intelligence Analyst/Data Engineer role is part of the Analytics Integration team that builds and maintains the enterprise data warehouse from the Data Lake.

The role will largely be home based but some travel to Milton Keynes will be required.

 

**Please note this role can be split into 2 separate positions so Data Engineers and BI Analysts may apply**

 

The business 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 digital experience through a test and learn approach.

 

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

 

The role holder(s) will adhere to policies and procedural guidelines and contribute to discussions to improve them when appropriate.

Key Responsibilities

• 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 and built into standard working practices to support making the warehouse as transparent and responsive as possible.
• Maintain documentation to agreed standards.

 

• Systems analysis and development
• In consultation with 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.
• 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 the data that is made available.

 

 

 

• 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.

 

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

 

• Line management of junior staff
• Manage workload and priorities
• Set objectives and identify development needs.

 

  Skills and Experience Education, qualifications and training

Essential

 

• Undergraduate degree (or equivalent) with strong engineering, mathematics or computing elements.

 

Desirable

 

• MS Azure Integration training or similar

Knowledge, work and other relevant experience

Essential

 

• Experience of developing and maintaining data systems to support decision making and management information needs.
• Substantial experience of building an EDW with MS Azure or comparable using industry standard tools for data modelling, data analysis and data flow design.
• Familiarity with prototyping techniques and structured systems development techniques.
• Experience of working in multiple projects management methodologies.
• Hands on experience on Visual Studio, DevOps and TSQL.

 

Desirable

 

• Experience in data analysis tools like Python/R, cloud-based data analytics expertise AWS, Big Data technologies – Hadoop/Spark, Data Viz/BI tools – SAS EG, SAS VA, Tableau, Power BI
• Knowledge of Higher Education sector and data.
• Hands on experience on MPP databases.

 

Personal abilities and qualities

• A self-starter, proactive in reviewing processes and in identifying opportunities for improvement.
• Effective skills in implementing change.
• Able to work under pressure to manage competing demands for time and to meet demanding deadlines.
• Aptitude for careful analysis and systems development.
• Able to provide leadership in developing new approaches to the use of systems to meet information needs.
• Team player.
• Able to offer help and guidance to others on a range of system issues.
• Communication and presentation skills
• Aptitude for careful analysis and systems development.