• Business Intelligence Analyst

    Job Locations UK-Manchester Business Park
    Posted Date 4 weeks ago(24/07/2018 09:56)
    Job ID
    # of Openings
    Information Technology
  • About Costain and your project.

    Costain helps to improve people’s lives by deploying technology-based engineering solutions to meet urgent national needs across the UK’s energy, water and transportation infrastructures.


     The primary focus of the role of Business Intelligence Analyst is the definition, design and implementation of business intelligence solutions using industry leading technology.

    What will I be doing?

    • Development and support of data management and integration solutions
    • Development and maintenance of the data warehouse
    • Report and data visualisation design using SAP BusinessObjects and Microsoft Power BI
    • Continuous support and user training for BI solutions
    • Lead and/or assist with the facilitation of interviews and workshops to gather requirements
    • Engagement with key stakeholders across the organisation to demonstrate and promote BI capability to grow the BI landscape
    • Provide secondary support to core business systems
    • Provide BI support to the wider organisation

    About you

    • Proven experience in developing and maintaining data warehouse solutions
    • Previous experience using business intelligence technology
    • Previous experience using ETL / data integration technology
    • Experience of 2 full lifecycle business intelligence projects
    • Proven experience in Microsoft SQL Server - advanced SQL knowledge, store procedures, functions, creating tables and views and database administration
    • Understanding of Kimball data warehouse methodology and dimensional data modelling (star/snowflake)
    • Experience gathering and documenting requirements, and translating them into technical solutions
    • Ability to work both independently and collaboratively
    • Excellent verbal, written and presentation skills
    • Proven experience using data integration / ETL software
      • SAP Data Services – design and administration
      • SQL Server Integration Services
    • Proven experience using SAP BusinessObjects BI Suite 4.x in end user and administration roles
      • Web intelligence
      • CMC (Central Management Console)
    • Exposure to Microsoft Power BI
      • Experience using Power BI Desktop and the Power BI O365 service
      • Knowledge of data modelling concepts in Power BI desktop
      • Knowledge of DAX syntax, functions and formulas

    Final Statement

    We listened to our employees so our Core Benefits are funded by us and include a Group Pension Scheme, Employee Assistance Programme, Life Assurance, Income Protection and funded membership to a Professional Institute. In addition to this we also offer a Private Healthcare Scheme, Private Dental Scheme, Childcare Vouchers, Cycle to Work, Volunteering Days and Save as You Earn Scheme.  


    At Costain we aim to be an accessible, diverse and inclusive organisation to continue to meet our customers’ needs. We will be industry leading in our approach and people from all backgrounds will be proud to work for Costain. Our goal is to have a workforce that is representative of society.


    We actively encourage applications from candidates who have a relationship with the armed forces community whether as a currently serving member or reservist, ex-military or wounded personnel or as a member of a service family.



    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed