Experis Scotland
Senior Data Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Senior Data Engineer
We're looking for a Senior Data Engineer to build and scale Snowflake-based data products that power portfolio suitability, investment risk, market data, advanced analytics and AI-driven decision making.
This role sits at the intersection of modern data engineering and AI enablement. You'll help create the trusted, governed data foundations needed for reporting, analytics, machine learning, copilots and future agentic AI solutions. The focus isn't just on moving data, it's about making data discoverable, reusable and ready for both human and AI consumers.
What You'll Be Doing
- Design and deliver scalable data products supporting portfolio suitability, investment risk and wealth management analytics.
- Build and optimise Snowflake data models covering portfolios, holdings, transactions, valuations, market data and suitability outcomes.
- Create analytics-ready datasets that can be consumed consistently by reporting tools, data analysts and AI applications.
- Engineer trusted data products that support future AI initiatives, including copilots, AI assistants, knowledge discovery and automated decision-support tools.
- Develop and maintain ELT pipelines using dbt and modern software engineering practices.
- Ensure strong governance, lineage, data quality and security standards across all data assets.
- Work closely with business, analytics and AI teams to identify opportunities where data products can accelerate decision making and productivity.
- Help drive adoption of AI-assisted engineering practices using tools such as GitHub Copilot and Claude Code.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
AI & Data Product Focus
AI is a core part of this role. You'll be expected to think beyond traditional data warehousing and build data products that are AI-ready from day one.
This includes:
- Designing datasets that can be easily discovered, understood and consumed by AI tools and large language models.
- Creating high-quality, well-governed data foundations for machine learning, generative AI and agentic workflows.
- Leveraging AI-assisted development tools to improve engineering productivity, code quality and delivery speed.
- Supporting the development of AI-powered analytics, copilots and decision-support capabilities across the business.
- Ensuring AI use cases are built on trusted, auditable and secure data.
Key Skills & Experience
- Strong Snowflake, dbt, SQL and Azure experience.
- Experience building enterprise-scale data platforms and data products.
- Advanced dimensional modelling and Star Schema design.
- Strong understanding of data governance, quality, metadata and lineage.
- Hands-on experience with GitHub, CI/CD and modern engineering practices.
- Financial Services, Wealth Management or Asset Management experience.
- Experience delivering portfolio suitability, investment risk or regulatory reporting solutions.
- Strong knowledge of portfolio, holdings, transactions and market data.
- Experience working with Bloomberg, FTSE or similar market data providers.
- Python experience desirable.
- Comfortable using AI-assisted engineering tools such as GitHub Copilot and Claude Code.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Ideal Candidate
An experienced Data Engineer with deep Snowflake expertise and a strong Financial Services background who is excited about the next generation of AI-enabled data platforms. You'll understand how to build robust, governed data products that support traditional reporting and analytics today while laying the foundations for copilots, AI assistants and agentic AI capabilities in the future.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills