We are looking for a proactive and enthusiastic MI Developer to design, build and deliver new automated reporting solutions in line with business & customer requirements.
This is a real opportunity to shape future business intelligence for cap hpi by designing & delivering quality, fit-for-purpose BI solutions that enable effective, data-driven business decisions to be made. Reporting to the Head of MI & Data you will be joining a team of 6 and will predominantly work alongside 2 other MI Developers.
Your key responsibilities will include following BI project lifecycle steps to design, develop and deliver quality, fit-for-purpose reporting solutions, you will also develop, support and maintain ETL processes, reporting outputs and solutions.
You will provide effective and timely support in requests for ad hoc data analysis and reporting requirements and will work with the business sponsors to understand and gather reporting requirements carrying these through to quality, fit for purpose reporting solutions.
The role will also involve you providing quality assurance by carrying out regular data validation steps to ensure data processed by MI systems balances to source information. There will be a requirement in this role to form part of an out of hours on-call rota.
You should have experience in:-
• ETL Design & Development (Sagent Data Flow, Automate BPA Server preferable) and a good knowledge of ETL methodologies is essential
• Microsoft BI Stack: SQL Server, SSIS, SSAS,
• Data Analysis (Methodical & Analytical Approach)
• Data Management/ Warehousing (Kimball methodology)
• BI Project lifecycle documentation (business requirements, functional/ technical specification, user/ training guides)
With advanced knowledge of Microsoft Office suite, especially Microsoft Excel you should have a logical approach to problem solving with strong trouble shooting skills, and keen attention to detail.
You should have the ability to communicate at all levels and possess excellent interpersonal verbal and written communication skills.
An excellent team player you should also have the ability to work independently when needed, be able to deliver to tight deadlines and thrive under pressure.
To apply please complete your details below and attach your CV.