What Data Modeling Techniques Jobs are in the United Kingdom?

We are looking for a data analyst/data engineer with strong SQL & Python skills who loves organising and modelling data.

5+ years of experience in analytics engineering, data engineering or data analysis with strong transformation ownership.

Location: Scotland

• Build and maintain the analytics layer of our client's data environment, including data transformations, marts and semantic models.
• Partner with analysts and finance to define and implement core product and business metrics in the BI layer.
• Provide clean, well‑documented datasets and BI models that accelerate experimentation, product insights and reporting.
• Apply validation, testing and documentation standards to ensure high quality and trust in our data.
• Collaborate with the data platform team on ingestion, architecture and performance optimisation.
• Own data flows end to end, from event tracking definitions through ETL/ELT pipelines to ready‑made datasets and dashboards.
• Help define and enforce standards for how data models are stored, queried and shared across the company.

• Excellent SQL skills, including complex queries, window functions and performance tuning.
• Solid Python skills for ETL/ELT, data wrangling and workflow automation.
• Experience with data modelling techniques such as star schemas and dimensional modelling.
• Familiarity with modern data warehousing concepts including ELT and optimisation.
• Experience building metrics layers or standardising business metrics is desirable.
• Knowledge of testing and version control practices (Git, CI/CD).
• Understanding of product subscription metrics is an advantage.
• Experience with BI tools such as Looker, Tableau, PowerBI.

• Competitive Salary.
• Personalised Career Development: customised development plan, learning and development opportunities.
• Flexible working: flexible work arrangements to support work‑life balance.
• A fantastic benefits package including generous annual leave, enhanced family‑friendly benefits, pension scheme, access to private health, well‑being and insurance schemes, employee assistance programme, discounted cash plan and more.
• Diversity and inclusion: we are an equal‑opportunity employer and embrace diversity in all its forms. We encourage all applicants to apply regardless of age, disability, gender identity or reassignment, marital or civil partner status, pregnancy or maternity status, race, colour, nationality, ethnic or national origin, religion or belief, sex or sexual orientation. Your perspective and potential are important to us.
• Support for accessible hiring process and adjustments if needed.

Seniority level: Entry level

Employment type: Full‑time

Job function: Information Technology; Industries: IT Services and IT Consulting

• Design and develop conceptual, logical, and physical data models for enterprise‑scale data lake and data warehouse solutions, ensuring consistency across all layers
• Establish and enforce design principles, standards, and naming conventions to promote reusable and well‑governed data assets
• Deliver high‑quality data models for priority domains and support a structured expansion across the enterprise
• Align modelling standards with governance frameworks, including London Market standards (ACORD, CDR, MRC) and regulatory requirements
• Define processes, ownership, and tooling to manage and evolve data assets over time
• Support data integration processes (batch and real‑time) using tools such as Informatica, SSIS, MuleSoft, DataStage, and similar platforms
• Produce clear functional and technical documentation (data models, dictionaries, integration specifications, testing plans)
• Collaborate with business stakeholders to analyse requirements and translate them into technical solutions
• Stay current with evolving technologies and recommend improvements to data architecture approaches
• Lead and contribute to enterprise data architecture strategy, including data movement, tooling, and design standards
• Engage with project managers, business users, and technical teams to ensure best practices in data modelling
• Perform reverse engineering of physical data models from databases and scripts
• Maintain version control and documentation standards to ensure consistency across delivery teams

• Strong experience within the insurance data domain; London Market experience highly desirable
• Proven experience with enterprise data modelling tools (e.g. ERwin, ER/Studio, PowerDesigner)
• Expertise across database platforms (Oracle, SQL Server, Teradata, Snowflake, and cloud‑native databases)
• Knowledge of data architecture methodologies (Dimensional, ODS, Data Vault, Data Mesh)
• 5–7 years’ experience in technical leadership or management roles
• Consulting experience preferred
• Strong skills in data analysis, profiling, and data quality assessment
• Experience with data warehousing and OLTP systems
• Strong knowledge of data integration patterns and best practices
• Familiarity with SDLC processes and agile delivery methodologies
• Understanding of modern data platforms (cloud, real‑time, streaming, big data)
• Experience with cloud platforms (Azure, AWS, GCP)
• Knowledge of London Market standards and regulatory frameworks desirable

• Ability to translate business requirements into enterprise‑level data designs and technical specifications
• Experience running conceptual data modelling workshops
• Strong documentation and presentation skills
• Demonstrated problem‑solving and innovation capabilities
• Ability to work independently and collaboratively across functions
• Comfortable working in fast‑paced, agile environments
• Strong stakeholder management and communication skills
• Experience validating business rules using SQL or BI tools
• Understanding of enterprise data management (EDM) and semantic modelling layers
• Knowledge of modern analytics and reporting frameworks

• Competitive salary with bonus and comprehensive benefits package (including healthcare, pension, and life assurance)
• Access to financial wellbeing benefits and retail discount schemes
• Ongoing professional development, training, and learning opportunities
• Inclusive and diverse working environment

Applicants must have the right to work in the United Kingdom.

Overview

Strong SQL skills, DBT model development, Snowflake ETL pipelines, data transformation and data warehousing.

• Develop and maintain data warehousing solutions using DBT and Snowflake
• Build robust ETL/ELT pipelines to support analytics and reporting needs
• Ensure data quality, integrity and security within the warehouse environment
• Optimize queries and data models for performance and cost efficiency

• Hands-on experience with DBT, Snowflake, and SQL-based data warehousing
• Strong understanding of data warehousing principles and best practices
• Ability to work collaboratively with business and technical teams

This range is provided by JAG Talent. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Direct message the job poster from JAG Talent

Are you an experienced Finance / Data Modeller with extensive experience using Anaplan?

JAG Talent is partnered with a well known hospitality group to hire an experienced Anaplan modeller into the team on a permanent basis. This role will sit within the finance function as the key point of contact for all financial modelling within Anaplan. This is a newly created role supporting all areas of the business, you will be a trusted partner and key stakeholder for driving commercial visibility through models.

• Designing, building and maintaining Anaplan models to support FP&A and other Finance use cases
• Acting as a trusted Anaplan expert, leading other Anaplan Page Builders within the Finance Team
• Ensuring models are intuitive, user-friendly, and support data-driven decision making through self-service analytics
• Identifying opportunities to streamline current model builds and enhance system functionality
• Defining and managing data links between the data warehouse and Anaplan models in order to ensure robust and accurate data at all times
• Building strong strategic partnerships with Finance and Tech stakeholders to understand business priorities and develop valuable use cases
• Promoting best practices in Anaplan model design and fostering a collaborative, inclusive working culture

Ideally you will have some experience working and partnering with Finance teams, supporting through transformation.

If this sounds like a role for you APPLY NOW or email

• Seniority level Associate

• Employment type Full-time

• Job function Finance
• Industries Hospitality and Consumer Services

Referrals increase your chances of interviewing at JAG Talent by 2x

Get notified about new Data Modeler jobs in Putney, England, United Kingdom .

London, England, United Kingdom 5 days ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 2 weeks ago

London Area, United Kingdom £75,000.00-£175, hours ago

London Area, United Kingdom $150,000.00-$200,000.00 3 weeks ago

London, England, United Kingdom 3 weeks ago

London, England, United Kingdom £120,000.00-£130,000.00 6 hours ago

London, England, United Kingdom 4 days ago

London, England, United Kingdom 9 hours ago

London, England, United Kingdom 3 weeks ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 3 weeks ago

Richmond Upon Thames, England, United Kingdom 6 days ago

London, England, United Kingdom 21 hours ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

This range is provided by CBSbutler. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range details will be discussed with the recruiter.

We’re looking for a dedicated Data Modeler to join a leading organisation in the London markets. This is a hands-on contract role (not an Architect, not a Developer-who-dabbles, not a Manager-in-hiding). You’ll be laser-focused on designing and delivering enterprise-grade data models across warehouses, lakes, and vaults.

You’ll be responsible for:

• Designing and developing conceptual, logical, and physical data models .
• Implementing models across RDBMS, ODS, data marts, and data lakes (SQL/NoSQL).
• Translating business needs into robust, long-term data models.
• Applying Data Vault 2.0 techniques in real-world implementations.
• Supporting metadata management, governance, and best practices with tools like Erwin or ER/Studio .

Must-Haves

• 5+ years hands-on experience as a Data Modeler (your CV should scream “Data Modeler,” not hide it in bullet lines).
• 2+ years hands-on Data Vault modelling.
• Strong background in data warehouses, data lakes, and enterprise big data platforms in multi-data-centre contexts.
• Proficiency with metadata management and data modelling tools (Erwin , ER/Studio , or similar).

• ETL/Data Transformation experience – ideally Qlik Compose or AWS Glue (alternatives like DataStage, SSIS acceptable).
• Familiarity with modern dev methodologies (Agile/Scrum, TDD).
• Knowledge of testing tools, scripting, and data cleansing techniques.

• Architects (too high-level, not hands-on enough).
• Developers who only list “data modelling” as one of many tasks.
• Generalists who do “a bit of everything.”
• Candidates focused on ETL development, management, or project coordination.

This is a contract role in London’s financial markets , offering the chance to work with enterprise-scale data in a dedicated modelling capacity. If your CV shows a consistent trajectory as a Data Modeler , we’d love to see it.

• Mid-Senior level

• Contract

• Consulting

• IT Services and IT Consulting

Data Modeler – RED Global

I am working directly with a Global company that is looking for a Data Modeler to support a major project. The initial contract will be until March 2026 (extensions likely).

Duration: Initial contract until March 2026 (extensions likely)

Location: Hybrid 2-3 days per week in London

Key Skills/Experience Required:

• 5+ years experience in Data Modelling/Data Architect roles
• Hands on experience with AWS cloud platforms
• OLAP (Online Transaction Processing) and OLTP (Online Analytical Processing) experience is a must
• Strong CI/CD pipeline knowledge

If you are interested in this opportunity please respond directly with your updated CV or message me directly for more details regarding the role.

Join to apply for the Data Modeler role at Falcon Smart IT (FalconSmartIT) .

Experience and Skills:

• 10+ years of experience in data modeling.
• At least 1 year of experience implementing a data model for an enterprise analytical platform.
• 4+ years of experience in developing ER and Dimensional models.
• Experience in the Investment domain, with knowledge of Fund, Holdings, Cashflow, etc.
• Experience in building conceptual, logical, and physical models.
• Knowledge of SQLDM tool is an advantage.
• Knowledge of BigQuery is an advantage.

Additional Information:

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: IT Services and IT Consulting