Senior Data Engineer

Senior Data Engineer
Location: Glasgow
Contract: 1 year
Work Setup: Hybrid - 3 days in the office

Who We Are
Robert Walters is the world's most trusted talent solutions business. Across the globe, we deliver recruitment, outsourcing, and talent advisory services for businesses of all sizes, opening doors for people with diverse skills, ambitions, and backgrounds.

Who You Will Work With
Our client is a global financial services firm that manages wealth, navigates complex markets, and design strategic financial objectives. The firm provides risk management solutions across a variety of sectors, emphasizing long-term relationships, and innovative approaches to financial challenges.

What You'll Do

• Act as IT System Owner for data and systems solutions, overseeing their design, operation, security and continuous improvement in line with business needs.
• Analyse business processes and operational datasets to profile, validate and assess data quality, identify gaps and inefficiencies, and translate findings into actionable insights and recommendations.
• Design and implement relational and dimensional data models (eg star/snowflake) and build/maintain ETL/ELT pipelines to ingest data from operational, SaaS, IoT and vendor sources into central analytics environments.
• Develop and optimise SQL queries, views and stored procedures, and model telemetry/event-based pipelines into SQL/Power BI/DAX, establishing data quality, lineage and retention for time-series analytics.
• Design and develop AI agents and agentic workflows, including use of Snowflake Cortex AI for human-in-the-loop workflow design, to automate high-value processes with appropriate guardrails and oversight.
• Partner with stakeholders to define KPIs, metrics and reporting standards; translate business questions into analytical models, dashboards and metrics; and support ad hoc and recurring analysis for operational and leadership reporting.
• Coordinate with cross-functional teams (including Security Architecture and Corporate Services), gather and prioritise feature enhancements, review Jira tickets, and produce technical documentation, training materials and automation scripts (PowerShell, Python, Shell) to streamline operations.

What You Bring

• 7+ years' experience in data engineering, database development or data warehouse engineering.
• Strong expertise in SQL and relational database concepts, with hands-on experience designing dimensional models and analytics-focused data structures.
• Proven experience building and maintaining ETL/ELT pipelines and integrating data across cloud and on-prem environments.
• Solid understanding of Snowflake and data quality, validation and lineage concepts to ensure trustworthy, traceable data.
• Practical experience with AI agents, including designing or supporting agentic workflows and automation.
• Proficiency with Power BI or equivalent BI platforms to deliver dashboards, metrics and self-service analytics for stakeholders.
• Excellent analytical, problem-solving and stakeholder communication skills, with experience working in Agile/Scrum delivery environments.

What's Next
If you are ready to take the next step, apply now! Successful applicants will be contacted directly by a recruiter to discuss the role more.

We are committed to creating an inclusive recruitment experience. If you require support or adjustments to the recruitment process, our Adjustment Concierge Service is here to help. Please feel free to contact us at (see below) to discuss how we can support you.

This position is being recruited on behalf of our client through our Outsourcing service line. Resource Solutions Limited, trading as Robert Walters, acts as an employment business and agency, partnering with top organizations to help them find the best talent. We welcome applications from all candidates and are committed to providing equal opportunities.