Analytics Engineer - External Relations - 107164 - Grade 7

Location: University of Birmingham, Edgbaston, Birmingham UK

Full time starting salary is normally in the range £36,636 to £46,049 with potential progression once in post to £48,822

Grade: 7

Full Time, Fixed Term contract up to September 2027

Our offer to you:

• People are at the heart of what we are and do.
• The University of Birmingham is proud to have been a part of the City of Birmingham and the wider region for over 100 years, and we are equally proud to be recognised as a leading global university.
• We want to attract talented people from across the city and beyond, support them to succeed, and celebrate their success.
• We are committed to helping the people who work here to develop through our sector-leading Birmingham Professional programme which provides all professional services staff with development opportunities and the encouragement to reach their full potential.
• With almost 5,000 professional services jobs in a wide range of functions in Edgbaston and in our campus in Dubai, there are plenty of opportunities for you to be able to develop your career at the University.
• We believe there is no such thing as a typical member of staff and that diversity is a source of strength that underpins the exchange of ideas, innovation, and debate.
• We warmly welcome people from all backgrounds and are committed to fostering an inclusive environment where diversity is at the heart of who and what we are, and how we work.
• Supporting our people to achieve a healthy work/life balance is important both to our employees and to the success of the University and, depending on the role, we offer a variety of flexible working arrangements.
• We therefore welcome discussions on all forms of flexible working.
• In addition, you will receive a generous package of benefits including 40 days paid holiday a year, one paid day a year for volunteering, occupational sick pay, and a pension scheme.
• We also have three high quality subsidised day nurseries.
• The University is situated in leafy Edgbaston and there are excellent transport links to our beautiful campus, including main bus routes and a train station on site.
• On campus we have a state-of-the-art sports centre with pool, shops, places to eat and drink, our own art gallery, museum and botanical gardens.

External Relations is the division responsible for delivering the University of Birmingham to the world and prides itself in seizing opportunities that will enhance the profile and reputation of the University. We communicate with many different audiences to build purposeful relationships internally, locally, nationally, and internationally. We enable those who wish to apply to study here to make informed choices.

Role Summary:

We require an experienced Analytics Engineer to join a maturing project and steer the next crucial stage of its delivery. The primary focus of the role is to ensure our Dynamics data is captured and modelled in Snowflake to meet our business requirements, working with colleagues from IT Services and the Business (including permanent, fixed term and contract staff). This is a hybrid role requiring an average of three days on campus each week.

Main Duties:

• Develop an understanding of the enquirer and applicant journeys and how they are captured in our data.
• Collect business requirements and ensure that they are met.
• Work with colleagues to create, enhance, test and maintain the dataflows that support our recruitment, admissions, analysis and insight functions.
• Work closely and constructively with colleagues in Admission, Student Recruitment and IT Services, including the Dynamics product team.
• Take a leading role in development of data models in Snowflake, ensuring compliance with institutional data governance.
• Contribute to development of data lakes and the data warehouse, leading where appropriate.
• Prepare datasets for inclusion in PBI reports.
• Act as a bridge between IT/BI specialists and data users in the business.
• Balance short and long-term priorities in a changing systems environment.
• Apply Agile Scrum techniques, leading meetings where required.
• Promote equality and value diversity, acting as a role model and fostering an inclusive working culture.
• Support the University’s sustainability agenda through resource efficient working.
• Any other duties commensurate with the grade.

Required Knowledge, Skills, Qualifications, Experience:

• Strong understanding of the principles of database systems, data warehouses, ETL processes, APIs and data analytics.
• Excellent organisational and time-management skills with real attention to deadlines and detail.
• Ability to prioritise and consolidate stakeholder requirements.
• Ability to work effectively under pressure and deliver to targets.
• The resilience to deal with and work around the limitations of legacy systems, and to adapt as systems change.
• Excellent communication skills to ensure understanding between technical and non-technical colleagues.
• Experience of MS Dynamics or a similar CRM system.
• Experience of Snowflake or similar.
• Proficiency in SQL and Python.
• Experience of dbt or similar.
• Experience of Git.
• Experience of leading technical colleagues.
• Educated to Degree level (or equivalent qualifications) or relevant technical qualification and considerable relevant experience.
• Where no equivalent qualification is held, significant practical relevant experience and expertise in a series of more demanding roles will be required demonstrating the conceptual understanding required.
• In depth up to date specialist understanding and experience in a relevant scientific, technical or IT specialism.
• Evidence of literacy and numeracy.
• Knowledge of the protected characteristics of the Equality Act 2010, and how to actively ensure in day to day activity in own area that those with protected characteristics are treated equally and fairly.

Use of AI in applications:

We want to understand your genuine interest in the role and for the written elements of your application to accurately reflect your own communication style. Applications that rely too heavily on AI tools can appear generic and lack the detail we need to assess your skills and experience. Such applications will unlikely be progressed to interview.

We believe there is no such thing as a 'typical' member of University of Birmingham staff and that diversity in its many forms is a strength that underpins the exchange of ideas, innovation and debate at the heart of University life. We are committed to proactively addressing the barriers experienced by some groups in our community and are proud to hold Athena SWAN, Race Equality Charter and Disability Confident accreditations.

We have an Equality Diversity and Inclusion Centre that focuses on continuously improving the University as a fair and inclusive place to work where everyone has the opportunity to succeed. We are also committed to sustainability, which is a key part of our strategy.