AMS PSR

On behalf of UKRI, we are looking for a Data Modeller (Inside IR35) for a 6 Months contract based Hybrid/ in Swindon/London.

UK Research and Innovation (UKRI) is the national funding agency investing in science and research in the UK.

UKRI invests £8 billion of taxpayers’ money each year into research and innovation and the people who make it happen. They work across a huge range of fields – from biodiversity conservation to quantum computing, and from space telescopes to innovative health care. They give everyone the opportunity to contribute and to benefit, bringing together people and organisations nationally and globally to create, develop and deploy new ideas and technologies.

As a Data Modeller, your main responsibilities will be:

• Collaborate with stakeholders and business users to gather and document business requirements for data warehouse projects.
• Translate business requirements into technical specifications, ensuring alignment with data warehouse architecture and design principles, in particular Kimball DWH methodology. 
• Conduct thorough data analysis to identify gaps, inconsistencies, and quality issues in existing data sources. Design and develop dimensional data models within the enterprise data warehouse project, ensuring optimal performance, data integrity, and scalability.
• Develop and maintain data mappings, data dictionaries, and data lineage documentation. Work closely with enterprise architects, developers, testers, and database administrators to implement designed data warehouse solutions, ensuring adherence to best practices. 
• Perform data profiling and mapping to guide data integration and migration activities. Support user acceptance testing and provide support during the implementation and deployment of data warehouse solutions.

Essential:

• Experience designing physical data models in enterprise data warehouse solutions. 
• Experienced Data Modeller using modelling tooling.
• Strong understanding of database design using Kimball methodologies and proficiency in SQL.
• Experience with data querying and visualisation tooling including Talend Data Studio and Tableau.
• Strong problem solving skills & Familiarity with Agile methodologies.

Please be aware that this role can only be worked within the UK and not Overseas.

Disability Confident 

As a member of the Disability Confident Scheme, UKRI guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

Armed Forces Covenant 

UKRI guarantees to interview veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".