Current Vacancies | Dwr Cymru Welsh Water
Dwr Cymru Welsh Water
dwrcymru - SQL ANALYST | Dwr Cymru Welsh Water

Search by Keyword or Location


Apply now Job no: 494864
Work type: Permanent
Location: Cardiff
Categories: Retail

Salary: Band 05 (£27,128 - £29,647)

Location: Linea

What you will do

Work with the Planning & Analytics SQL Server Team, to help to manage our Data Warehouse and develop Business Intelligence solutions.  This involves designing, coding and testing the development of SQL Server scripts.  To allow us analyse data, create reports and update our data warehouse. 

What you’ll be responsible for

  1. Analysing Data from various business systems, joining data together, creating complex business calculations and dissemination of data to end users.
  2. Consult with business stakeholders to understand their business needs and requirements.  Create a backlog of development items and manage the prioritisation developments as required.
  3. Design, code and test the development of SQL Server stored procedures and SQL Server Integration Services packages.
  4. Work with the SQL Server team to help with the design and development of Retail BI data warehouse, including development of Extract, Transform, Load procedures.
  5. Represent data through reports and data visualisations, to aid with Business Decisions.
  6. Ensure that data and records presented accurately, ensure data in reporting solutions can be relied upon for decision making and is refreshed regularly.
  7. Creation of Data Extractions to aid with Ofwat regulatory reporting.
  8. Create technical documents to outline database objects and business procedures created.
  9. To ensure the General Data Protection Regulations and all other relevant legislation and policies are complied with in the delivery of the duties of the post.
  10. To ensure that the environment is governed according to access and security policies.
  11. Effective prioritisation and escalation of issues as required.

What we offer

We know that if our employees are happy, our customers are happy. That’s why we offer a great benefits package. As one of the biggest companies in Wales, our reward and benefits package includes:

  • Generous Pension Plan
  • 24 days annual leave plus public holidays
  • Childcare Voucher Scheme
  • Full Training Provided
  • Onsite restaurant and car park

Position description

Advertised: GMT Standard Time
Applications close: GMT Standard Time

Back to search results Apply now Refer a friend

Share this: | More