Senior Data Engineer

### Posting ID
PIP11704

On behalf of the Intellectual Property Office we are looking for a Senior Data Engineer (Inside IR35) for a 12 month contract. Remote working with occasional travel to Newport.

Please note: SC Clearance is an essential requirement for this role, as a minimum you must be willing & eligible to undergo checks. (Please note, due to the exceptional requirements of this position (short-term nature of this role and speed at which we require a postholder in situ) preference may be given to candidates who meet all of the essential criteria and hold active security clearance.)

The Intellectual Property Office (IPO) is the official UK government body responsible for intellectual property (IP) rights including patents, designs, trademarks and copyright. Our ambition is to be the best IP office, and we intend to achieve this by:

- Delivering excellent IP services
- Creating a world leading IP environment
- Making the IPO a brilliant place to work

We operate and maintain a clear and accessible intellectual property system in the UK, which encourages innovation and helps the economy and society to benefit from knowledge and ideas. We help people get the right type of protection for their creation or invention.

We are responsible for:

- IPO Policy
- educating businesses and consumers about IP rights and responsibilities
- supporting IP enforcement
- granting UK Patents, trademarks and design rights

We have a small office in the heart of London, but our main office is on the outskirts of Newport, South Wales.

About us - Intellectual Property Office - GOV.UK (www.gov.uk) .

As a Senior Data Engineer your main responsibilities will be to:

- Design, develop and maintain repeatable SQL-based data migration pipelines to extract data from legacy HR, Payroll and Finance systems.
- Analyse source system data structures and identify appropriate mapping approaches to Workday data conversion templates.
- Create reusable SQL scripts, stored procedures and automation processes that support multiple migration iterations.
- Perform data profiling and analysis to identify data quality issues, anomalies, duplicates and gaps.
- Support data cleansing activities by identifying data quality improvements required before migration.
- Produce and maintain migration documentation including mapping specifications, data dictionaries, transformation rules and reconciliation procedures.
- Develop reconciliation processes to verify migrated data against source system records and agreed control totals.
- Investigate and resolve data-related defects identified during migration testing and validation cycles.
- Collaborate with implementation partners to understand Workday template requirements and resolve data load issues.
- Support multiple mock conversions, test loads and dress rehearsal migrations throughout the programme lifecycle.
- Ensure migration activities comply with organisational security, data protection and governance requirements.
- Contribute to establishing migration standards, controls and audit trails to ensure a repeatable and supportable migration process.
- Provide technical expertise on data extraction, transformation and migration approaches across the programme.
- Be responsible for data enhancements and executing plans that utilise the current toolkit and the skills of the team to deliver these.
- Work with business stakeholders and subject matter experts to define and document data mappings, transformation rules and business assumptions.
- Work closely with our HR and DDaT teams to drive solutions that ensure ease of access to data and help them to work with data more effectively and efficiently.
- Build IPO data pipelines, owning the data engineering artefacts in line with IPO standards.
- Build solutions to move data internal and external to IPO.
- Engage with stakeholders to build relationships and to gain a thorough understanding of key IPO user groups and design decisions .

Essential:

- Extensive experience developing SQL queries, stored procedures, views and SSIS processes within Microsoft SQL Server environments.
- Evidence an ability to design, develop, test and support complex data migration solutions using SQL Server and SSIS.
- Experience of cleansing, preparing and formatting complex data sets.
- Experience extracting, transforming and migrating data between enterprise systems.
- Experience designing repeatable and automated data migration or data integration processes.
- Strong understanding of relational database structures, data modelling and data mapping techniques.
- Experience reconciling migrated data and investigating data quality or data conversion issues.
- Ability to translate business requirements into technical mapping and transformation specifications.
- Experience producing technical documentation, including data mapping documents, data dictionaries and transformation specifications.
- Strong analytical and problem-solving skills with excellent attention to detail.
- Ability to communicate effectively with both technical and non-technical stakeholders.

Desirable:

- Workday experience.
- Experience of working with HR Data.
- Public Sector experience.

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

Disability Confident

As a Disability Confident employer, IPO encourage applications from disabled and neurodivergent candidates . Applications from candidates who identify as having a disability and meet the essential criteria for the role will be prioritised for review. Where application volumes are high, additional role-specific and desirable criteria may be applied as part of the shortlisting process which may include holding active security clearance.

Armed Forces Covenant

IPO welcome applications from veterans, service leavers, reservists and military spouses or partners. Applications from eligible candidates who meet the essential criteria for the role will be prioritised for review. Where application volumes are high, additional role-specific and desirable criteria may be applied as part of the 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".