Job Purpose
Act as a critical link between business stakeholders and modern data capabilities by leveraging Microsoft eco-system to design, build, and maintain new compliant, high‑quality analytical data solutions within a regulated financial‑services environment. The role focuses on transforming business objectives into robust, auditable data models, pipelines, and insights that support risk management, regulatory reporting, operational efficiency, and strategic decision‑making.
Collaborate with technical and non-technical teams to understand existing infrastructure and business needs and map to new strategic data products and processes that will provide insight and data driven decisioning
Key responsibilities:
-
Engage with business stakeholders to understand and document data requirements aligned with organisational goals and regulatory requirements
-
Translate business requirements into functional specs and data products to support change, process improvement, new analytical products and automation.
-
Design and build Lakehouse/Warehouse data models and pipelines to support end to end data ingestion through to MI and Dashboards such as Customer Analytics, Risk MI, Financial Crime monitoring, reg reporting and marketing.
- Implement and monitor audit trails such as Data Lineage, Quality and traceability
-
Utilise data to analyse, interpret and visualise trends, patterns, and business and efficiency opportunities.
-
Develop use cases and user stories in collaboration with stakeholders to ensure alignment and clarity.
-
Facilitate workshops and stakeholder meetings to gather insights, validate requirements and share findings.
-
Develop and maintain documentation, including data models, process flows, data dictionaries, and business glossaries.
- Support data quality initiatives, identifying and addressing data issues or inconsistencies and maintenance of Critical Data Elements (CDEs).
- Assist in the design and implementation of data governance and data management practices.
- Facilitate data-driven decision-making through the creation of Power BI dashboards, reports, and presentations.
- Provide guidance and support to business stakeholders and users to aid the delivery of project and change lifecycles.
-
Support the wider project and change delivery team, including business case development, planning, workshops, reporting, RAID and action logs.
-
Maintain effective controls to mitigate risk and ensure compliance with required processes and procedures, including Treating Clients Fairly, and report any failings to line management or the Risk department.
-
Champion a culture of data literacy and continuous improvement within the business. Foster a data led ethos across all business areas
Required skills, knowledge & experience:
-
Bachelor’s degree in business, Information Systems, Data Science, or a related field (or equivalent experience).
- Relevant certifications (e.g., IIBA CBAP, BCS Business Analysis, or data analytics qualifications) are advantageous.
- Proven experience with the Microsoft Fabric stack (SQL, Power BI, Azure, PowerApps, Dynamics) with a focus on data or analytics projects.
- Experience of Oracle systems and data structures is desirable
-
Demonstrated track record of delivering data-driven solutions to business challenges.
- Experience working with cross-functional teams in a fast-paced environment to gather and map requirements
-
Strong analytical and problem-solving skills, with the ability to interpret complex data sets.
- Excellent communication and stakeholder management skills.
- Proficiency in data visualisation tools and automation techniques
-
Experience with data querying languages (e.g. SQL) and understanding of data structures and security models.
- Knowledge of data governance, data quality, and data management best practices.
- Understanding of data privacy and compliance requirements (e.g., GDPR).
- Ability to document processes, requirements, and data flows clearly and concisely.
- Familiarity with Agile and/or Waterfall project methodologies.
- Adaptability and willingness to learn new technologies or concepts in the data domain.
Personal Attributes
-
Curious and proactive mindset, with a passion for deriving insights from data.
- Strong attention to detail and commitment to data accuracy and integrity.
- Collaborative approach and ability to work effectively with diverse teams.
- Strong organisational and time management skills.