Consultant 1 - BI

Job Description

About the role At Zellis, we have big ambitions, and our Services division is at the heart of them. A key part of this ambition is the growth of its 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 for reporting and management information on our ResourceLink solution, as well as a variety of other systems. The work ranges from the development of operational reports, conversion of reports from existing platforms to our Zellis HCM cloud solution. Our customers use a variety of Business Intelligence technologies including Zellis’ integrated reporting tools (Resourcelink Reporting Services (RRS) and Microsoft Power BI) as well as IBM Cognos Analytics or SAP Business Objects (BO) and SQL Server Integration Services (SSIS) This role will have focus on report conversion, building complex SQL queries for preparing transformed analytical datasets and designing sophisticated reports through to the unit testing and handover. Key success measures for the role will include delivering chargeable consultancy. This role provides variety, a learning opportunity, and the chance to be part of a growing team with an exciting future in market leading analytics. This role have an opportunity to grow as a point of contact for funded consultancy which includes requirement gathering, customer interaction and training sessions. Skills & experience Essential Skills: Experience in BI and Analytics: Minimum 2 years A proven track record in reporting and data analysis tools using ORACLE or SQL server. Experience at building complex SQL queries (e.g. CTEs, sub queries, pivot queries etc) using a SQL development Can demonstrate how these SQL skills are used in manipulating and cleansing data for the purposes of reporting and analysis Knowledge of SQL profiling and analysing query execution plans to help optimise queries. Strong analytical capability with an inclination for problem solving Excellent communication skills particularly written and verbal in English Excellent teamwork skills o Highly cooperative and yet self-sufficient o The ability to work well with others as well as independently o Action oriented and collaborative team player o Self-motivated, proactive, accountable with continuous learning approach; willing to learn and understand evolving technologies. o Ability to multitask in an ambiguous environment. o A high level of attention to detail o Have a reputation for honesty and accuracy that reinforces the sense of urgency that must be conveyed In this role your key responsibilities will be: Prepare complex SQL queries to extract data from complex operational databases and transform into analytical datasets Write and update technical BI report specifications, report trackers and issue logs Convert complex SQL queries and CTEs from Oracle PSQL into Microsoft SQL Server TSQL and AZURE Convert existing Cognos reports to Jasper Reports by converting to ORACLE or SQL-server code. Performance tune SQL queries and reports Create technical specifications and build operational reports using Jasper Studio Carry out unit testing of new and amended BI content before release to customers Ensuring you maintain your personal development and continuous improvement in Zellis’ products and services, including best practice operating processes and industry. Benefits & culture At Zellis we create market-leading HR & Payroll products and services, to power exceptional employee experiences so that you and your people do better. Our multi-award-winning products pay over five million employees a year, with almost half (42%) of the FTSE 100, 50% of the top retailers and 30% of the top universities in the UK & Ireland as customers, making us the largest provider of Payroll and HR software and managed services. Our vision is to be the clear leader in pay, reward, analytics, and people experiences. We're passionate about creating an environment where people want to join, belong to, and be part of a progressive organisation. Our values, which were defined with input from all of our 2,000 colleagues, we live and breathe every day: Unstoppable together. Always learning. Make it count. Think scale. Our people are critical to our ongoing success; we’re proud of our inclusive culture that gives you the platform to grow, challenge the status quo and play a crucial role in further enhancing our market position as the leading provider of HR & Payroll software and services. With Zellis you’ll have the chance to stretch and challenge yourself in an environment that’s varied, flexible and hugely supportive. We also love to reward and recognise our brilliant colleagues. As part of your benefits package, you’ll receive: A competitive salary. Excellent career progression opportunities. Transportation to the office (up to 30kms). Casual, privilege and sick leave, plus your birthday off. Group medical insurance. Personal accident insurance. Life assurance. A range of additional flexible benefits to support personal wellbeing.