• Location: Watford, England
  • Salary: £40000 - £45000 per annum
  • Technology: Microsoft BI Jobs
  • Job Type: Permanent
  • Date Posted: 20th Oct, 2020
  • Reference: 201020jd

SQL Developer - SSIS - Power BI - Finance - Watford - £45K


Client based in Watford are on the lookout for a talented and enthusiastic SQL Developer to join the team.


The company put a big emphasis on personal and professional development and are happy to support their staff with qualifications, training and paying for events and courses.


They are looking for someone with experience working with SQL Server on a day to day basis with some exposure to wider BI tools (SSIS and Power BI). Ideally you will come from a financial services background but this isn't essential.



Role & Responsibilities



  • Contribute toward the development of our enterprise data warehouse strategy.

  • Ensure the smooth running of all processes that use or derive data from data feeds.

  • Help develop robust data reconciliation infrastructure.

  • Design, modify and test Extraction-Transformation-Loading (ETL) packages and reports using SSIS and Power BI.

  • Detect missing, corrupt or duplicate data from external sources.

  • Ensure the quality and value of Standard Operating Procedures pertaining to raw and derived data flow processes



Skills & Qualifications



  • Good experience across the MS BI stack.

  • T-SQL: proficient in querying, views, stored procedures and window functions.

  • SSIS: ETL creation, frameworks, performance tuning.

  • Developing reports and dashboards in Power BI.

  • Data management and Data Quality experience.


Benefits



  • Salary of up to £45,000

  • Support with training and development (qualifications, courses and industry events).


To apply for this role, please send an up to date CV to Jay Dixon j.dixon@nigelfrank.com or call 0191 255 1427 for a catch up in complete confidence.