29871 - Junior Analytics Engineer

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

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.
  
  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.