AI Connect | Data & AI Delivery Partner
Senior Data Modeller

How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Senior Data Modeller
Location: Glasgow or Manchester
Working: Hybrid, 50% office / 50% home
Type: Permanent
We’re looking for a Senior Data Modeller to join a large-scale data transformation programme in a pensions & investment firm, helping build trusted data products that support analytics, reporting, data science and AI.
The Role
- Design and maintain enterprise and domain-based data models
- Analyse and integrate complex data sources
- Develop source-to-target mappings across batch, real-time and streaming data
- Support the evolution of an enterprise data model and data products
- Produce data modelling, mapping and design documentation
- Work closely with data engineers, architects, business stakeholders and third parties
- Present technical designs and recommendations to senior stakeholders
Reasons to use Rodeo
I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?
Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.
Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.
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.
Graduate Consultant — 2026 Scheme
Why you're a good match
StrongYour economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.
See breakdownIt 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.
Why you're a good match
You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.
Experience fit
Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.
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.
What We’re Looking For
- Strong experience in data modelling, mapping and enterprise data architecture
- Knowledge of Kimball/Inmon, star schemas, fact/dimension modelling, OLAP, data lakes and ERDs
- Experience with modelling tools such as ER/Studio, Erwin or Sparx EA
- Experience with Azure data services, particularly Azure Data Factory or Databricks
- Strong understanding of ETL, CDC, data integration and transformation
- Experience working in complex, agile and/or multi-vendor environments
- Strong communication and stakeholder management skills


Get help with your application
Your very own career expert that helps elevate your application to the next level.
Experience within financial services or another regulated environment would be advantageous but not a hard ask.
The role offers:
- Hybrid working, with approximately 50% home / 50% office.
- 28 days annual leave plus bank holidays.
- Employer pension contributions of up to 14% and discretionary bonus.
- Private medical insurance.
- The opportunity to work with modern cloud data platforms and large-scale enterprise data architecture.
If you’re a Data Modeller or Analytics Engineer looking for the opportunity to work on a significant enterprise data platform and help shape the foundations for analytics and AI, we’d love to hear from you.
“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