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