Data Manager (Microsoft Fabric) in Edinburgh

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 QUALIFICATIONS, KNOWLEDGE & SKILLS

• 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.

About us
At Hampden Bank, we provide private banking as it should be: approachable, accessible expertise delivered through loyal, long-lasting client relationships. Personalised service is at the core of our business, with a culture that is built on relationships. We take the time to get to know our clients to help them achieve their aspirations.

Why join us
As a growing and ambitious company, we seek people to join our team who share our values; Proud Ownership, Absolute Integrity, Total Inclusivity, Winning Teamwork and Purposeful Growth. We are committed to an inclusive culture where everyone is comfortable to be their authentic self. We recognise, value and respect diverse cultures, knowledge, and identities. We work together to ensure collaboration, development, and success for everyone, supporting them to thrive and reach their potential. We offer exciting career opportunities through professional and personal development, and have an extensive range of benefits you can enjoy.

To apply
Please submit your CV by the closing date. Please remember, on occasion we do receive more applications than expected we may bring the closing date forward, so please do apply promptly. If you require reasonable adjustments to be made during the recruitment process, please let us know by contacting the People Team and we will endeavour assist you. If you are excited about this opportunity and think you can bring value to the role and Hampden Bank, but your experience does not align perfectly with every aspect of what we are looking for, we would be happy to hear from you. If you have any questions or are interested in learning more about the role, please contact the People Team and we will get back to you as soon as possible.

Hybrid working / flexible working
We support hybrid working and our policy is that colleagues spend at least 60% of their working week in the office to connect and collaborate with their colleagues. We are open to considering requests from candidates who are looking for flexible arrangements. Please talk to us at interview about the flexibility you are looking for, and we will explore what is possible for the role. We cannot promise to meet every request, but we will not judge you for asking.