Focused Futures Consultancy LTD
Data Modeler
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Senior Data Modeller
Location: Yorkshire, United Kingdom Working Arrangement: Hybrid Employment Type: Permanent Sector: Analytics and Data / Retail, FMCG and Financial Services Salary: £90k to £100k + 10-12% bonus + benefits
The Opportunity
We are recruiting an experienced Senior Data Modeller / Data Architect on behalf of a leading global data and AI organisation.
This is an exciting opportunity for a senior data professional to play a key role in designing, developing and maintaining enterprise data models that support analytics, reporting, artificial intelligence, machine learning and business intelligence initiatives.
You will work across complex data environments, translating business requirements into scalable and high-quality data solutions while ensuring that data is structured, governed and optimised for performance.
Working closely with business and technical stakeholders, you will contribute to data architecture strategy, data governance, integration and the continuous improvement of enterprise data capabilities.
Key Responsibilities
As a Senior Data Modeller, your responsibilities will include:
- Translating business requirements into scalable data models that support business and technology objectives.
- Designing, developing and maintaining conceptual, logical and physical data models.
- Defining source-to-target mappings, data flows and business rules.
- Supporting the design and implementation of relational and NoSQL database solutions.
- Developing data models for data warehouses, data lakes, operational data stores and data marts.
- Developing and maintaining metadata, data dictionaries and supporting documentation.
- Optimising existing data models to improve performance, scalability, quality and reusability.
- Establishing and promoting data modelling standards, naming conventions and best practices.
- Identifying opportunities to reuse existing data models and data assets.
- Reverse engineering existing databases, applications and SQL scripts to produce accurate data models.
- Assessing logical and physical models for quality, integrity, performance and alignment with business requirements.
- Analysing data integration challenges and recommending scalable solutions.
- Providing technical guidance to Business Analysts, Developers, Data Engineers and Solution Architects.
- Reviewing application and database designs and recommending improvements.
- Supporting enterprise data architecture, data movement strategies and technology direction.
- Ensuring data architecture deliverables comply with relevant standards, policies and governance frameworks.
- Working collaboratively with project managers, business stakeholders, technical teams and clients throughout the project lifecycle.
- Supporting and mentoring less experienced members of the data team.
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.
About You
We are looking for an experienced Data Modeller with a strong background in enterprise data modelling, data architecture and data integration. Previous experience working ideally for a consulting business or software house working on FTSE 100-250 business client projects.
You should have:
- 8+ years' experience in data architecture, data modelling or a similar discipline.
- 7–12 years' implementation experience using data modelling tools such as Erwin, ER/Studio, PowerDesigner or similar.
- Strong experience developing conceptual, logical and physical data models.
- Experience with dimensional modelling.
- Knowledge of ODS, Data Vault and other data architecture approaches.
- Strong SQL and database design skills.
- Experience with data profiling, analysis, data quality and source-to-target mapping.
- Strong understanding of data warehousing and OLTP environments.
- Experience with ETL, data integration and data transformation.
- Experience working across cloud and on-premise environments.
- Knowledge of modern cloud/data platforms such as Azure, AWS, GCP, Snowflake and/or Databricks.
- Experience with major database and big data technologies.
- Strong understanding of data architecture principles, governance and enterprise data management.
- Excellent analytical, problem-solving and stakeholder management skills.
- Strong communication skills and the ability to work effectively with both technical and non-technical stakeholders.
- Experience mentoring, leading or managing data professionals.
A Bachelor's degree or equivalent experience is required, with a Master's degree being desirable.
Technical Environment
Experience with most of the following would be advantageous:
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Data Modelling:
- Erwin Data Modeler, ER/Studio, PowerDesigner
Databases:
- SQL Server, Oracle, PostgreSQL, MySQL, MongoDB, Cassandra
Cloud & Data Platforms:
- Azure, AWS, GCP, Snowflake, Databricks, Redshift, Hadoop
Data Engineering & Integration:
- Azure Data Factory, ETL technologies, data integration platforms
Development & Delivery:
- Git, Azure DevOps, PL/SQL, T-SQL
BI & Analytics:
- Power BI and other business intelligence platforms
What You'll Bring
Beyond your technical expertise, we're looking for someone who demonstrates:
- Strong critical thinking and problem-solving skills.
- A proactive and collaborative approach.
- The ability to communicate complex data concepts clearly.
- A passion for data architecture and continuous improvement.
- Strong organisation and time management.
- The ability to work independently while contributing effectively to cross-functional teams.
- A commitment to knowledge sharing and mentoring.
- A focus on delivering robust, scalable and sustainable data solutions.
Why Consider This Opportunity?
This is a great opportunity to join a forward-thinking organisation operating at the intersection of data, AI, technology and business transformation.
You'll have the opportunity to work on complex data initiatives, influence data architecture decisions and collaborate with experienced professionals across business and technology functions.
If you're an experienced Data Modeller looking for your next challenge in Yorkshire, we'd be keen to hear from you.
Apply Now
If this sounds like the right opportunity for you, submit your CV today or contact our recruitment team for further information.
Diversity, Equity & Inclusion
Our client are committed to building an inclusive working environment where diverse perspectives are valued and everyone is treated with fairness, dignity and respect. We welcome applications from all backgrounds and do not discriminate on the basis of age, disability, gender, ethnicity, religion or belief, sexual orientation, or any other protected characteristic. They also believe that diverse teams lead to better thinking, stronger collaboration and improved outcomes for the healthcare organisations and communities they support.
“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