Jan
23
Lifecycle Analyst
January 23, 2023 | Comments Off on Lifecycle Analyst
- Be responsible for providing Kier FM with innovative, complex and robust solutions to enable informed decision making, streamline processes and drive the growth of the Business Intelligence culture.
- Working with large amounts of data and manipulating it in a number of ways, to ultimately provide the ability to report to internal and external stakeholders of the business.
- Responsible for managing development with regards to BI and MI reporting
- Work with Group IT to define a rationalised reporting toolset based on Strategic BI goals of Group and FM IT
- Use SSIS to extract, transform and load data
- Use SSAS to design multi-dimensional models and ensure all databases work accurately and consistently
- Development of strategic BI roadmap and implementation plan
- Assist in the delivery of the BI strategy for Kier Facilities Management IT
- To adhere to the standards, policies and best practice for the use of information systems
- Experience with SQL Server 2008 R2 onwards
- Strong ETL experience using SSIS
- Data Warehouse design / development
- Strong knowledge of Microsoft BI reporting tools (SSRS, SSAS) and other reporting tools e.g. Power BI
- Experience in the support and development of data analysis frameworks that support operational reporting and executive dashboards
- Experience in designing, documenting and delivering strategic BI solutions
- Must have a strong attention to detail
- Must have excellent written and verbal communication skills. It is important that the jobholder can liaise confidently with all levels of staff
- Must have a methodical and analytical approach