Data Warehouse Architect

1 month ago

Milton Keynes, Milton Keynes, United Kingdom NHS Full time
Milton Keynes University Hospital NHS Foundation Trust

Hours: Full time, 37.5 per week, all MKUH roles will be considered for flexible working

An exciting opportunity has arisen for a Senior Data Warehouse Developer to join the Data Engineering Team within the IT Department at Milton Keynes Hospital. The successful applicant will play a key role in supporting and managing the Data Warehouse as well as the development of the Azure Data Lake used by the trust. The ideal candidate will be confident with proven experience of Database support, preferably in a healthcare environment, be an excellent communicator and pay very close attention to detail.

The overall aim of this role is to support the Trust's data warehouse and help enable the effective use of data by Trust stakeholders such as information analysts, managers and clinicians to improve health care delivery at the Trust.

The responsibilities of the post-holder will be diverse and changing depending on the projects the team is working on. The team's core functions are to develop, maintain and enhance the Trust's data capabilities, to ensure the accuracy and robustness of central submissions and information on which the organisation operates.

Job responsibilities

The post-holder will be required to work in a team responsible for the development, maintenance and performance of the data warehouse.

Take a lead in ensuring the Trust's data warehouse is appropriately maintained and updated to meet the specific needs of the Trust, as directed by the Database Warehouse Manager. This may include monitoring and analysing highly complex Extract, Transform and Load (ETL) processes and managing the Microsoft SQL databases.

Person Specification
Qualifications and knowledge
  • Degree level or equivalent experience (relevant to role).
  • Postgraduate qualification in relevant area or equivalent experience.
  • Strong knowledge of RDBMS concepts, database architecture and T-SQL.
  • Knowledge of Business Intelligence systems and reporting tools.
  • Report writing skills preferably using Power BI.
  • Knowledge of SQL Server, SQL Server Integration Services, SQL Server Reporting Services.
  • Knowledge of Azure Data Factory, Azure Analysis Services.
  • Advanced use of Microsoft Office 365 suite especially Excel.
  • Knowledge of NHS and acute datasets.
  • Experience of Data science languages such as R or Python.
  • Qualification in Project Management.
  • ITIL certification.
  • Knowledge of Microsoft Azure Platform.
  • Knowledge of patient and data flows in a hospital setting.
  • Experience of Azure DevOps Services, CI/CD pipelines.
  • Experience of MongoDB.
Experience
  • Proven experience of working with Databases.
  • Experience of database report writing.
  • Experience of working in an acute NHS trust.
  • Experience of working on data science projects using Python or similar.
  • Experience of indexing and database optimization techniques.
  • Advanced knowledge of SQL Server 2012+ and at least 3 years' experience.
  • Experience of Developing SSIS packages.
  • Knowledge of relevant legal requirements especially around processing personal data.
  • Experience of developing data platform in Azure and/or SQL Server.
  • Experience of working with Azure Analysis Services and Azure Data Factory.
  • Experience of assisting in infrastructure deployment in Azure.
  • Advanced knowledge and competent use of Patient Administration System and other HealthCare IT systems.
Skills
  • Able to work independently and proactively.
  • Numerate, articulate and able to assimilate, analyse, interpret and compare highly complex facts/situations.
  • Able to liaise with external system suppliers.
  • Working knowledge of NHS Information Governance requirements.
  • Strong administrative and organisational skills.
  • Good analytical skills for spotting or anticipating weaknesses in processes (manual or system), along with the ability to organise and implement correction.
  • Structured, diagnostic approach to finding solutions to highly complex data issues.
  • Innovative and lateral thinker.
  • Ability to identify and embrace change in the drive towards continuous improvement.
  • Ability to present and relay complex or combined datasets and data concepts in a clear manner.
  • Ability to deliver sensitive data in a professional and empathetic style.
  • Ability to train staff on a one to one basis.
  • Ability to operate consistently at high level summary as well as detail levels.
  • Ability to listen and interpret users' needs and to inspire confidence.
Personal and people development
  • Evidence of commitment to Continuous Professional Development.
  • Self-motivated and able to work to tight deadlines with a flexible approach to work.
  • Ability to work as a member of a team.
Communication
  • Strong communication skills - written and verbal - able to identify key points from complex issues and explain them appropriately and with clarity across a wide range of stakeholders both within an organisation and externally.
  • Experience of communicating complex issues and data concepts to a range of people.
Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Salary: £46,148 to £52,809 a year (Per annum, pro rata if part time)

  • Data Architect

    1 month ago

    Milton Keynes, Milton Keynes, United Kingdom Saunders Scott Full time

    Job Title: Data ArchitectAt Saunders Scott, we are seeking a highly skilled Data Architect to join our team. The successful candidate will be responsible for designing and implementing data infrastructure solutions that meet the needs of our business.Key Responsibilities:* Design and implement data architecture solutions that meet business requirements*...

  • Data Warehouse Architect

    3 days ago

    Milton Keynes, Milton Keynes, United Kingdom Coltech Recruitment Full time

    Role OverviewWe are seeking an experienced Data Warehouse Architect to join our team as a Snowflake Expert. This is a fantastic opportunity to work with a leading client in the connectedness industry, shaping their data strategy and implementing cutting-edge data warehousing solutions.Key ResponsibilitiesDesign, develop, and implement Snowflake data...

  • Data Architect

    4 weeks ago

    Milton Keynes, Milton Keynes, United Kingdom Syncarp Full time

    Job Title: Telecom Data ArchitectAbout the Role:We are seeking a highly experienced Telecom Data Architect to join our team at Syncarp, a global IT service provider based in Milton Keynes, UK. The ideal candidate will have a strong background in telecom and fibre domains, with a minimum of 12 years of experience.Key Responsibilities:Design and implement data...

  • Data Architect

    3 weeks ago

    Milton Keynes, Milton Keynes, United Kingdom Anglia IT Recruitment Full time

    Data Architect Job SummaryWe are seeking a highly skilled Data Architect to join our team at Anglia IT Recruitment.Key Responsibilities:Develop business requirement-driven reusable repositories of data items in EA Sparx to develop the CIM.Develop business requirement-driven generic, reusable data model packages that provide guidance for workstreams and...

  • Snowflake Data Architect

    3 days ago

    Milton Keynes, Milton Keynes, United Kingdom Prodapt Full time

    About ProdaptProdapt is a leading specialized firm serving the Connectedness vertical, with presence across 5 continents. We deliver futuristic solutions and AI-driven services to global CSPs and digital platform & software firms.Job SummaryWe are seeking an experienced Snowflake Data Architect to join our team in Milton Keynes, UK. This is a full-time...

  • Senior Data Engineering Lead

    4 weeks ago

    Milton Keynes, Milton Keynes, United Kingdom Syncarp Full time

    Job Title: Data ArchitectJob Description:We are seeking a highly skilled Data Architect to join our team at Syncarp. The ideal candidate will have strong experience in telecom and fibre domains, as well as a solid understanding of data governance and data quality processes.Mandate Skills:Strong telecom and fibre domain experienceStrong data engineering and...

  • AWS Data Architect

    1 month ago

    Milton Keynes, Milton Keynes, United Kingdom Agile Recruitment Ltd Full time

    PermanentUp to £80,000 + bonusDATA ARCHITECT – SQL, Tableau, CognosOur client, Agile Recruitment Ltd, is seeking a data architect to oversee data sources and analyze them for specific aspects using both database and data warehousing tools. Define the company's data standards and principles.Design, construct, and further develop the data architecture in an...

  • Data Architect

    4 weeks ago

    Milton Keynes, Milton Keynes, United Kingdom BJSS Full time

    About the RoleWe're seeking a skilled Data Architect to join our team at BJSS. As a technical authority, you'll interface directly with customers, representing our deep technical expertise. You'll lead delivery teams by example, providing insight to enable them to craft great solutions that delight our customers.About YouYou'll be a passionate advocate for...

  • Data Modeler and Architect

    3 weeks ago

    Milton Keynes, Milton Keynes, United Kingdom Square One Resources Full time

    Job Title: Data ArchitectWe are seeking a skilled Data Architect to join our client in the Rail Transportation industry. This is a key role that requires a strong understanding of data modeling and architecture. Key responsibilities include developing a business requirement-driven reusable repository of data items in EA Sparx, communicating CIM model...

  • Data Architect Lead

    3 days ago

    Milton Keynes, Milton Keynes, United Kingdom Jas Gujral Full time

    Job Description:We are seeking a highly experienced Data Architect Lead to join our team at Jas Gujral in Milton Keynes.The ideal candidate will have extensive knowledge of data migration and implementation, as well as expertise in setting up and leading programmes for Enterprise Data Foundations and Integration.The successful candidate will develop BAU...

  • Data Architect for Network Rail

    1 month ago

    Milton Keynes, Milton Keynes, United Kingdom Network Rail Full time

    At Network Rail, we're investing in our people to enhance the safety, reliability, and efficiency of our railway system. We're looking for a skilled Data Architect to join our team and help us achieve our goals.As a Data Architect, you'll be responsible for designing and implementing secure data systems that meet the needs of our business. You'll work...

  • Data Architect

    4 weeks ago

    Milton Keynes, Milton Keynes, United Kingdom BJSS Full time

    About the RoleWe're seeking a seasoned Data Architect to join our team at BJSS. This role involves working with clients across various industries to help them derive value from their data. You'll be responsible for designing and implementing modern data warehousing, analytics, and machine learning solutions that meet our clients' needs.As a technical...

  • Enterprise Data Architect, Aiimi Ltd

    1 week ago

    Milton Keynes, Milton Keynes, United Kingdom Aiimi Ltd Full time

    About the RoleAiimi Ltd is seeking a seasoned Enterprise Data Architect to lead the development and implementation of its enterprise data architecture. As a key member of our team, you will be responsible for designing, implementing, and maintaining our data architecture, ensuring it remains secure and leverages the latest technologies and tools.

  • Data Analyst

    1 month ago

    Milton Keynes, Milton Keynes, United Kingdom Tech Mahindra Full time

    Job DescriptionJob Title: Data Analyst (Banking Domain)Job Type: Full-TimeJob Description:We are seeking a highly skilled Data Analyst with a strong background in banking and finance to join our team. As a Data Analyst, you will play a crucial role in shaping our digital transformation initiatives and collaborating with stakeholders to analyze, define, and...

  • Cloud Data Solutions Architect

    3 days ago

    Milton Keynes, Milton Keynes, United Kingdom BJSS Full time

    About the RoleWe're seeking an experienced Cloud Data Solutions Architect to join our team at BJSS. In this senior role, you'll have the opportunity to transform how our clients access and process data, driving their data maturity and enabling them with data-driven decision making.As a hands-on practitioner, you'll be responsible for defining and building...

  • Senior Data Architect and Translator

    1 month ago

    Milton Keynes, Milton Keynes, United Kingdom GBA5 EntServ UK Limited Full time

    Job Description:Data Strategist and TranslatorSummaryWe are seeking an experienced Data Strategist and Translator to co-ordinate our Data Driven Decision Making transformation workstream. You will be responsible for overseeing the strategic use of data and facilitating the creation of data products, in a programme that efficiently and effectively delivers...

  • Senior Data Architect and Translator

    4 weeks ago

    Milton Keynes, Milton Keynes, United Kingdom GBA5 EntServ UK Limited Full time

    Job Description:Data Strategist and TranslatorSummaryGBA5 EntServ UK Limited is seeking an experienced Data Strategist and Translator to co-ordinate our Data Driven Decision Making transformation workstream. You will be responsible for overseeing the strategic use of data and facilitating the creation of data products, in a programme that efficiently and...

  • Warehouse Logistics Coordinator

    7 days ago

    Milton Keynes, Milton Keynes, United Kingdom Wisetek Full time

    Warehouse OperativeWe are seeking a motivated and detail-oriented Warehouse Operative to join our team at our UK facility in Milton Keynes.About UsWelcome to Wisetek, a global leader in IT asset disposition (ITAD), secure data destruction, reuse, and technology manufacturing services. Founded in 2007, we have grown to become a world-class provider of IT...

  • Warehouse Operations Manager

    1 month ago

    Milton Keynes, Milton Keynes, United Kingdom Great Bear Full time

    Warehouse Operations ManagerAt Great Bear, we are seeking a skilled Warehouse Operations Manager to oversee the day-to-day activities of our warehouse team. As a key member of our operations team, you will be responsible for ensuring the smooth and efficient operation of our warehouse, including managing inventory, coordinating shipments, and supervising a...

  • Senior Technical Architect

    4 weeks ago

    Milton Keynes, Milton Keynes, United Kingdom Summer Browning Full time

    Job Title: Senior Technical ArchitectAbout the Role:We are seeking a highly skilled Senior Technical Architect to join our team at Summer Browning. As a Senior Technical Architect, you will be responsible for designing and implementing technical solutions that meet the needs of our clients.Key Responsibilities:Design and implement technical solutions for...