DDaT Senior BI Design & Integration Manager

MOD - Defence Infrastructure Organisation - CIO - Delivery and Operations DDaT Senior BI Design & Integration Manager, Do you want to work for the Defence Infrastructure Organisation (DIO) and care for the Defence Estate? DIO enables Defence to live, work, train and deploy, all with sustainability in mind. From net carbon zero accommodations to runways for the F35 fighter jets; our outputs are unique in the UK and across the globe!Learn much more about DIO in our Candidate Information Guide attached.
About DIO
View our YouTube video to see more about our work
Where business needs allow, some roles may be suitable for a combination of office and home-based working. This is a non-contractual arrangement where all office-based employees will be expected to spend a minimum of 60% of their working time in office, subject to capacity and any required workplace adjustments. Requirements to attend other locations for official business, or work in another MOD office, will also count towards this level of attendance. Applicants can request further information regarding how this may work in their team from the Vacancy Holder (see advert for contact details).
This position is advertised at 37 hours per week. Possible attendance one day per week at DMS Whittington (WS14 9PY), An exciting opportunity has arisen within CIO as a Senior BI Design & Integration Manager. The role sits within the CIO Data Team and is focused on the agile development of robust data models within the Data Warehouse, which are delivered in sprints to support the business requirements. It is a key role in supporting the aims of the BI function as it is at the centre of the providing, supporting and maintaining data models accessed via data marts, to ensure reliability and performance in line with the expectations of key stakeholders.
The role is also tasked with supporting, testing, and providing proper resilience of the Data Warehouse, in addition to oversight of the business continuity plan. As a major contributor to the support of key stakeholders, this role interacts with the BI delivery team within the BI function and is also responsible for documenting data models providing clarity to end users and the wider DIO on the structure of the Data Warehouse, associated Data Marts and their views. It is also a key role for interacting with Data Architecture team on the supply of data into the Data Warehouse, ensuring that data is loaded in an accurate and timely manner.
This post is responsible for subordinate Data Warehouse Developers.
Responsibilities:
+ Manage Agile development of the Data Warehouse to provide a reliable underlying data source for end users across DIO in line with management priorities.
+ Manage & implement the building of resilient Data Models and robust design of data marts to support reporting and analytical requirements.
+ Manage the creation & development of end-to-end ETL routines using Pentaho, SQL, EDQ and PLSQL.
+ Provide technical expertise to the team for Data Warehouse design, development, and implementation.
+ Manage the embedding of best practice and continual improvement for all aspects of the Data Warehouse by the identification of more efficient and effective processes.
+ Manage & ensure version controls are adhered to for promoting Pentaho jobs into production.
+ Identify areas of innovation in future technology changes.
+ Manage the loading of data files & implement strategies that ensure business requirements are met.
+ Manage the fixing of ETL load failures as a matter of priority to make sure that the DWH is up and running as soon as possible.
+ Manage & implement strategies for the monitoring of all ETL jobs to identify any problems and ensure maximum efficiency.
+ Manage & implement strategies for the testing of new Developments prior to release.
+ Manage the support tasks associated within the Data Warehouse capability.
+ Mange & review the EDQ data quality outputs and inform Data Quality team accordingly to resolve any issues.
+ Manage the planning of regular maintenance of DWH structure & ETL routines to prevent redundancy & keep the DWH running efficiently.
+ Ensure the daily monitoring of Landing Database to ensure regular feed of external data from suppliers.
+ Engage with Data Architecture team to agree data transfer and integration requirements for the Data Warehouse.
+ Engage with Data Exploitation teams and key stakeholders to identify, plan, develop and deliver data services to meet business requirements.
+ Ensure appropriate documentation is produced mapping data from Source to Data Mart.
+ Ensure Schema Diagrams are produced to inform report authors of the Data Model structure.
+ Work with the Data Warehouse Lead and the wider team on the development of the data Warehouse and its implementation strategy, within the alignment to the overarching vision, mission and goals for Digital, Data and Technology across the department.Responsible for developing and supporting the team, enabling them to deliver departmental goals.
+ Responsible for developing and supporting the team, enabling them to deliver departmental goals., + Government Digital and Data Profession Capability Framework - Senior Data Engineer - Programme and build (data engineering) (skill level practitioner)
+ Government Digital and Data Profession Capability Framework - Senior Data Engineer - Problem resolution (data) (skill level working)
We only ask for evidence of these technical skills on your application form:
+ Government Digital and Data Profession Capability Framework - Data Engineer - Data Development Process (Skill level: practitioner), + Government Digital and Data Profession Capability Framework - Senior Data Engineer - Programme and build (data engineering) (skill level practitioner)
+ Government Digital and Data Profession Capability Framework - Senior Data Engineer - Problem resolution (data) (skill level working)
The Civil Service embraces diversity and promotes equality of opportunity. There is a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria. If you need to advise us that you need additional help or reasonable adjustments for the recruitment process, please contact: DBSCivPers-Resourcingteam3@mod.gov.uk .
As a result of the changes to the UK immigration rules which came in to effect on 1 January 2021, the Ministry of Defence will only offer sponsorship for a skilled worker visa under the points based system, where a role has been deemed to be business critical. This role does not meet that category and we will not sponsor a visa. It is therefore NOT open to applications from those who will require sponsorship under the points-based system.
Should you apply for this role and be found to require sponsorship, your application will be rejected and any provisional offer of employment withdrawn.
Feedback will only be provided if you attend an interview or assessment.

Security
Successful candidates must undergo a criminal record check.
Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).See our vetting charter (opens in a new window).
People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements
This job is broadly open to the following groups:
+ UK nationals
+ nationals of the Republic of Ireland
+ nationals of Commonwealth countries who have the right to work in the UK
+ nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
+ nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
+ individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
+ Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service
Further information on nationality requirements (opens in a new window)

Working for the Civil Service
The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants.
We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window).
The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.
The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.

Diversity and Inclusion
The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window).

+ Working in a Data Warehouse team creating ETL routines
+ A working knowledge of Data Modelling techniques e.g. Star schema
+ Previous experience of managing a team
Essential Technical Skills:
+ Experience of implementing Data Warehouse concepts.
+ Experience of using Databases
+ Experience of using ETL tools
Desirable Technical Skills:
+ Experience of using an Oracle Database
+ Experience of using Data Quality software

This vacancy is using Success Profiles (opens in a new window), and will assess your Experience and Technical skills.
When choosing your Behaviour examples, please make sure you use real life scenarios that relate to your own experiences. Whilst technology may help to enhance your written submission, presenting the ideas of others or those generated by technology, could result in your application being rejected.
At sift, you will be assessed against the following Success Profiles
Technical : Government Digital and Data Profession Capability Framework - Data Engineer - Data Development Process (Skill level: practitioner)
CV - including Job History, Full Qualification Details and Previous Skills & Experience
Personal Statement - in no more than 500 words, please outline your experience and suitability within Data Warehouse
At interview, you will be assessed against the following Success Profiles Technical Skills:
+ Government Digital and Data Profession Capability Framework - Data Engineer - Data Development Process (Skill level: practitioner)

Alongside your salary of £43,080, Ministry of Defence contributes £12,480 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.
+ Learning and development tailored to your role
+ An environment with flexible working options
+ A culture encouraging inclusion and diversity
+ A Civil Service pension with an employer contribution of 28.97%
+ This post is eligible for a Digital Skills Allowance of up to £11,400 per annum. Eligibility for this allowance will be assessed at interview against 4 core technical skills only and reviewed annually in line with MOD policy.
Where business needs allow, some roles may be suitable for a combination of office and home-based working. This is a non-contractual arrangement where all office-based employees will be expected to spend a minimum of 60% of their working time in office, subject to capacity and any required workplace adjustments. Requirements to attend other locations for official business, or work in another MOD office, will also count towards this level of attendance. Applicants can request further information regarding how this may work in their team from the Vacancy Holder (see advert for contact details). Defence Business Services cannot respond to any questions about working arrangements.
Please Note: Expenses incurred for travel to interviews will not be reimbursed.
The post does not offer relocation expenses.
External recruits who join the MOD who are new to the Civil Service will be subject to a six-month probation period.
Please be advised that the Department is conducting a review of all pay related allowances which could impact on those allowances that the post currently being advertised attracts.
Any move to MOD from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax-Free Childcare. Determine your eligibility at https://www.childcarechoices.gov.uk/.
The Ministry of Defence is committed to providing a safe and healthy working environment for its staff which includes educating them on the benefits of not smoking, protecting them from the harmful effects of second-hand smoke and supporting those who want to give up smoking. Under the Smoke-Free Working Environment policy, Smoking and the use of all tobacco products (including combustible and chewing tobacco products) will not be permitted anywhere in the Defence working environment however some exemptions are in place, please refer to local guidance. The policy is Whole Force and includes all Defence personnel, contractors, visitors and other non-MOD personnel. All applicants seeking, considering, or accepting employment with the Ministry of Defence should be aware of this policy and that it is already in place at a number of Defence Establishments.