Lead BI Architect-SQL Server Data Warehouse & ETL(INSIDE IR35)
Recruiter
Listed on
Location
Salary/Rate
Salary Notes
Type
Start Date
This job has now expired please search on the home page to find live IT Jobs.
My Client, a large is currently looking for a Lead BI Architect to support a SQL Server 2008/R2 Data Warehouse Review/Upgrade. The contract is expected to be for 4 months.
High Level Tasks:
*Undertake a high level audit of the Extract Transform and Load (ETL) data workflows running in a SQL Server 2008R2 Data Warehouse
*Review the workflows and datasets with business stakeholders (including Strategic Planning, HR, Finance) to determine which ETL processes data sets are in use by the business and adding value, in order to determine whether they should be part of the migration plan to a new SQL Server Platform
*Design of new SQL Server DWH platform and liaising with internal infrastructure teams to provision this according to requirements and best practice patterns
*Migrate data and ETL workflows from SQL Server 2008R2 platform to newly provisioned and supported environment
*Capture the Strategic Planning Team's requirements for access to data via Native Data Store / Operational Data store to perform their own data exploration and transformation workflows and recommend appropriate and secure access methods and controls
High Level Skillset and Experience Required:
*Proven experience of working collaboratively with business stakeholders at all levels as well as technical teams
*Proven experience of capturing business requirements and translate into technical design
*Proven experience of reviewing ETL processes and upgrading Microsoft 2008R2 BI Stack DWH platforms
*Data warehouse design and implementation
*Technical skills to manage and perform upgrade and migration of ETL Processes and SSIS solutions from 2008R2 environment to currently supported SQL Server platform
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 The Queens Award for Enterprise: International Trade 2015.