Job description

Job title: Database Developer

Reporting to:Data Architecture Manager

Job Family:Technology

Job Family Level:D2

Role Purpose:

Responsible for design, development and management of a data warehouse environment used for analytics and reporting in Microsoft domain.

Key accountabilities

You will be responsible for:

  • Working closely with the Data & Business Intelligence managerand internal customers across NMC to design, develop and maintain reports / analytics capability.
  • Working with the Data Architecture Manager/Business Analyst to identify and resolve data issues through configuration of Data cleansing and de-duplication software.
  • Managing the database aspects of the reporting and analytics platform(s) to ensure that reporting jobs are successfully run and analytics data aligns to timeliness / completeness requirements.
  • Working with database administrators (NMC and external suppliers) to ensure that the data warehouse is tuned for optimal performance.
  • Working with business analysts and project managers to develop and refine reporting and analytics requirements.
  • Ensure that the physical designs for the data warehouse and its data structures align with NMC IT strategies, NMC architecture frameworks and logical data models.
  • Ensure that data flows configured internally within the data warehouse are reflected in as-built documentation (data lineage diagrams) where 75% of new marts should have documentation available immediately on production release and 100% of new marts should have documentation available within 30 days of production release.
  • Ensure that all data warehouse issues are communicated across the data management team immediately after the issue occurs.
  • 80% of causes of data warehouse job failures identified and resolution achieved on same day.

Other Responsibilities

There are a number of standard duties and responsibilities that allemployees, respective of their role and level of seniority within the NMC, are expected to befamiliar with and adhere to:

  • To comply at all times with the requirements of Health and Safety Regulations to ensure their own wellbeing and that of their colleagues.
  • To promote and comply with NMC policies on diversity and equality both in the delivery of services and treatment of others.
  • To ensure confidentiality at all times, only releasing confidential information obtained during the course of employment to those acting in an official capacity in accordance with the provisions of the Data Protection Act and its amendments
  • To comply with NMC protocols on the appropriate use of telephone, email and internet facilities.
  • To comply with the principles of risk management in relation to individual and corporate responsibilities.
  • To comply with NMC policies and procedures as compiled on the organisation’s intranet.

This job description is not exhaustive and as such, the post holder will be expected to be flexible, and any changes will only be made following a discussion with the post holder.

Person specification

Job title:Database Developer

Qualifications and experience

  • Bachelor`s degree in a related area; master`s degree (or equivalent work experience) and Microsoft certifications are a strong plus.
  • Proven experience with Microsoft SQL Server Integration Services (2008, 2012 and 2014)
  • Strong commitment to deadlines and to client service (internal and external)
  • Strong verbal and written communications skills.
  • Strong organizational skills and attention to detail
  • Proven collaboration skills when interacting with both technical and non-technical resources.
  • Operates well within a team as well as independently
  • Self-motivated and driven to produce quality products
  • Proven judgment in proactively identifying issues and recommending solutions to others.
  • Ability to work well and deliver under pressure.
  • Provenexperience working on database technology used for business intelligence and/or analytics (SSIS, SSAS Tabular , SSRS and Crystal Report)
  • Proven experience administering a reporting database.
  • Proven experience working with query languages including T-SQL, XML, DAX, MDX, Power Shell and PL/SQL.
  • Experience with analysing complex requirements
  • Experience in working with both Agile/RAD methodologies and SSADM or equivalent.
  • Waterfall methodologies.
  • Experience in creating / maintaining as-built documentation owned jointly across a team.
  • Proven experience working as a database developers to ensure reporting data sources are optimally tuned for reporting.

Skills,knowledge and abilities

  • Having a good experience of queries optimization and performance tuning
  • Develop and prepare schedule for new data warehouse.
  • Prepare plans for all ETL procedures and architectures.
  • Analyse various data warehouse objects.
  • Prepare ad hoc queries reports for both technical and business teams.
  • Evaluate all codes and ensure quality of all project deliverables.
  • Design and implement various unit tests on system and prepare test data.
  • Experience of using any Source Control Software like Team Foundation Server/VSS/SVN
  • Experienced in using any Agile Project Management tool like JIRA
  • Experience with Microsoft Power BI visulaization and Modelling

Personal qualities

  • Willingness to challenge underlying assumptions and the status quo.
  • Highly developed communication and influencing skills.
  • Resilient and self-confident to drive through change.
  • Confident in presenting findings to the senior stakeholders

TBI21st April 2017Page 1 of 4