Lead BI Developer - 12 Month Contract - Outside IR35!
Recruiter
Evolution Recruitment Solutions Ltd
Listed on
19th October 2019
Location
Bletchley
Salary/Rate
Upto £85000
Type
Contract
This job has now expired please search on the home page to find live IT Jobs.
My global logistics client are looking for a lead Bi developer to come and join them on a contract basis to work on an exciting new Data Warehouse project.You will be joining a team of talented developers to lead the charge with implementing the BI Architecture and work on the Data Programme.
We are looking for a highly experienced BI developer who is proficient with full use of the Microsoft BI Stack. It is essential that you are experienced with:
Developing ETL solutions utilizing SSIS including Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.Dynamic and Advanced SQL queries in MS SQL Server 2012, and extensively experienced with SQL / T-SQL / SSIS / SSRS.Writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using T-SQL.Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.Creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation, integration and consistency.Entity-Relationship/Multidimensional Data Modelling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server Analysis Services (SSAS).Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML/SQL/Oracle) to different targets (DB/Files)Tabular reports, matrix reports, parameterized reports according to business requirements in time restricted environment using SQL server reporting services (SSRS). Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages. Experience working in an Agile Environment.Developing Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2012/2008R2. Experience writing technical specifications for work to be performed by other developers.Development experience in Transact SQL / C# with good software methodology/practices. Good working knowledge of Oracle preferred.If the above sounds like a great fit with your skills/ experience and you're keen to hear more about this exciting opportunity, send your CV through the advert and I will call you back with more details.
