Microsoft BI Developer

Microsoft BI Developer required by Whitehall Resources for a 3-6 month contract based in West Midlands

Responsible for the design, creation, testing and documenting of new and amended programs from supplied specifications in accordance with agreed standards. The provision of application maintenance and support services, either directly to users of the applications or to service delivery functions.

Key Accountabilities

– Designs or undertakes impact analysis of small to medium size solutions or partial solutions within an established architecture.
– Schedules and monitors own work, escalating problems and queries to higher levels to ensure timescales are met.
– Contributes to and may produce project plans for medium size solutions or partial solutions.
– May schedule and monitor the work of others in team management situation.
– Collates and is responsible for proposals and bids (0 – 100 days), of which some work packages will be undertaken by others. This may also include responses to change requests.
– Contributes to solution reviews.
– Produces high quality solutions and documentation through the use of a structured approach for problems with medium complexity.
– Has identified and implemented ways to exceed customer expectation.
– Fluently presents complex technical information to technical and non-technical audiences both orally and in writing.
– Can give clear and concise instructions to those that they are providing guidance to.
– Communicates issues in a timely manner.
– Influences own team by leading elements of team meetings, peer review of deliverables etc.
– Has influence and creates a positive impact outside of their own team, e.g. by contributing to other team meetings, peer review of deliverables from other teams etc.
– Works influentially with the customer to discover, document and prioritize requirements.
– Adheres to corporate and local methodologies as appropriate.
– Adheres to corporate and local processes.
– Has played a lead role in developing and/or tailoring some local processes.
– Keep abreast of technology developments within their own specialism.

Required experience:

– Strong TSQL development with recent practical experience in data warehouse design implemented with Kimball methodology using conformed dimensions.
– Extensive experience in development of ETL framework using SSIS to extract, transform and load the data into dimension and fact tables in a data warehouse.
– Extensive knowledge of Microsoft SQL Server database programing.
– Experience with BI Stack covering integration services, analysis services and reporting services.
– Significant Architectural experience

Essential Skills Required (Expert level, minimum 3+ years)

– SQL Server 2012 or above
– Database programing
– ETL design
– Data Warehouse design
– MSSQL SSIS
– MSSQL SSAS (multidimensional and tabular)
– MSSQL SSRS
– T-SQL, MDX


All of our opportunities require that applicants are eligible to work in the specified country/location, unless otherwise stated in the job description.