BI Developer - MS BI stack

ChilliFrog ,
Bournemouth, Dorset
Job Type: Full-time
Salary: £40,000 per annum

Overview

JOB OVERVIEW : BI Developer (MS BI stack) / Business Intelligence Developer sought by a leading UK healthcare company. Video interviews and AT LEAST 2 days home-working per week and video interviews Head office is based on the border of Bournemouth / Poole for a permanent employment contract. Great opportunity to work with a diverse cutting-edge tech stack VIDEO INTERVIEWS due to Covid-19 2 days per week home working (at least) is available from the outset. Salary : Negotiable depending on experience - C£40,000- C£45,000 basic salary p.a (possibly more for a very strong candidate) plus excellent benefits package Location :- Bournemouth / Poole border but 2 days per week remote working is available - could be further flexible due to Covid-19. THE COMPANY:- For decades, my client has been providing unrivalled healthcare services. Their services continually evolve and develop to meet the needs of the local community. The post holder will play a key role in developing, maintaining and evolving the business intelligence strategies and processes required to maintain, develop and support the Programme’s data warehouse and Business Intelligence analysis, reporting and presentation tools. You'll support the provision of a centralised information source, team/location performance and business intelligence, You'll also become part of a great team who takes pride in making a positive difference to the Healthcare industry for everyone's mutual benefit THE ROLE:- My client has a number of fantastic new opportunities for Business Intelligence Developers / BI Developers to join the rapidly expanding team. You will; - Provide technical solutions to enhance the Programme Data Warehouse and Business Intelligence solutions. - Maintain technical, professional and specialist knowledge and understanding - and be competent in the use of a wide range of specialist software packages and programming languages including but not limited to Microsoft SQL Server, T-SQL, SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services, Microsoft Power BI, and Power Pivot. You may also have exposure or an awareness of MS Azure, ADF (Azure Data Factory), Team Foundation Server (TFS), GIT and/or DevOps OR be keen to acquire such exposure - Contribute to the design, development and improvement of Business Intelligence solutions and manipulation of relevant data sources. - work with the Information and Applications Teams in the development of statutory returns, standard and bespoke reports utilising data warehouse and data feeds. - ensure all required data is available in the data repository and to manage the specification and coordinate the development if not. - Be responsible for active maintenance of the data repository ensuring integrity, consistency and relevant documentation. Ensuring smooth operation of ETL processes and high availability of Business Intelligence infrastructure. - Participate in the development and strategy for data migration when changing providers or decommissioning legacy systems ensuring continuity of service. - Maintain full compliance to the system and data architecture, standards and procedures CANDIDATE PROFILE; - Competent with SOME of the following languages / tools; - Microsoft SQL Server, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), Microsoft Power BI, Microsoft SharePoint, Performance Point, Power Pivot, MS Azure, ADF (Azure Data Factory), Team Foundation Server (TFS), GIT and/or DevOps. - Strong competency with SSIS is more important than SSAS or SSRS - Educated to degree level in computer or information science - Recognised qualifications in MS SQL Server technologies - Experience in developing OR working with large scale ETL solutiions - Knowledge and experience of developing and implementing Power BI reporting solution advantageous not essential - knowledge / awareness of data warehousing theory and methodologies - knowledge / awareness and skills in data modelling, and or database architecture design advantageous - Good understanding of Data Quality and ability to develop data quality reporting mechanism WHAT'S ON OFFER:- Along with the chance to work with a growing global market leader who offers a superb working environment, company culture and very high staff retention ration my client offers; - A highly competitive salary, continuing professional development and ongoing training - A truely collaborative style of working and the opportunity to work with an extremely well-respected Lead Developer and Head of BI keen to further develop your skill set. - 2 days per week remote working - An extremely pleasant and professional working environment with like-minded BI enthusiasts. IF you are a strong match to the specific requirements for this role then please apply with a CV as soon as possible. Candidates who are not a close match sadly cannot be considered. Keywords; Business Intelligence, SQL Server, BI, SSRS, SSAS, SSIS, reports, reporting, Database, DBA, data warehouse, software developer, engineer, programmer, Microsoft SQL Server, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), Microsoft Power BI, Microsoft SharePoint, Performance Point, Excel and Power Pivot, MS Azure