Business Intelligence (BI) and ETL Developer

	Details
	Reference M / Dev 23936 Job Roles I.T Sub-Job Roles Analst Database Developer Developer Other IT Roles System Design Salary £300 to £450 per day Town/City Surrey / London Locations London Surrey Contract Type Tempory

	Description
	Job Description: We are looking for a Business Intelligence and ETL Developer to work on greenfield solution who will be able to understand and analyse requirements and develop BI solutions using Microsoft Business Intelligence tools and underlying technologies like SSIS, SSRS, SSAS Excel Services and PerformancePoint. Responsibilities: •Work with business analysts, business users and other stakeholders to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI solutions. •Develop ETL scripts in best practise to load data from host systems into a conformed Kimball datawarehouse.Ensure conformed consistent reliable load, developed for stage testing and audit •Ensure complete mapping of data from source to warehouse (audit, traceable) •Utilize Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Dimensions, and Cubes while adhering to enforced best practice development methodologies. •Work with other members of team and business to ensure agreement of DWH structure, data mapping and load, resolving any outstanding issues to ensure completion of project •Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests. Convert existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products. •Identify project risks and impediments, notify management, and proactively work with other members of the team to complete assigned tasks as defined by project scope, timelines, and budgets. •Determine testing needed to assure the functionality and integrity of reporting solutions, create test plans, and evaluate testing results taking corrective action as necessary. •Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling. •Participate in evaluating and analysing utilities and tools offered by BI applications/tools vendors. •Prepare technical documentation, ensuring handover to current business team

	Qualifications Required
	Skills: •Quick learner. •Analytical, Problem solving, creative thinking and design skills. •Bachelor’s degree, preferably in Computer Science or equivalent professional experience. •Experience building business Intelligence solutions (OLAP databases, reports, dashboards, scorecards) using Microsoft Business Intelligence technology stack SSIS, SSRS, SSAS, PPDD and MDX in a data warehousing environment. •Hands-on experience with MS SQL Server 2008, preferably R2 •Experience with Talend and interfacing SQL with other technology databases (Informix, Oracle) •Knowledge of and OLAP/MOLAP technologies and dimensional modelling, including applicability to various reporting problems. •Experience in building cubes and programming complex SQL queries and stored procedures. •Experience with SharePoint BI implementation and development. •Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples). •Proficiency with MS Excel, Access, Visio, and Project is desired. •Experience in gathering and analysing business requirements. •Good written / oral communication skills. •Demonstrated success working in a team-based environment.

Email a friend Print details Back to results

	Application
	Job Business Intelligence (BI) and ETL Developer Ref M / Dev 23936 Job Roles I.T Locations London Surrey Your First Name* Your Last Name* Your Email* Confirm Email* Attach Your CV* Enquiry Source Select Enquiry Source... Direct Mail Google MSN Newspaper Other Search Engine Other Source Personal Contact Word Of Mouth Yahoo Covering Letter   submit