Data Analytics Engineer (Azure Synapse and Power Platform) 2023

King and Moffatt Building Services and The School of Engineering and the Built Environment at Birmingham City University (BCU) are looking to appoint a Data Analytics Engineer (Azure Synapse and Power Platform) Knowledge Transfer Partnership Associate to work on on a 24-month project.

King and Moffatt Building Services is an award-winning Mechanical & Electrical Contractors. Recently, the company is planning to apply the latest digital technology to transform the business, and improve productivity and performance.

The role

The graduate known as the Knowledge Transfer Partnership (KTP) Associate role presents a unique and exciting opportunity to work in collaboration with leading academics at BCU to apply knowledge and technical innovation, delivered on site at the company. The KTP Associate should have a minimum 2.1 University qualification and graduated within the last five years and hold at least an undergraduate degree in a relevant subject area.

This position forms part of the Knowledge Transfer Partnership (KTP) programme co-funding by a grant through Innovate UK. It is essential you understand how KTP works with business and the University, and the vital role you will play if you successfully secure this position. KTPs offer a wide range of benefits including access to a £4,000 Personal Development budget to upskill during the project. For more information on KTP please go to h ttps://bcuadvantage.co.uk/innovate/ktp/

When invited for interview, candidates should be prepared to explicitly and effectively explain how their skill-set and goals meet with the requirements described for the position.

Location and reporting

This Knowledge Transfer Partnership (KTP) Associate position will be based at Courtyard One, Coleshill Manor, Birmingham, B46 1DL (or 2 Venture Court, Broadlands, Wolverhampton, WV10 6TB). The Associate will lead on the technical development of the project, supported by academics from BCU’s Faculty of Computing, Engineering and the Built Environment.

The 24 month project is expected to start within August/September 2023

Goal and objectives

The goal of the successful candidate is to develop a web-based innovative project analytics tool, called DATA-KAM (Data Analytics Tool for King and Moffatt) to building data analytics to improve estimating, and supervision of progress.

The KTP will transform the management of operations, improving productivity, performance, margins, and increasing growth through winning more contracts, through the integration of the company’s management systems, developing company wide KPIs and information dashboards for key management.

Key objectives

• Design and deliver high-performance, scalable, secure, and cost-effective analytics solutions using Azure Synapse Analytics
• Solve issues with data siloes, performance limitations, and complex security requirements
• Take advantage of unlimited concurrency, performance optimisations, centralised security and a unified workspace
• Create rich ETL pipelines and analyse data in the language of your choice at scale using both serverless and dedicated resources
• Streamline pipeline development by easily constructing ETL and ELT processes code-free in an intuitive environment or writing your own.
• Orchestrate data integration by facilitating seamless collaboration through integrated Apache Spark and SQL engines all while using your preferred language such as T-SQL, or .NET
• Automate protection of sensitive data in real time with column-level and row-level security and dynamic data masking
• Generate data-driven insights using Power BI integrating the company’s information systems in a single source
• Build custom apps using Power Apps
• Automate organisational processes using Power Automate

The skills developed in this project will support K&M to monitor progress on site using data analytics and visualisation. The recruited Data Analytics Engineer (Azure Synapse and Power Platform) is expected to develop their discipline-specific knowledge of information management for building services works. This role is a steppingstone for an enthusiastic candidate to develop a leading role in information management for K&M.

About you

You should have a good first degree and post-graduate degree in computing, software engineering, or computer science, or a related discipline, excellent programming skills, and great communication skills and experience of successfully working as part of a team. We expect the post holder to have the following technical knowledge and personal skills.

Technical knowledge

Essential

• Advanced skills in Power Bi. Power Automate and Power Apps
• Experience with Azure Synapse Analytics
• Strong data analytical and visualisation skills
• Excellent problem-solving skills
• Minimum 2.1 and ideally Masters degree in Computer Science, Data Science or a related field (e.g., artificial intelligence)
• Demonstrable knowledge of the software development and software engineering, techniques, and statistics used in computational data analytics
• Demonstrable experience with the following technologies: web development languages and frameworks (i.e. React), SQL, Python, databases or graph databases
• A good understanding of IT systems development and analytics & experience in managing data from different sources.

Desirable

• Strong experience in Semantic web technologies and formats (at least: RDF, OWL, SPARQL) for addressing heterogeneous system interoperability
• Experience with Triple Stores (GraphDb, Virtuoso) and/or Property Graphs (Neo4J)
• Practical working experience of the construction industry is preferably including collaborations with development teams Business management experience is preferable
• Building information modelling experience is preferable

Personal skills

Essential

• Excellent communication skills and should be willing to actively and effectively communicate between a range of specialists.
• Effective interpersonal skills to establish good working relationships with colleagues, stakeholders and industrial partners will be essential.
• Ability to develop knowledge and skills in research methods and data analysis techniques.
• Willingness to take ownership of the project, developing skills in financial, project management, multidisciplinary working, etc.
• Excellent communication, time management and problem-solving skills and be confident in dealing with clients. Client management means critical and creative thinking capability so they need to be open, friendly and adaptable.
• Enthusiastic, self-motivated and able to take a proactive role that will successfully deliver the work plan in the proposal. Report writing and ability to give presentations at different levels of understanding

Desirable

• Willingness to learn new technologies independently and look for solutions Ability to breakdown a substantial assignment into manageable tasks
• Self-critical and pragmatic in resolving problems throughout the project period
• Work independently and report development in regular meetings with project supervisor and academic team

Interviews will take place week commencing 24 th July 2023

Company outline

Located in a modern £300m city centre campus in the heart of Birmingham, the School of Engineering and the Built Environment at Birmingham City University is a thriving, vibrant, and inspiring learning community committed to excellence in research, high quality teaching and impactful industrial engagement.

King & Moffatt is a growing M&E Contractors who have been in business for over 40 years, operating throughout Ireland, the United Kingdom and Mainland Europe, with an annual turnover in the region of €120 million. K&M aims to provide clients with a complete electrical and mechanical service, from design stage to the installation and the ongoing maintenance of their facilities.

The company has expertise to aid clients in reducing their energy consumption, carbon footprint and overall operating costs.

About us

At Birmingham City University we are proud to be an equal opportunities employer. All staff are expected to understand and enact the University’s commitment to ensuring equality, diversity and inclusion in our employment practice and in all that we do . This commitment is enshrined in our Core Values and is detailed in our Equality, Diversity and Inclusion in Employment Policy.

The University values and celebrates the diversity of our staff and students; we welcome people from the many different backgrounds and life experiences that reflect the students and the citizens we serve. We are committed to equality of opportunity for all staff and actively encourage unique contributions, in particular from under-represented groups in respect of age, disability, sex, gender or gender identity, ethnicity, race, religion or belief, sexual orientation or transgender status

Birmingham City University ('BCU') is committed to protecting your personal data and being transparent about what we do with your personal data. One of the ways we do this is through our privacy notices.