DDaT Senior BI Design & Integration Manager - MoD - SEO
Posted 17 hours 22 minutes ago by Manchester Digital
Permanent
Not Specified
Design Jobs
England, United Kingdom
Job Description
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:
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 .
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.
MOD Recruitment Satisfaction Survey - we may contact you regarding your experience to help us improve our customer satisfaction. The survey is voluntary and anonymous. You may however be given the opportunity to provide additional information to help us improve our service which includes the collection of some personal data as defined by the United Kingdom General Data Protection Regulation (UK GDPR). The MOD Privacy Notice sets out how we will use your personal data and your rights.
When choosing your Behaviour examples . click apply for full job details
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.
- 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
- Experience of implementing Data Warehouse concepts.
- Experience of using Databases
- Experience of using ETL tools
- Experience of using an Oracle Database
- Experience of using Data Quality software
- 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 - Data Integration Design (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)
- Government Digital and Data Profession Capability Framework - Data Engineer - Data Development Process (Skill level: practitioner)
- Learning and development tailored to your role
- An environment with flexible working options
- A culture encouraging inclusion and diversity
- 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.
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 .
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.
MOD Recruitment Satisfaction Survey - we may contact you regarding your experience to help us improve our customer satisfaction. The survey is voluntary and anonymous. You may however be given the opportunity to provide additional information to help us improve our service which includes the collection of some personal data as defined by the United Kingdom General Data Protection Regulation (UK GDPR). The MOD Privacy Notice sets out how we will use your personal data and your rights.
When choosing your Behaviour examples . click apply for full job details