Database Developer - Data & Analytics - 6 Month contracts - £454 Per Day Outside IR35

For this role you will be eligible to work through your limited company

Your new company

I am recruiting for one of the largest transport organisation in the UK

Your new role

You will be joining a large development project, being part of a scrum team responsible for major development of a new data warehousing environment. With multiple large scale complex database servers/ systems mainly in SQL/ Oracle databases the client is looking on developers who are experienced in creating various data reports/ ETL Frameworks and custom tools.

You will have extensive and fully conversant knowledge of on premise cloud systems such as APS, MS Azure as a large focus is the creation and migration of a large set of data to on premise systems or onto cloud servers.

What you'll need to succeed

• Data Analytics
• BI
• ETL Environments

For this role you will ideally have been involved in creating various data reporting tools/ Custom ETL tools in on premise cloud based or hybird Oracle and /or Microsoft Database technology in particular ETL/ELT Design, Development on testing in Microsoft SQL Server 2008 upwards, SSIS and MS Azure cloud servers.

Current up to date knowledge on ETL/ELT Data warehousing, Business Intelligence methodology and best practice including dealing with Big Data, Cloud technology and unstructured data.

Understanding of Star Scheme structure & Design, Detailed understanding of Kimball & Inmon and hybrid data warehouse design.

Experienced in Agile development approach and tools.

What you'll get in return

You will be given the opportunity to work on a large scale data warehouse development project working on the latest technology.

What you need to do now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you but you are looking for a new position, please contact us for a confidential discussion on your career.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk

SQL Developer - Public Transport Organisation - 6 months Outside IR35 - Immediate Start

For this position you will be eligible to work Outside IR35 - through your Limited Company

Your new company

One of the largest Public Transport Organisations in the UK

Your new role

SQL Developer

What you'll need to succeed

My client is looking for a SQL Developer to join the organisation on an initial 6 month contract.

Essential:

• SQL Server 2008 onwards, TSQL, PL/SQL,
• Azure/Cloud Experience
• Data and Analytics background

Accountabilities:

The post holder will have responsibility for the successful development of technical data and analytics solutions providing quality data required to support evidence based business and operational decision making.

You will be forming part of a scrum agile team and develop to specification, unit test and implement extract/transform/load (ETL) processes using custom ETL or ETL tools.

• To develop data and analytics solutions using industry best practice so that the code delivered is running, meets business requirements and definitions, conforms to Data & Analytics design specifications and has the controls and checks in place to satisfy audit/finance guidelines
• To document the technical design of developed components in accordance with Data & Analytics standards
• To develop to estimated timelines or update management of deviations to these estimates.
• To raise critical technical issues to the Development Stream Lead/Technical Delivery Manager that may impact on the timeline
• Working with their scrum agile team members, to undertake and support unit and regression testing of the codebase to ensure it can be delivered and meets business/operational requirements and can be run in a system testing environment.
• To undertake fixes to the code, where necessary
• To undertake performance tuning of where required

Knowledge:

• Detailed working knowledge of ETL/ELT, data warehousing/business intelligence methodologies and best practice including dealing with big data, cloud technology and unstructured data and the relative required approaches
• Knowledge of star schema structure & design, detailed understanding of Kimball & Inmon and hybrid data warehouse design
• Understanding and experience of Agile development approach and tools

Skills:

• Extensive use of and fully conversant with on premise Microsoft database technologies in particular ETL/ELT design, development and testing in Microsoft SQL Server 2008 onwards , TSQL, APS, Azure, SSIS RAC SQL, PL/SQL, ODI and OBIEE
• Expert at writing/reading complex queries, performance tuning & monitoring
• Skilled at solving and communicating problems collaboratively, applying knowledge and technology to the full
• Strong analytical skills
• Proficient at use of standard computer packages

Please note that the the role will have a 3 stage interview process, thus commitment to the whole hiring process is required.

What you'll get in return

This is a fantastic opportunity to join a high profile project working with one of the largest public sector organisations in the UK.

What you need to do now
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you but you are looking for a new position, please contact us for a confidential discussion on your career.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk