Sector:Public Sector / Government / Defence
Job Title:Data Engineer
Type:Contractor
Location:London (Hybrid)
Duration:End FY – 31/03/2025 (initial)
Vetting:SC level security clearance is required
The Data Engineer role’s primary focus will be on developing the PMO’s Excel-based toolkit to enhance the use of data in strategic decision making across the client.
This will consist of providing rapid development and improvement of tools built in Excel and using the Power platform.
To ultimately assist the PMO to provide delivery, reporting and strategic support.
Experience required
EXPERT in Exceland strong with Power Query and wider Power Platforms suite knowledge & Experience
Advanced Data Modelling experience (financial/budget data) using Power Query.
Reviewing current product in use and building better models that will be better fit for purpose.
- Passionate about Excel and data with a proven track record of delivering high-quality Excel-based solutions.
- Extensively experienced in developing, managing, and optimising Excel-based solutions to support various business functions, has a strong understanding of Excel's advanced features and capabilities, and be able to translate requirements into effective Excel solutions.
- An expert in using Excel’s advanced features including formulas, macros, VBA and Power Query, and familiar with Power Pivot, Power Automate, Power BI Desktop and Power BI Service.
- Able to work with various data sources, including databases, Excel, SharePoint, APIs, and web services.
- Meticulous in their approach to data preparation, data cleansing, and report design to ensure data accuracy and quality and the ability to document and present data visualisation solutions clearly.
- Familiar with data visualisation and the ability to think creatively and innovatively to design and create visually appealing and insightful custom report, dashboard and unique data presentation solutions.
- Proactive with a “can do” problem-solving approach to address data-related challenges and the ability to adapt to changing data requirements and business priorities.
- Able to work independently, but also has strong collaboration skills to work closely with business analysts, data engineers, and other team members in multidisciplinary projects.
Professionally qualified in computer science, Information Technology, Data Science or a related field.
