To support the BI manager in implementing and maintaining an effective Business Intelligence service. Responsible for creating and maintaining both internal and client facing business intelligence systems and reports, in conjunction with other BI team members and internal and external stakeholders, that fit with BI strategy and are properly supported.
Design & Deliver BI Solutions
Ensure that all reports are accurate and timely - defining control systems and documentation to allow for efficiencies and standardisation to be improved.
Produce new solutions in line with the established policies and work instructions.
To provide well designed and aesthetically pleasing result sets that bring the data alive via Data Dashboards and interactive pivot-table style controls.
Ensure that solutions are produced in a predictable way that is easy to support.
To produce results in the most economical way possible, even when this would eschew the use of newer techniques and technologies.
To utilise the standard toolset to ensure that work is:
Logged and time recorded
Checked in to Source Control and kept safe and secure
Properly documented and structured
Keep the Head of Business Intelligence appraised at all times on progress against plans, including an update on schedule of tasks and priorities.
Qualifications & Experience
SQL Server Reporting Services;
Microsoft SQL Server (2005+);
Web based BI Reporting and Dashboard tools;
SQL Server ETL tools (SSIS);
An end-user tool to enable interaction with Data Cubes and BI datasets (e.g. Microsoft Excel 2007+, LogiXML, InetSoft, GrapeCity ActiveAnalysis etc.);
Microsoft Office 2003+;
Developing and maintaining objects within OLAP Data Warehouses;
ETL (Electronic Transform and Load);
Report writing and automation;
Multi-dimensional analysis of complex datasets using data cubes;
Working with a broad range of stakeholders at all levels in the business; and
Promoting the concepts of Business Intelligence to a "green-field site" (i.e. a company that currently has limited exposure to B.I.).