BI Consultant

**About the role** We’re looking to grow our existing Business Intelligence Consulting Team, and this has created an exciting opportunity for a dedicated, ambitious, and analytical BI consultant.

You’ll be a key member of a proactive team, delivering customer funded consultancy in all aspects of reporting and management information on our ResourceLink solution, as well as a variety of other systems. The work ranges from the development of operationalreports, data modelling, dashboard/visualisation design, event driven notifications and the build of predictive analytics models.

Our customers use a variety of Business Intelligence technologies, including Zellis’ integrated reporting tools (Resourcelink Reporting Services and Microsoft Power BI) as well as IBM Cognos Analytics and SAP Business Objects. You’ll work on the full BIlife cycle of a project from initial discovery sessions to carrying out detailed scoping workshops, writing specifications, building complex SQL queries for reports and designing sophisticated dashboards/visualisations, through to the unit testing and handover.

Key success measures for the role will include being a chargeable consultant who excels at building positive relationships with customers at all levels within an organisation. You’ll be a strong communicator and able to discover BI requirements, using industryexperience to deliver best practice advice on HR/payroll analytics and translate requirements into insightful solutions. This will be achieved using a rich mix of BI skills, including but not limited to, complex SQL queries, report design, amending data modelsfor ad-hoc queries, building insights and KPIs into self-service PowerBI dashboards and producing business alerts and notifications.

**Skills and experience required**:

- A strong track record in a customer facing BI consultancy/reporting role(s).
- Experience of BI reporting in a HR and Payroll environment.
- Proven ability to work to a recognised project management methodology and to tight timelines.
- Very experienced at building complex SQL queries against either Microsoft SQL Server or Oracle.
- Detailed knowledge of Microsoft Power BI.
- Knowledge of ETL technologies is desirable - specifically Microsoft SQL Server SSIS.
- Knowledge of Tibco Jaspersoft Report Studio/Ad-hoc is desirable.
- Desirable but not essential is detailed knowledge of one or more - IBM Cognos 7 Impromptu, Cognos Business Analytics 10/11, Business Objects 4.x.
- Ability to build data models for reporting & predictive analytics, create complex visualisations/dashboards, crosstabs, drill through reports, OLAP cubes and event driven notifications.
- A natural interest to keep pace with new versions and features of the BI tools and how these can be incorporated into our offerings to generate new revenue opportunities.
- Existing knowledge of ResourceLink’s tables & data structures is desirable but not essential, specifically around base tables (HR, Payroll and Pensions), Leave Management, PDR, Time and Attendance, MyView, Expenses.
- Excellent analytical capability with strong attention to detail and an inclination for problem solving.
- Deliver actionable insights from data through questioning and analysis.

**About Us** Zellis is the leading provider of payroll and HR solutions for the UK & Ireland. Together with Benefex and Moorepay we form the Zellis Group, serving a vast array of companies across every vertical and industry. Our purpose is to make people feel appreciatedfor the work they do - through precision, choice, and magic.

We have over 50 years of heritage and industry experience - and we’ve been ahead of the curve throughout. More than half a century ago, we were founded as Peterborough Data Processing. Quite a lot has changed since then - not least our name. We were acquiredby Northgate, becoming NorthgateArinso in 2007 and NGA Human Resources UK and Ireland in 2014, where we were joined by Moorepay. In 2018, the UK and Ireland division was sold to Bain Capital and now we operate as a standalone company, Zellis. After acquiringBenefex, we’re now even better equipped to serve the complex needs of our customers.

Our vision is to be the clear leader in pay, reward, analytics, and people experiences. We’re proud of our culture and we work hard to create an environment where people want to join, belong to, and be part of a progressive organisation. Our values, whichwere defined with input from all of our 2,000 colleagues, are not empty words on a poster:

- Unstoppable together.
- Always learning.
- Make it count.