Consultant - Power BI with Alteryx

What you will be doing:

Data Architecture:

·                     Design and develop data models that accurately represent the structure and relationships of financial data, ensuring it aligns with business requirements and objectives.

Collaborate with cross-functional teams to integrate financial data architecture into

existing systems and processes.

Data Integration:

·                     Integrate financial data from various sources, including ERP systems, databases, external APIs, and spreadsheets, into comprehensive and coherent data models.

Build a data estate that provides a platform for future financial analytics work.

Evaluation and implementation of potential AI uses in data integration programmes.

Data Transformation:

·                     Implement data transformation and cleansing processes to ensure data accuracy,

consistency, and adherence to financial reporting standards.

Create comprehensive documentation for data models, making it accessible to relevant stakeholders and ensuring a clear understanding of data structures and relationships.

Optimize data models to enable efficient querying, reporting, and analytics, working to

improve data retrieval speeds and system performance.

Adhere to and input to data quality standards and implement data validation checks to

ensure data accuracy and integrity.

Data Visualisation:

·                     Automation of monthly data explorational reports and cross channel distribution of

accurate and reliable financial report inventory.

Ownership of data ingestion processes including QA, scheduling, veracity and

interoperability of underlying platform sources.

Responsible for the regular update and refresh of our visualisation reporting estate,

predominantly on the Power BI platform but also in other visualisation tools as required.

Data Sourcing:

·                     Work with Data Modelling and Business Analysis teams to provide scoping estimates for data sourcing and identify the steps required to delivery this.

Build and utilise a close network with other functions such as Product & Tech to become an expert on the lineage of varying sources of Financial data.

Create ingestion and extraction plans for data treatment as appropriate. · Working in partnership across Finance to identify and operationalise potential reporting and data driven decision opportunities.

Key Accountabilities:

·                     Data expert style role supporting the wider Finance team to align business problems with data driven solutions.

Knowledge of SQL and other data querying languages

Having a strong understanding of DAX queries in Power Bi

Actively engage in the Peer Review process in Power BI to ensure that your peers are delivering reports to the gold standards

Power Automate would be an added benefit

Knowledge in Alteryx

Process and report automation to streamline creation and delivery of reporting inventory in a timely and accurate manner

Actively engage in internal knowledge sharing sessions when a relevant new skill or piece of knowledge is obtained and actively contributing to the SOP confluence page

Identification and implementation of data quality capture routines and feedback mechanisms to improve overall data veracity

Lead project streams on system development and visualisation projects

Feed to the development pipeline with appropriate cost / benefit analysis led opportunities to improve data throughput throughout the system estate

Visualisation champion with knowledge of both software and data architecture to support users across the systems landscape

Identify opportunities throughout 2025 where specific parts of projects can be delivered early, ahead of full project completion. This may mean breaking the project into multiple smaller phases and delivering the first phase much sooner than would otherwise have been possible

Continuously update and maintain JIRA tickets throughout 2025, ensuring that internal and external stakeholders are kept informed of project progress.

Conduct an internal project retrospective on every project you deliver within 2 months of delivery, to identify opportunities for improvement moving forwards, as it pertains directly to the project within the team. This includes items such as improving communication between BAs and analysts, improving documentation, and even giving feedback on how we work better as a team

Qualifications

What we are looking for:

·                     Financial reporting / forecasting / budgeting

Deep and demonstrable knowledge of various technical skills such as Power BI, SQL, Power Automate, Alteryx, AWS (basic understanding)

Analysing how the data works and fetched through different data sources like RDS, Datasphere, EDW, Redshift

Demonstrable experience of designing, delivering and supporting a data visualisation estate, preferably with experience of supporting financial data sets

Attention to detail is essential

Skills and Behaviours Required:

·                     Teamwork and building relationships, as well as solo work

Strong attention to detail and quality assurance mindset

Good technical skills with training delivery capabilities

Commercial and customer focus

Communication (oral and written) with members of the finance team and employees at all levels within the business

Problem solving mindset, able to escalate and effectively remove roadblocks to progress · Proactive nature