Business Intelligence Analyst x 2 - New Team / Big Data - Leeds

This is a great opportunity to get involved in making significant changes, at a holistic level, to the day-to-day way reporting and generally BI operates in this huge Data Warehouse for one of the largest supplier and procurement systems that exists not only in the UK but on a global scale.

As part of this new contract, this huge technology outsourcing firm is now providing the key administrative and payment services covering processing of payment information, management of supplies, maintenance of performer list and market entry applications, through to management of administration and movement of billions of records.

Working on an inherited technical environment and in a transformational programme of work, which is stable but not yet fully transformed, you will be part of a team delivering opportunities to drive service and business performance.

Responsibilities:

• Support the development and maintenance of effective reporting processes
• Support the development of bespoke applications for data capture & reporting purposes using DWH and Excel UserForm technologies
• Resolve data quality issues through robust data investigation and resolution activity
• Support wider Business Change management processes (e.g. Transformation and CRM change management)
• Produce high-quality documentation that facilitates layman’s understanding of complex technical processes

The BI analyst role will require day-to-day development of reporting processes, largely on a project basis. On occasion, the BI Analyst will need to engage with Senior stakeholders to ensure MI reporting services meet the level & quality required by the partnership. The BI Analyst will work closely with the wider MI team members to ensure cohesive development of new reporting capabilities and maintenance of BAU reporting. The BI Analyst will support the continuing evolution of the Data Warehouse. The BI Analyst will be actively involved in sourcing new datasets into the DWH where there is a reporting need or a business requirement to manage. This will involve reviewing source systems to understand how data is captured and therefore how it should be used for MI and analysis purposes. The BI Analyst will be able to provide leadership on data issues; including the education and development of less experienced MI team members. The BI Analyst will support the introduction of new reporting tools into the wider community to maximise the ability of Senior Stakeholders to self-serve (i.e. Power BI).

Experience Requirements:

• BI Analysts will facilitate the development and implementation of business intelligence processes and procedures.
• Contribute to the strategic design and maintenance of business intelligence applications.
• They will identify, research, and resolve complex technical problems; ensuring that the use of business intelligence applications enhances business decision-making capabilities.

Requirements Gathering:

• Able to insightfully draw out reporting needs from business Stakeholders
• Able to clearly and unambiguously document Requirements in a format that is easy for others to understand

BAU Reporting:

• Able to support BAU delivery; especially incident management
• Providing support / education to wider MI colleagues to ensure best practice is in place

Reporting Development:

• Identify new sources of data or more efficient uses of data both inside & outside of DWH
• Will develop E2E reporting solutions - maximising reporting accuracy and automation (especially around monthly KPIs & business controls)
• Conduct robust data testing & validation

Project Support:

• Submit MI team ‘data requirements’ to Change teams / projects as required (Transformation / CRM)
• Conduct “Impact Assessments” for Change projects (review CCN / RFW)

Essential Role Related Knowledge, Technical Skills, Qualifications and Experience:

• Strong skills in Microsoft BI stack (SQL, SSAS / SSIS / SSRS)
• Experienced in data investigation to identify faults / verify amendments to code
• Proficiency in MS Office tools
• Familiar with data presentation packages - e.g. Power BI
• Excellent analytical skills (listening, questioning, challenging, modelling, etc.)
• Strong documentation skills e.g. data modelling; business rules; requirements management; change management
• Experience of developing others

Knowledge:

• In-depth knowledge of relational database theory / architecture
• Experience of data / MI change programme – especially in a data / technical capacity
• Experience of Data Warehouse technologies and how to develop / maintain
• Familiar with technical challenges in Operational MI reporting

Person:

• Strong communicator - able to engage all levels of stakeholders
• Able to work independently and with a team
• Able to learn quickly; takes responsibility for own learning
• Able to work in a demanding environment and deliver to deadline
• Professional & approachable
• willing to go the extra mile; able to use initiative to solve problems
• Strong attention to detail
• Results oriented