City of London, London
£70000 - £80000 per annum + bonus + bens
The Harrington Starr recruitment group are looking to place a seasoned BI Developer who is ready for a new permanent career challenge. This role will combine the elements of best practice Datawarehousing with new greenfield project implementations. This opportunity will see the successful post-holder further their career in the world of Financial Services.
This role will ideally suit a Senior BI Developer who is looking to move into an BI Architectural type role.
Ideal start date will be November 2019 but highly negotiable subject to each application.
Based in the heart of the Square Mile, you will be joining a team of Developers that understand how to get the very best out of their system, but yet strive to push the technical boundaries for maximum client benefit.
You will be coming into the team at grass roots level to assist with the design & build of a new reporting solution with data sourced from a variety of processing platforms.
From day one, you will be encouraged to bring new ideas to the table and work in deep collaboration with your co-workers, thus helping to create a hotbed of technical innovation and progression within the department.
Some of the key responsibilities for this Datawarehouse Architect will include the following tasks.
Work collaboratively within a global team spanning 4 continents.
Sit in on daily meetings between London and New York.
Help to provide hands‐on development using SQL Server
project managers, business analysts and development lead liaison,to assist in the build of a strategic reporting solution.
Develop, test, and integrate code for existing data warehouse development in compliance with client wide data management principles and security controls.
Data integration documentation strategies for data flows between disparate source/target systems for data warehouse
Use SSIS, T-SQL, or dynamic SQL to create packages to load data from source systems to stage to DWH
Follow standard delivery methodology from Development, Testing, UAT and Production.
Assist with and promote design guidelines, best practices and standards
To qualify for this role we require the following core Skills:
Minimum 6 years strong hands on development experience in SQL Server Integration Service (SSIS) development, scripting development, error checking, performance tuning, job scheduling, and deployment methodology.
Minimum 4 years of experience in SQL Server database development such as SQL, XML, function, procedure, indexes, table partition, and query optimization.
Solid experience in large complex 1TB + data warehouse environment and strong knowledge in ETL and data warehouse methodology.
Must be able to understand the project development life cycle
Advanced skills and experience with data modelling and enterprise data marts.
Have an awareness of modern data warehouse design and Erwin Data Modeler
It will be advantageous to have awareness of Cloud technology
Must be a good team player and can work autonomously
Ability to work in agile and fast pace environment
Must have experience of large, complex blue-chip enterprise, ideally Banking
Our client is able to wait a reasonable time for the right candidate so please apply if you are on extended notice or more immediately available.
To re-cap this is a superb opportunity to join an award winning Datawarehouse team giving yourself the opportunity to take your career to new levels. Working with a global team you will have the ability to put your own stamp on your work from day one. You will be working with highly motivated, like-minded Datawarehouse professionals all looking to make a difference to the technical landscape. The client embraces a healthy work/home balance within the teams and truly understands the benefits this will bring to the business.
The Harrington Starr team look forward to hearing from you for a discreet debrief on the vacancy.