Data Analyst - 26570

Job Description

You will act as a part of the Portfolio Delivery Office’s Data Analysis and Reporting Team (DART) engaging widely across the business to transform performance data into business, commercial and programme information with a focus on the Flood and Coastal Risk Management portfolio. While providing specific capabilities for the team you will also have a general understanding across the team’s operation and will support accordingly as the need arises.

Your key responsibilities will be to;

• Collate and analyse relevant business and management information (note: data processing tests will form part of the interview)
• Produce Power BI dashboards for a range of audiences from executive to operational level
• Assist in the production of KPI reporting and variance analysis
• Assist in developing models and modelling techniques that support business objectives.
• Challenge and assist the development of data management practices (including Business Intelligence activities) and processes, helping to identify appropriate new systems and calibrating them for use in the business.
• Connect to pre-existing data sources and set up new ETL – using e.g. APIs, ETL software
• Provide knowledge sharing and support to the team and the business in data analysis techniques.

Responding to incidents is a central part of what we do. You will be required to have an incident role and make yourself available to respond to incidents, or provide business continuity support during an incident. This may attract an additional payment and full training and alternative working arrangements will be available to support you with your incident role.

The team

DART sits within the Portfolio Delivery Office part of Major Projects and Programme Delivery. We deliver dashboarding and data management services on a broad range of business areas. The team is a blend of Environment Agency and consultants fulfilling the roles of Data Analyst, Business Analyst, service desk and knowledge management. We have cultivated a culture of collaboration within the team and have an excellent breadth of skills and experience for joiners to learn from.

Experience/skills Required

The role is diverse, challenging, fast-paced and changeable. Analytical skills, initiative, time management, prioritisation, building relationships, and project management skills are central. Effective communication skills, showing empathy and understanding of your audience is essential.

Essential:

• Proficient in data analysis (cleaning, processing, and visualising data) using e.g. Excel, Python, R, or other software
• Able to manage yourself and deliver; highly motivated, organised, resilient
• Strong influencing and communication skills
• Ability to thrive in a changing environment
• Strong problem-solving skills
• Developed and delivered business information using data analytics

Preferable

• Knowledge of supply chain management/commercial frameworks/construction programmes
• Experience of using SQL or other database querying languages; R, Python, VBA or DAX
• Experience using BI application(s) e.g. Power BI, Tableau, Qlik
• Experience of data warehousing and business intelligence platforms
• Experience using APIs to access data (Python preferable)
• Experience creating ETL processes (FME preferable)

Contact and additional information

Benefits include generous pension provision and leave entitlement as well as flexible working practices to support a healthy work/life balance. Please see the candidate pack for more information around benefits offered.

Location is flexible and some travel to other EA office locations may be required but this is likely to be infrequent. As a dispersed team you should feel comfortable connecting to team members and customers remotely and face to face.

The Data Analyst vacancy requires “Security Check”, due to handling/accessing sensitive data, this is managed from our side post interview.

For further information and Security Check level please see: National security vetting: clearance levels - GOV.UK (www.gov.uk).

For further information please contact: Charlie Carlisle Charlie.carlisle@environment-agency.gov.uk

Interviews likely to commence w/c 29/08/23.

Closing Date:

25/06/2023, 23:55 hours

Level of security checks required

Basic Check

Competence 1

Data and Information Management

Description

Collects, analyses, interprets, records, manages, develops and shares data, material or information appropriately for a variety of purposes.

You have been given an unprocessed dataset and asked to produce a set list of visuals or graphs, What steps might you take to complete the task? How would you process and manage the data?

Competence 2

Takes Decisions and Solves Problems

Description

Finds and delivers optimal solutions by effectively analysing all the information, probing to develop alternatives and taking sound and timely decisions.

Please give an example of a problem you have solved that you're proud of, and explain why you solved it the way you did and what the alternative solutions might have been?

Competence 3

Communicates Effectively

Description

Listens and questions to understand and engage. Conveys information and ideas clearly, accurately and persuasively through speech and writing.

Please give an example of a time you've communicated a difficult topic effectively - why was it difficult? who was the audience?

If you are applying from the Civil Service please note that the Environment Agency is not a part of HM Civil Service and you would not be a Crown Servant in the event of being appointed. Therefore, you will not be eligible for continuous service. For applicants who currently work in local government or other bodies listed in the Redundancy Payments (Continuity of Employment in Local Government etc) (Modification) Order 1999, you may be eligible for continuous service for the purpose of calculating any future redundancy payment. If you are unsure of your status then you should contact your own HR Team.

We are fully committed to having a diverse and inclusive workforce to reflect the communities we serve. We welcome flexible working patterns for all our vacancies, including job share, so please include clearly any information regarding your preferred working arrangements on your application.

We also have a Guaranteed Interview Policy to support those with a disability who are seeking employment. We have committed to guaranteeing an interview to anyone with a disability whose application meets the minimum criteria for the post.

The Environment Agency, as a Non-Departmental Public Body, is committed to providing value for money and utilises Central Government frameworks and contracts for all external recruitment needs. For this reason, we are unable to engage with the market directly through post, email or phone calls . Should you wish to become a support supplier on one of these frameworks or contracts please visit https://www.gov.uk/government/publications/become-a-crown-commercial-service-supplier/becoming-a-supplier-through-the-crown-commercial-service-what-you-need-to-know for more information.