Data Warehouse Architect - SC Cleared
LA International Computer Consultants Ltd
This job has now expired please search on the home page to find live IT Jobs.
An experienced contract Data Warehouse Architect for 12 months with expertise across the full data warehouse development lifecycle who will work alongside the client Data Architect on the programme. The successful candidate will be required to support:
*The development of logical data models for areas of the business (such as Supply Chain & Engineering) collaborating with US based colleagues
*The develop & documentation of dimensional models for business processes with input from SMEs
*The technical team with implementing dimensional models whilst following best practice
*The implementation of dimensional models by writing ETL code
*Support upskilling of junior staff
The current technology stack being used is an on-premise PostgreSQL database with a combination of Nifi to load the data into Staging and PL/pgSQL to load the dimension and fact tables. Whilst it is expected the successful candidate would have extensive experience implementing dimensional models the exact technologies they have done this in is less important.
*Working with Business Analysts & SMEs to design & document dimensional models
*Creation & documentation of data lineage documentation
*Assisting the technical team with following best practice in data warehouse development
*Writing ETL code to populate dimensional models as required
Proven experienced in the building of data warehouses
Extensive knowledge of designing dimensional models
Extensive knowledge of implementing dimensional models
Knowledge of DAMA principles
Knowledge of PL/pgSQL & Nifi
Due to the nature and urgency of this post, candidates holding or who have held high level security clearance in the past are most welcome to apply. Please note successful applicants will be required to be security cleared prior to appointment which can take up to a minimum 10 weeks.
LA International Computer Consultants Ltd is an HMG Approved Consultancy and operates as an IT & Engineering Consultancy or as an Employment Business & Agency, depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, we welcome applications from all sections of the community and from people with diverse experience and backgrounds.
Award Winning LA International Computer Consultants Ltd (Recruiter Awards for Excellence - Best IT, Best Public Sector & Gold Awards) and the most prestigious award, that any business can receive, won in consecutive years, The Queens Award for Enterprise: International Trade;