BI SQL Developer

  • Location

    London, England

  • Sector:

    Data

  • Job type:

    Contract

  • Salary:

    Up to £400 per day

  • Contact:

    James Jarvis

  • Contact email:

    james.jarvis@xcede.co.uk

  • Job ref:

    HQ00029074_1568119053

  • Duration:

    6-12 Months

  • Startdate:

    ASAP

SQL DEVELOPER / ETL / DATA LOAD / SSIS / ALTERYX / TABLEAU

BI SQL Developer
Rate: £400PD
Start: ASAP
Location: London
Duration: 6 Months

My client based in London are in need of a SQL Developer to join them on a contract basis.

Role:

To develop data automation solutions for key processes that are currently heavily manual as well as new on-boarding processes. As a Microsoft SQL stack developer, you will automate the data loading processes for several different solution streams. You will work with other BI developers to design and implement the solution. You will work closely with the business users as well as the BI team members to ensure they deliver to spec and time, continuously improve existing solutions and assist the business by ensuring data is readily available for reporting and analysis.

Key Responsibilities:

- Provide data loading and SQL/ETL development support across BAU activities
- Build solutions based on the business requirements and the problem to be solved
- Work on business projects using the Kanban methodology to develop, enhance and support database and ETL solutions
- Automate manual data tasks through development of ETL solutions
- Integration of multiple data sets into a single consolidated database
- Data profiling and analysis as required to support Business Analysts in technical requirements gathering

Essential

- Experience developing Microsoft SQL Server solutions (2012 or above)
- Strong experience with Microsoft Integration Services (SSIS)
- Strong experience with T-SQL, stored procedures, triggers, cursors and window functions
- Scheduling jobs using SQL Server Agent
- Supporting peer review, QA and user acceptance testing processes
- Good grasp of delivering incremental value through Agile Scrum and Kanban methodologies
- Ability to scope, estimate and deliver committed work on time, on own and as part of an agile team

Desirable

- Experience with Alteryx
- Experience with Tableau
- Experience with Microsoft Reporting Services
- Experience with Microsoft Access applications
- Experience with SVN (ideally) or Git Hub
- Experience with AWS
- Experience with Data Lake