Data Engineer

Job Description

Making the Commissions data more accessible and available so that internal and external stakeholders can gain greater insight into charities and the wider charitable sector. This will be done through the design and delivery of data systems, pipelines, andfront-end applications in line with the Commissions Data Strategy.Client DetailsThe Charity Commission has set out our ambitious five-year strategy, being clear that we will be driven by our purpose to ensure that charity can thrive and inspire trust so that people can improve lives and strengthen society. Our purpose is bold, confidentand so is our proud commitment to represent the public interest.The Charity Commission regulates 170,000 charities across England and Wales ensuring that they work within a legal framework thus building public confidence that the £10bn generously donated is put to good use.Description

• Build, test and maintain data systems, ensuring they meet the Commissions requirements, design objectives, user needs and overall goal of making the data useable and accessible for analysis.
• Working within a multi-skilled data analytics team to deliver systems and services that are automated, reliable, repeatable, secure, and scalable.
• Translate high-level user requirements into technical design specifications.
• Create ETL/ELT pipelines to extract, transform and load data according to the database/technical design specification.
• Advocate for a forward-thinking data analytics culture, where everyone is comfortable using data-based insights to improve the quality and effectiveness of their decisions.
• Apply knowledge of data manipulation to prepare datasets that are well understood and reusable.
• Understand our obligations around GDPR and data security and actively ensure that risks are understood, mitigated, and documented.
• Provide advice and recommendations on ways to improve data capture, ensuring data quality and better analytical reporting.
• Document, assess and track the Commissions data assets

ProfileEssential

• A strong analytical mind with proven problem-solving abilities.
• Ability to communicate technical information to non-technical colleagues
• Ability to produce data requirements and design documents
• Manage and document risks
• Developing SQL Server databases using T-SQL
• Creating and maintaining ETL or ELT pipelines
• Creating data models
• Creating data mapping documentation
• Joining tables & datasets from disparate sources
• Using data visualisation and analytics tools to create insightful reports and dashboards
• Maintaining a data dictionary
• Working with XML or JSON file formats
• Advanced T-SQL programming
• Database design theory (both relational OLTP and warehousing OLAP).
• Demonstrable knowledge of the Microsoft SQL Server business intelligence toolset (On-Prem or Cloud)
• Knowledge of extract, transform and load toolsets (On-Prem or Cloud)
• An awareness of cloud-based Microsoft technologies
• An understanding of data governance
• An understanding of GDPR and how it effects data retention, protection and processing.
• Data driven decision

Desirable

• ITIL Qualified
• Problem management
• Azure data development certification
• RedGate Toolbelt
• PowerBI or other visualisation software
• Change management
• Presentation skills
• Stakeholder management
• Developing data services and pipelines in MS Azure
• Metadata management
• Working in regulated secure organisations
• Working with 3rd party suppliers
• Using advanced Excel functions such as PivotTables
• Azure SQL
• Azure Data Factory
• Knowledge of indexing and SQL performance tuning
• GDS Standards
• Agile methodologies
• Data Management (DMBOK)
• Test Driven Development
• Knowledge of source control tools (Gi t)

Job Offer

• £29,163 salary (possible IT allowance of £3697 for right candidate)
• Civil Service pension
• Generous annual leave allowance
• Employee assistance programme
• Interest free season ticket and bicycle loan after 2 months employment
• Special retail discounts and offers through membership of staff Perkbox scheme
• Flexible and family friendly working environment
• Learning and career development

Selection process: Candidates will be sifted on their CVs and experience against the job description. And at interview assessed on the following Civil Service Behaviours:

• Managing a Quality Service
• Delivering at pace
• Changing & Improving

The full list of Civil Service behaviours at various levels can be found hereSecurity Clearance: This role requires SC clearance. Please request further info if required.* CLOSING DATE: Sunday 12th September 11:55pm *