BI Developer

BI Developer

Job Title: BI Developer
Contract Type: Contract
Location: Hertfordshire, England
Salary: £350.00 - £360.00 per day
Start Date: ASAP
Reference: HQ00074924_1529919667
Contact Name: Kieran Aldred
Contact Email:
Job Published: June 25, 2018 10:41

Job Description

BI Developer - BI Consultant - Hertfordshire

We are seeking a Microsoft Business Intelligence Developer with strong SSIS skills, and data warehouse model and design experience. The role will incorporate a large degree of project work along with some business as usual support and maintenance with an emphasis on continuous improvement. This is an opportunity to play a significant role within the Data Analytics team, help create a best in class data environment for the business.

Key Accountabilities:

*Creating data models, developing ETLs and validating results with stakeholders
*Monitoring and tuning queries and data loads
*Addressing user questions concerning data integrity
*Monitoring performance and communicating functional and technical issues
*Provide day to day to support for the existing solutions
*Carry out detailed design and development of ETL using SSIS
*Delivering all necessary ETL development work (technical specifications, coding and unit testing) required to support the delivery
*Report progress of ETL / Cube development work against agreed plans, taking necessary action to keep development in line with agreed timescales
*Flagging any issues to the Data Change Manager of any deviation from the planned schedules along with suggested corrective actions
*Documentation on development, testing and deployment tasks
*Provide post-live support for all ETL / data warehouse development

Essential skills:

*An excellent understanding of Management Information/Business Intelligence/Analytics
*Extensive experience in the Microsoft BI Tool-stack on Data Warehousing projects
*Hands-on experience in delivering data warehouse solutions
*A strong database knowledge and experience, including maintenance, optimisation, trouble-shooting
*Extensive experience in Microsoft SSIS
*Strong database skills in SQL Server- T-SQL, Stored procedures, Triggers, Functions, Indexes, Constraints and MDX
*Strong understanding of Data Warehousing concepts and dimensional data modelling
*Experienced in designing architecture for Data Warehouse/Cubes for performance, capacity and stability
*Experience building data-marts and data warehouses
*Experience of high-volume Database performance tuning techniques
*Ability to work independently as well as collaboratively
*Strong attention to detail and accuracy
*Experience of working on with Salesforce would be beneficial

Desired Skills:

*Knowledge / experience with SSRS and Power BI would be advantageous
*Cube development using SSAS within the agreed methodologies, standards and quality levels
*Experience using HDinsight/Cosmo DB into Azure.
Some experience of bringing internal and external data together to provide insight.

BI Developer - BI Consultant - Hertfordshire

Lawrence Harvey is acting as an Employment Business in regards to this position.
Visit our website and follow us on Twitter for all live vacancies @lawharveyjobs