Corporate Data Analyst

This post will have a base in Peterborough or Aberdeen. JNCC has adopted a hybrid working approach, allowing colleagues to benefit from time in the office, with the flexibility also to work from home. Employees are expected to work from our office base or at external meetings or events for 1 – 2 days a month as a minimum, this will vary by team and the exact balance will depend on the nature of your role. We can provide more details at the interview and offer stages

About the job

Job summary

Why JNCC?

We’re small enough (c.300 staff) that your voice is heard by everyone including the CEO, but big enough that we have all the skills, resources and people you’ll need to get the job done. All our staff are passionate about conservation and making a difference to the world we live in. We have a very flexible, inclusive and welcoming organisational culture. Our Executive Management provides employees with the freedom and tools you will need, and our friendly team will assist you in your role.
JNCC is committed to maintaining employee health and wellbeing, whether it is physically, emotionally, financially or socially, and offers a range of benefits to support employees in this. Such benefits include the option to join the Civil Service Pension Scheme, professional and personal development opportunities as well as an exciting job in a unique environment.

Post background

This is an exciting time to join JNCC as a Corporate Data Analyst. We are in the process of implementing a new Enterprise Resource Planning (ERP) system, and as a result a full suite of data dashboards and reports needs to be built to meet business requirements and to maximise the opportunities provided by the new system. This role will act as a reports administrator and super user for the ERP, and as such will lead on supporting and testing future phases of system development.

The post holder will provide data expertise and insights to support core HR activities such as pay modelling, analysis of leaver feedback, statutory reporting and the management of staff benefits. In addition, the post will support JNCC’s annual planning and reporting activities, working across the organisation to support staff in accessing and utilising the data they need to make informed, data driven decisions. In order to provide insightful data reporting across a number of areas, this role will sit in the organisation’s Digital and Data Solutions team, but work closely with JNCC’s HR and finance teams.

Job description

Post Duties

• Create and maintain a suite of data dashboards and reports within and, where necessary, outside of, the ERP system, to provide the business and corporate service teams appropriate and readily-obtainable access to the Corporate Data they require.

• Produce ad hoc, monthly, and quarterly HR and finance statistics for both internal and external stakeholders, analysing the data to identify trends and key insights and ensuring compliance with statutory reporting requirements.

• Using your advanced Excel skills, support annual pay modelling and benchmarking activities, making analysis-based recommendations for the most effective usage of available salary budget.

• Use your data skills to support the automation of payroll checking and reconciliation and support the HR and finance teams with data gathering for annual and ad-hoc audits.

• Regularly carry out data quality checking and cleansing activities to ensure the accuracy, completeness, and quality of Corporate Data. Identify the root cause of discrepancies and establish process safeguards or provide training to avoid future occurrences wherever possible.

• Support JNCC’s annual planning process by leading data processing tasks and producing meaningful data outputs to inform decision making.

• As reports administrator and super user of the ERP system, support ongoing delivery capabilities, such as annual updates, and provide problem-solving to any reported issues.

• Proactively identify trends in support queries, and recommend solutions to reduce these in future, such as process clarification or additional training for staff.

• Work with the business and HR and finance colleagues to gather system improvement requirements and identify, test, document and implement appropriate solutions.

• As a key link staff member with corporate services, and as part of a wider data community within JNCC, fulfil any other duties required to support business objectives.

Person specification

Please demonstrate in your statement your suitability for the position.

Behaviours

We'll assess you against these behaviours during the selection process:

• Changing and Improving
• Seeing the Big Picture
• Communicating and Influencing
• Managing a Quality Service

Technical skills

We'll assess you against these technical skills during the selection process:

• Advanced level of Excel (Functions/formula, pivot tables).
• Experience of data visualisation using tools like Excel, Power BI or Tableau.
• Numerate, with a very high level of attention to detail.
• Strong analytical and problem-solving skills with the ability to draw meaningful conclusions from the reporting you develop, providing narrative or interpretation when required to support management decision making.
• Experience understanding reporting needs and capabilities, and creating visually appealing and easy-to-understand data visualisations and dashboards.
• Experience of ensuring data integrity (accuracy, completeness, and quality of data) within a database such as a HR information system, or comparable software.
• Experience of managing personal and sensitive data, in line with GDPR regulations and information management policies.
• In depth previous experience of an ERP system, HR or Finance information system or comparable software, ideally including experience as an administrator or key user.

Benefits

Alongside your salary of £30,573, Joint Nature Conservation Committee contributes £8,254 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.Equality and diversity
JNCC is committed to creating an environment where everyone feels valued and respected and see this as a good place to work. JNCC has a responsibility to ensure that we have an inclusive culture where discrimination, harassment, bullying and prejudice will not be tolerated. Our selection process is determined on fair and open competition and regardless of age, disability, gender reassignment, pregnancy and maternity, race, religion or belief, sex, sexual orientation, marriage and civil partnership.
Continuous professional development (CPD)
Employees are encouraged to keep developing skills and professional knowledge.
JNCC has made available, and encourages employees to use, on average, five working days per annum for CPD activities with access to related funding
Leave entitlement
JNCC annual leave allowance is 25 days per annum. After five years’ service, leave entitlement increases to 30 days per annum.
In addition to annual leave, JNCC offers 12 public and privilege days per annum, three of which are explicitly reserved for office closure between Christmas and New Year.
Work/life balance
JNCC supports flexible working hours and practices to help employees strike a good balance between work life and personal life.
Our policies are family-friendly and include flexi-time, flexible working patterns, compressed hours and dispersed working. JNCC also offers paid maternity, paternity, adoption and shared parental leave, over and above the minimum statutory entitlements. Some work/life balance benefits are available following a minimum length of service.
Any move from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax-Free Childcare. Determine your eligibility at https://www.childcarechoices.g... Service Pension
Employees will have the opportunity to join Civil Service pension arrangements, which include a valuable range of benefits. JNCC makes a significant contribution to the cost of employee pensions.
Employee Assistance Programme
JNCC provides employees with a free and confidential support service which gives unlimited access to information, advice and emotional support to help employees prepare for and manage all of life's ups and downs, events and challenges.
Trade Union
JNCC has entered into a partnership agreement with its recognised Trade Unions: Prospect and PCS, which employees are able to join and be involved with.
Salary sacrifice schemes
Employee Discount Scheme
Civil Service Sports Club

Things you need to know

Selection process details

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills.

As part of the application process you will be asked to complete a statement of suitability. In your statement, refer to the Post Duties section of this advert to show how you’re suitable for the role.

Please use the STARR technique

• Situation: Set the stage.
• Task: Explain where you fit in.
• Action: Describe each step.
• Results: Impress with your achievements.
• Reflection: what have you learned

Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a criminal record check.People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements

This job is broadly open to the following groups:

• UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window)

Working for the Civil Service

The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants.
We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window).The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.

Apply and further information

This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants

Job contact :

• Name : Recruitment Team
• Email : [email protected]

Recruitment team

• Email : [email protected]

Further information

Selection for appointment to the Civil Service is on merit, on the basis of fair and open competition, as outlined in the Civil Service Commission’s Recruitment Principles. In accordance with the Civil Service Commissioners’ Recruitment Principles, our recruitment and selection processes are underpinned by the requirement of appointment on the basis of merit by fair and open competition. If you feel your application has not been treated in accordance with the Recruitment Principles and you wish to make a complaint, you should contact [email protected] in the first instance.