Junior Analytics Engineer - 29871
All
Environment Agency
The Environment Agency works to create better places for people and wildlife, and supports sustainable development. EA is an executive non-departmental public body, sponsored by the Department for Environment, Food & Rural Affairs , supported...
Junior Analytics Engineer - 29871
Number of jobs available
1
Region
National
City/Town
All
Grade
Staff Grade 5
Post Type
Permanent
Role Type
Digital
Working Pattern
Full Time, Part Time/Job Share, Compressed Hours
Salary Minimum
£41,617
Closing Date:
We have an exciting business improvement opportunity to work as a Team Member in our Water Quality Digital Services team as part of our Water Industry Regulation transformation programme.
The Environment Agency is undergoing modernisation of systems and IT infrastructure and moving towards Microsoft Azure cloud computing and Microsoft analytics tooling and technology such as Synapse Analytics, Fabric and PowerBI. This represents a new and exciting opportunity for the team to pioneer new ways to do reporting and analytics. To prepare for this challenge we are recruiting a Junior Analytics Engineer to support the development and deployment of data products and analytics tools to enable the Water Quality user community to efficiently leverage data from various sources and, in turn, better inform business insights and drive effective policy changes.
At this role level, you will:
• implement data flows to connect operational systems, data for analytics and business intelligence (BI).
• document source-to-target mappings.
• re-engineer manual data flows to enable scaling and repeatable use.
• write and manage ETL (extract, transform, load) scripts and pipelines and ensure the ETL processes perform optimally.
• support the development of business intelligence reports.
• support the development of analytical techniques. The team The Water Quality Digital Services team sits within Water Regulation of the Environment Agency with the Environment & Business Directorate.
We steer the direction, set the priorities and shape our organisation's approach to delivering environmental outcomes and better regulation by providing digital and data services.
We work closely with colleagues across the Environment Agency, with Government, delivery partners and customers to help create a better place for people and wildlife and demonstrate value for money Experience/skills required Applicant must have:
• Extensive experience of managing and analysing large sets of data from multiple sources to serve reporting and analytics needs and turning raw data into valuable insight.
• Experience in organising data in STAR schema data models that represent entities and relationships and support efficient data querying and analysis.
• Ability to construct ETL pipelines that integrate data from various sources.
• Proficiency in Python and R languages to build ETL processes.
• Knowledge of SQL Server database management and data warehousing.
• Ability to solve complex problems and formulate efficient and innovative solutions.
Desirable:
• An understanding of Azure cloud, Azure Data Factory, Azure Data Storage Lake Storage Gen2 and Microsoft Synapse Analytics.
• Experience of using Power BI to create reports to customer specifications.
• Experience in data visualisation and analysis.
• Experience in data modelling and DAX language within Power BI desktop. Contact and additional information You’ll have an incident management objective in your development plan. We’ll support you to find a role to suit your needs and circumstances. Appropriate training will be given. #LI-DNI
You’ll have an EA Office base location, as a national role the working location is flexible / hybrid.
We use smart tools to stay connected and reduce travel, some travel and overnights may be required.
Please read the Candidate / Additional Information Pack. Any queries, contact Tomar.Chierici@environment-agency.gov.uk
Applications are “blind” assessed using your answers to the competency questions.
Interviews will be held via MS Teams within two weeks of the closing date.
If you consent to being held on a reserve list, we’ll hold your details for 6 months and may offer you an alternative post. 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.
If a large number of applications are received, an initial sift using this lead capability may be conducted. Successful candidates will then proceed to a full sift or directly to assessment/interview. Feedback is generally not available at sift stage.
QUESTION: Provide an example of a complex ETL (Extract Transform and Load) process you built for specific reporting needs. Describe what tools/systems you used, the steps involved and how the data was modelled and served for onwards reporting.
More information on how to answer competency questions can be found in the candidate pack. Competence 2 Focuses on Efficiency, Innovation and Quality Description Identifies and seizes the opportunity to create, introduce and implement new or improved methods, processes and without, compromising quality or accuracy.
QUESTION: Describe a time when you implemented a new innovative approach to satisfy a specific data reporting requirement. Provide technical details on the approach and what you did to ensure the process was resilient, repeatable and quality assured.
More information on how to answer competency questions can be found in the candidate pack. Competence 3 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.
QUESTION: Give an example of when you have had to solve a complex data analysis problem that involved diverse data sources. What data did you use? What was the problem and what decisions you took to solve it?
More information on how to answer competency questions can be found in the candidate pack. 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.
24/11/2024, 23:55 hours
Job description attachment 1 Job Profile - 29871.docx – 55KB Opens in a new window Job description attachment 2 E&B Additional Information Pack.pdf – 1853KB Opens in a new window Candidate pack Candidate Pack - 29871.docx – 2042KB Opens in a new window Security checks level Basic Check Job description The Environment Agency are fully committed to having an inclusive workforce to reflect the communities we serve. We don’t just talk about diversity; we seek it, embrace it, and live it, for the benefit of our staff, our communities, and our environment.We have an exciting business improvement opportunity to work as a Team Member in our Water Quality Digital Services team as part of our Water Industry Regulation transformation programme.
The Environment Agency is undergoing modernisation of systems and IT infrastructure and moving towards Microsoft Azure cloud computing and Microsoft analytics tooling and technology such as Synapse Analytics, Fabric and PowerBI. This represents a new and exciting opportunity for the team to pioneer new ways to do reporting and analytics. To prepare for this challenge we are recruiting a Junior Analytics Engineer to support the development and deployment of data products and analytics tools to enable the Water Quality user community to efficiently leverage data from various sources and, in turn, better inform business insights and drive effective policy changes.
At this role level, you will:
• implement data flows to connect operational systems, data for analytics and business intelligence (BI).
• document source-to-target mappings.
• re-engineer manual data flows to enable scaling and repeatable use.
• write and manage ETL (extract, transform, load) scripts and pipelines and ensure the ETL processes perform optimally.
• support the development of business intelligence reports.
• support the development of analytical techniques. The team The Water Quality Digital Services team sits within Water Regulation of the Environment Agency with the Environment & Business Directorate.
We steer the direction, set the priorities and shape our organisation's approach to delivering environmental outcomes and better regulation by providing digital and data services.
We work closely with colleagues across the Environment Agency, with Government, delivery partners and customers to help create a better place for people and wildlife and demonstrate value for money Experience/skills required Applicant must have:
• Extensive experience of managing and analysing large sets of data from multiple sources to serve reporting and analytics needs and turning raw data into valuable insight.
• Experience in organising data in STAR schema data models that represent entities and relationships and support efficient data querying and analysis.
• Ability to construct ETL pipelines that integrate data from various sources.
• Proficiency in Python and R languages to build ETL processes.
• Knowledge of SQL Server database management and data warehousing.
• Ability to solve complex problems and formulate efficient and innovative solutions.
Desirable:
• An understanding of Azure cloud, Azure Data Factory, Azure Data Storage Lake Storage Gen2 and Microsoft Synapse Analytics.
• Experience of using Power BI to create reports to customer specifications.
• Experience in data visualisation and analysis.
• Experience in data modelling and DAX language within Power BI desktop. Contact and additional information You’ll have an incident management objective in your development plan. We’ll support you to find a role to suit your needs and circumstances. Appropriate training will be given. #LI-DNI
You’ll have an EA Office base location, as a national role the working location is flexible / hybrid.
We use smart tools to stay connected and reduce travel, some travel and overnights may be required.
Please read the Candidate / Additional Information Pack. Any queries, contact Tomar.Chierici@environment-agency.gov.uk
Applications are “blind” assessed using your answers to the competency questions.
Interviews will be held via MS Teams within two weeks of the closing date.
If you consent to being held on a reserve list, we’ll hold your details for 6 months and may offer you an alternative post. 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.
If a large number of applications are received, an initial sift using this lead capability may be conducted. Successful candidates will then proceed to a full sift or directly to assessment/interview. Feedback is generally not available at sift stage.
QUESTION: Provide an example of a complex ETL (Extract Transform and Load) process you built for specific reporting needs. Describe what tools/systems you used, the steps involved and how the data was modelled and served for onwards reporting.
More information on how to answer competency questions can be found in the candidate pack. Competence 2 Focuses on Efficiency, Innovation and Quality Description Identifies and seizes the opportunity to create, introduce and implement new or improved methods, processes and without, compromising quality or accuracy.
QUESTION: Describe a time when you implemented a new innovative approach to satisfy a specific data reporting requirement. Provide technical details on the approach and what you did to ensure the process was resilient, repeatable and quality assured.
More information on how to answer competency questions can be found in the candidate pack. Competence 3 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.
QUESTION: Give an example of when you have had to solve a complex data analysis problem that involved diverse data sources. What data did you use? What was the problem and what decisions you took to solve it?
More information on how to answer competency questions can be found in the candidate pack. 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.
Job stats:
6
2
0
Categories:
Analyst Jobs
Engineering Jobs
Tags: Azure Business Intelligence Data analysis Data Warehousing ETL Pipelines Power BI Python R Security SQL
Perks/benefits: Flex hours
Region:
Europe
Country:
United Kingdom
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.
Principal Data Scientist jobsBI Developer jobsStaff Data Scientist jobsPrincipal Data Engineer jobsData Scientist II jobsData Manager jobsJunior Data Analyst jobsData Science Manager jobsResearch Scientist jobsBusiness Data Analyst jobsLead Data Analyst jobsSenior AI Engineer jobsSr. Data Scientist jobsData Engineer III jobsData Science Intern jobsData Specialist jobsJunior Data Engineer jobsSenior Data Scientist, Performance Marketing jobsBI Analyst jobsSoftware Engineer, Machine Learning jobsSr Data Engineer jobsData Analyst Intern jobsData Analyst II jobsSenior Artificial Intelligence/Machine Learning Engineer - Remote, Latin America jobsJunior Data Scientist jobs
Snowflake jobsEconomics jobsLinux jobsHadoop jobsOpen Source jobsJavaScript jobsPhysics jobsComputer Vision jobsAirflow jobsKafka jobsMLOps jobsRDBMS jobsBanking jobsData Warehousing jobsNoSQL jobsScala jobsGoogle Cloud jobsData warehouse jobsKPIs jobsR&D jobsPostgreSQL jobsOracle jobsGitHub jobsSAS jobsCX jobs
Classification jobsStreaming jobsTerraform jobsScikit-learn jobsLooker jobsScrum jobsDistributed Systems jobsPandas jobsData Mining jobsBigQuery jobsPySpark jobsRobotics jobsJenkins jobsJira jobsIndustrial jobsRedshift jobsdbt jobsReact jobsUnstructured data jobsMicroservices jobsMySQL jobsData strategy jobsE-commerce jobsGPU jobsNumPy jobs