Analytics Engineer

Hays Technology are working in partnership with a University based in Birmingham to recruit 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 the Dynamics data is captured and modelled in Snowflake to meet business requirements, working with colleagues from IT Services and the wider business.

What you will be doing

• Develop an understanding of the enquirer and applicant journeys and how they are captured in the data.
• Collect business requirements and ensure that they are met.
• Work with colleagues to create, enhance, test and maintain the dataflows that support 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.

• Strong understanding of the principles of database systems, data warehouses, ETL processes, APIs and data analytics.
• The resilience to deal with and work around the limitations of Legacy systems, and to adapt as systems change.
• Excellent oral and written 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.

Salary up to £46,000 per annum, 40 days leave inclusive of bank holidays and university closure days, hybrid working, generous pension scheme and many other generous benefits or competitive day rate available