Data & Reporting Consultant

About the role:

As part of our Business Services team within COmpany, this role is key to helping internal stakeholders maximise the value of our own data, ensuring the timely delivery of robust operational and strategic insights across Professional Services, Customer Success, Customer Support, BPaaS and HR Services teams. Key responsibilities will include maintaining regular reporting, making actionable insights accessible and delivering timely business recommendations.

The data &reporting consultant willbe an integral part of the team ensuring we can leverage and optimise on enhanced reporting and analytics capability. The role will require you to surface information from a number of best-in-class systems, create reports and provide visual and meaningful MS Excel/PowerBI dashboards to key stakeholders as per business requirements.This role will require you to analyse business and data processing problems to support the business in implementing and improving customer and colleague processes/ways of working.

We are looking for someone with a passion for logical thinking and analytics (with 3-5 years of practical experience), has a positive and collaborative approach to work, with a logical mindset and the ability to work with ambiguity and problem solve with minimal direction. Attention to detail and ownership of the data is of paramount importance for this role. Data needs to provide meaningful MI and be 100% accurate.

Therole would suita person withanalytical skills and critically with a reporting and data background who enjoys working withcomplex data sets and translating intobusiness insights, the right attitude and a passionfor data is important.

In this role your key responsibilities will be:

To pull and disseminate data from a range of systems accurately and reliably.

Leverage analytical capability of PowerBI and Zendesk to encourage automation and self-service of reporting dashboards.

Build and test custom reports/dashboards in Power BI and Zendesk

Maintain databasesand perform updatesas necessary to ensure accuracy.

Analysis of data to identify trends.

Develop automations to reduce recurring admin tasks.

Regularly examinedata reports to locate and resolve mistakesthroughout

Accurately analyseand collect data for varioustypes of businessreports.

Create businessreports that provideinsight into key data points.

Communicate the results of data analysisin written and verbal form to managers.

Support variouswork streams withinthe operations divisionin reaching their goals throughanalysis.

Monitor data to identifychanges in financialand business trends.

Use specialist tools to extractthe data needed.

Respond to data-related queriesand ensure changecontrol procedures are followed.

Setting up processes and systems to make workingwith data more efficient.

Research new ways to make use of data.

Producing reportsand charts communicating trends within data to non-specialists.

Presenting information generated from data to managers.

Produce and track key performance indicators.

Develop and support reporting processes.

Mine and analyse largedatasets, draw validinferences, and presentthem successfully to management using a reportingtool.

Agree data reporting requirements with key stakeholder's

TechnicalSkills

Must have:

Advanced MS Excel user with previous experience in working with heavy exceldatasets

Experience in creating PIVOTTables which will help the user to summarise the complex data

Creating insightful report by combininginformation from multiplereports with utmost accuracy

Experience in cleansing huge raw data by using various advancedexcel functions

Logical abilityto create complexconditional formatting

Experience in combining data from multiple excel files to enrich proper raw data for reporting.

Experience in creating meaningful dashboards with KPIs and insightful charts, tables, and trendlines

Intermediate/advanced Power BI user

Hands on experience in working with Power BI reports and Dashboards

Knowledge on how to connect multipletables in Power BI

knowledge on data cleansing and transformation by using Power Query editor

Experience in working with Power BI Service features.

Basic experience in documenting project details, dashboard user guide docs, handover documents etc (MS Word).

Excellent numericaland analytical skills

The abilityto analyse, model and interpretdata

Problem-solving skills.

A methodical and logical approach

The abilityto plan work and meet deadlines

Accuracy and attention to detail

Interpersonal skills

Teamworking skills

An understanding of the ethicsof gathering and working with data

Analytical skillsthat allow for the development of data-driven reports

Demonstrated abilityto manage time and prioritise projects to meet deadlines

Strong writtenand verbal communication skills to effectively relate data to co-workers

General knowledge of business operations, objectives, process, and information flow

Advanced user of Microsoft Office packages