BI Developer

The One Group Ltd
03 Oct 2017
02 Nov 2017
Contract Type
Full Time
My Client is a retail bank which provides financial services to small and medium-sized businesses. It is listed on the London Stock Exchange and is a constituent of the FTSE 250 Index. My client is looking for a talented BI Developer who will be assigned to the MIS team to maintain and help evolve the organisation's data delivery and reporting with a focus on implementing best practices and adhering to my client's standards. The BI Developer must have full project lifecycle experience from dimensional modelling through to OLAP cubes and supporting end-user reporting. Experience in handling Big Data would be advantageous. The BI Developer will build and maintain BI infrastructure, artefacts and objects, documentation, unit testing and provide guidance to other team members and business users. The daily activities for this position include the design, development, documentation and debugging of data warehouse objects, ETL packages, OLAP cubes and reporting solutions. Key Responsibilities Include: - Design, build and manage dimensionally-modelled data warehouse. - Work with the Data Architect and MI team to create robust, best-practice driven data warehouse designs and ETL strategies. - Minimise duplication of data, ETL and logic to achieve the ''single source of the truth''. - Demonstrate the ability to understand overall system impacts while focusing on specific user requirements. - Maximise the timely availability of management information. - Adhere to the clients Data Standards. - Advise business users on best methods of accessing warehouse resources and assist with the design of efficient reporting solutions. - Strong analytical and interpersonal skills as well as reporting capabilities. - Strong communication and presentation skills both verbal and written. - Be creative, innovative, pro-active and convincing in terms of finding solutions. - Apply best practice approaches to assigned deliverables. - Participate in team discussions on a range of areas (quality, design, standards, peer reviews). - Act as an evangelist for Management Information and delivering high quality outcomes. Essential Skills required - SQL Server 2008/2012/2014. - ETL frameworks. - ETL design and development, preferable within SSIS. - Advanced Analysis Services experience including MDX scripting, partitioning and aggregations. - Front-end reporting including SSRS, Power BI and SharePoint/PerformancePoint. - Kimball dimensional modelling and DW methodology. - Experience of .Net within SQL Server, Analysis Services and Integration Services *********#). Desirable - Experience of Big Data and Data Lakes. - Experience within the banking industry. - Qualifications and professional memberships. - Competitive Salary - Bonuses - Pension min 3% company will match then it is dependent on age range between 3% -8% - 25 days holiday + 8 stats and opportunity to buy up to a max of 5 extra days per annum - Childcare voucher scheme available - Death in service 4 times salary - Income Protection - with Canada Life - Retail Discount - Travel Loan (on successful completion of probationary) - Cycle to work scheme With offices in Cambridge, Northampton and Peterborough - The ONE Group's recruitment specialists offer unparalleled recruitment expertise across seven specialist divisions; Accountancy & Finance, Executive Search, HR, IT, Marketing, Office Support and Technical. Whether you are looking to advertise a job, or take the next step in your career, we offer an ever-growing employment network, which currently exceeds 50,000 people in the East of England and The Midlands. We pride ourselves in adding value to any recruitment experience, with the foundation of our success coming from customer service, expert knowledge of the local marketplace and our understanding of the significant value people can add to the workplace. This isn't just recruitment, it's: Recruitment as it should be. For more information, call us or visit our website at *********************
This job was originally posted as