Data Warehouse Developer - Tyne & Wear

This vacancy is now closed
Salary: £50,000.00 max. - Other
Ref: 248 Date Posted: Friday 10 Aug 2018
LinkedIn ShareShare
More

We are working with a Private Sector company based in Newcastle who are looking for a Data Warehouse Developer on a permanent role with a salary of up to £50,000.00 on offer. This is an exciting role to work with a successful and growing company in their Newcastle office and you will be responsible for designing data models to proactively drive business intelligence to their internal managers, customers and suppliers.  This role will be responsible for designing and building ETL solutions to extract, clean, conform, and deliver data to the warehouse and build standardised reports and dashboards that will inform stakeholders and improve quality assurance to our clients information.

Key Responsibilities

Technical

  • Develop solutions on a Microsoft SQL database platform, utilising both SQL Server Integration Services (SSIS) and Server Analysis Services (SSAS)
  • Design and develop ETL routines from various systems and sources
  • Develop and maintain standards of all data warehouse and ETL
  • Monitor ETL server and databases and ensure optimal performance
  • Administer databases and resolve all issues to ensure data accuracy
  • Develop standardised reports and dashboards using PowerBI to proactively promote business intelligence to internal and external userbase
  • Translate user requirements effectively into solutions
  • Develop an extensive and detailed knowledge of systems and processes
  • Create and maintain documentation of systems, tools and processes
  • Keep abreast with the latest tools and techniques

General

  • Treat all information as confidential and adhere to GDPR
  • Maintain a professional image at all times and to behave in harmony with the company values
  • Demonstrate commitment to equality and diversity and ensure that this is integrated into all activity
  • Undertake any other tasks which are commensurate with the level and responsibilities of the post

Experience Required:

  • 3+ years previous experience in data warehouse design and development
  • Expert knowledge of Microsoft SQL database, SQL Server Integration Services (SSIS), Server Analysis Services (SSAS) and PowerBI
  • Experience of delivering solutions that align with data governance principles for data quality and data security
  • Superior attention to detail combined with strong analytical and problem-solving skills
  • Able to interpret data into influential insights
  • Able to work in a fast-paced environment and meet specific deadlines
  • Good communicator and work well with your colleagues to deliver high-quality solutions
  • Happy to work collaboratively receiving and giving support and advice
  • An understanding of strategic sourcing and procurement processes would be desirable