Senior Data Modeller
Hybrid
London, United Kingdom
Freelance
12-03-2025
Job Specifications
Job Description:
Key Responsibilities
Review existing domain data mart models/architecture to ensure that they meet the needs of our data strategy and are optimised to support our key analytical use cases.
Design and develop remediated designs/models and work with engineering and analytical stakeholders across the different domains to create backlogs for model standardisation and improvements.
Ensure storage and consumption approaches/designs deliver maximum efficiency, with a focus on balancing storage and compute costs optimally.
Produce and maintain modelling and design guardrails, standards and processes and integrate these with wider data management and engineering governance, for example:
Data query performance
Data table structures
Partitioning of data across S3 and other object stores
Data Lifecycle Management – especially in AWS S3 and other cloud object file systems where storage costs are key
Where and how business logic is developed, tested, approved and embedded
Who can create permanent or semi-permanent data, where it can be created and how it is managed
How data is presented and accessed
Review data modelling and technical approaches to ensure that they are consistent and of high quality.
Skills
An experienced, driven expert in a broad set of data capabilities such as:
Data design patterns and optimisation across disparate mediums within a Cloud-based environment (preferably AWS) such as large object file systems (AWS S3), RDBMS and columnar databases
A strategic thinker who can define modelling patterns for various layers of a data environment balancing storage vs. compute costs, optimised for as broad a set of use cases as possible
Extensive data modelling experience, from conceptual to physical
Expertise in different modelling methodologies such as 3NF, Dimensional, Data Vault
Expertise in building cloud data warehouses using Kimball, preferably using AWS Redshift
Knowledge/experience of building queries and MI outcomes utilising data visualisation technologies (e.g., Tableau)
• Qualifications in RDMBS design and/or administration and in AWS architecture (at least one of these)
• Awareness of data governance and data ethics in the production of automated modelling
• Proven track record of delivery of modelling designs/approaches in large scale data environments
• Evidence of broad stakeholder management from senior business level down to analyst
• Experience in, or extensive exposure to MI/BI use cases, data exploration and analysis. Experience within predictive modelling/Data Science would be an advantage
• Experience in defining and delivering data monitoring across a large platform as well as establishing governance forums, processes and guardrails to ensure compliance with standards
About the Company
Avance Consulting is a global organization focused on delivering innovative talent solution services to some of the most renowned companies in the world, across industries that include Information Technology, Financial Services, Media and Entertainment, Telecom, FMCG, and Healthcare. Our deep understanding of the domains that we focus on is our key strategic differentiator. Our team of over 600 professionals are from a range of distinct industry sectors and utilize their vast professional networks and business knowledge to ... Know more
Related Jobs
- Company Name
- Dabster
- Job Title
- Data Architect
- Job Description
- About Us: At Dabster, we specialize in connecting top talent with leading global companies. We seek an experienced Data Architect to join our client's team in London, UK. Our mission is to be the foremost recruitment specialist in securing exceptional talent for a diverse range of global clients. Who You Will Work With: We are a leading IT solutions provider specializing in cloud and cognitive services, AI, and digital transformation. Headquartered in India, it serves global clients across banking, finance, insurance, and other industries, delivering innovative and customer-centric solutions. Job Summary: A Data Architect to manage a critical project for one of our biggest clients in banking domain. The Individual should be passionate about technology, experienced in developing and managing cutting edge technology applications. Years of experience needed: 15+ Yrs Technical Skills: Senior Data Architect with 15+ years of experience in data modeling in Capital Markets domain Experience implementing data model for various capital market instruments like Fixed income, currency, and commodities. Deep understanding of various systems/application in capital markets domain including front office systems, eFI, eFX, risk and compliance etc. Experience working with data structures, market feeds, and trading systems Strong experience with SQL, ETL tools, and cloud technologies (AWS, Azure, GCP). What We Offer: • Competitive Salary • Opportunity to work with a leading company • An opportunity to be part of impactful projects that shape the future of the industry. How to Apply Apply by submitting your resume today, showcasing your relevant experience and passion for the position via LinkedIn Easy Apply or directly to james.a@dabster.net.
- Company Name
- Rebel Energy UK
- Job Title
- Analytics Engineer
- Job Description
- We're hiring an Analytics Engineer We are offering this role as a three-month rolling contract, with a view to making it a permanent position later in the year, subject to suitability. What You’ll Be Doing: Engineer high-performance dbt models to power analytics at scale. Craft efficient SQL transformations that fuel real-time reporting and intelligent dashboards. Own data lineage, versioning, and governance to ensure a rock-solid analytics foundation. Partner with Data Science, BI, and Automation teams to unlock deep insights and drive data-driven decision-making. Tech Stack We Use: SQL | Python | Apache Spark | dbt | Git | Databricks | AWS | AzureDevOps | Kafka | Scala | PowerBI What We’re Looking For: Driven & Committed – You bring energy and determination to everything you do, always striving to deliver excellence. Resilient & Adaptable – You know that building something meaningful isn’t easy. You don’t shy away from challenges and see setbacks as learning opportunities. Creative & Full of Ideas – You don’t just execute tasks - you think. You challenge the status quo, bring new perspectives, and actively contribute to our direction. Strong Personal Values – You take pride in your work, operate with integrity, and care about making a real impact. Socially a Great Fit – You’re a good vibe - serious about the work but also fun to be around. You help create a positive, collaborative, and high-energy environment. Willing to Learn & Grow – You’re hungry to develop, push yourself beyond your comfort zone, and embrace continuous learning. Hardworking & Accountable – You don’t just "clock in," you care. You’re invested in the outcome and are willing to put in the time to make things happen. Location: This role offers the best of both worlds - work from home when you need to focus, and join the team in our Teddington, London office whenever you fancy some collaboration, creativity, or just a good coffee! There are no strict in-office requirements, but we all tend to come in regularly to catch up, share ideas, and make things happen. Competitive salary + benefits after probation. If you're driven, fearless, and ready to build something big - apply now! Join the rebellion by emailing your CV to bearebel@rebelenergy.com and one of the team will be in touch. #Hiring #AnalyticsEngineer #DataJobs #ETL #Databricks #dbt #SQL #Python #DataPipeline #TechCareers #StartupJobs #AI #BigData #MachineLearning #CloudComputing #AWS #Azure #DataWarehouse #BusinessIntelligence #CareerGrowth #JobSearch #WeAreHiring
- Company Name
- ea Change
- Job Title
- Data Analyst
- Job Description
- Data Analyst Rate: Up to £500 day Inside IR35 (via umbrella) Duration: Initial 6 month contract - possible long term extension Location: Gloucestershire (hybrid working) PLEASE DO NOT APPLY UNLESS YOU ARE ABLE TO BE IN GLOUCESTERSHIRE 2 TIMES PER WEEK Data Analyst with experience in SQL and Snowflake required for a 6 month contract working with a leading Financial Services client. Key skills / experience required: Strong use of SQL Knowledge of Snowflake Experience with Data Warehousing Able to manipulate and manage complex sets of data for project lifecycle input. Experienced working to ETL processes Ability to communicate effectively and liaise with varying stakeholders Experienced as a Data Analyst within Financial Services
- Company Name
- Nexere Consulting
- Job Title
- Data Engineer
- Job Description
- As a Data Engineer, you will play a pivotal role in shaping how data is harnessed to drive decision-making and enhance services across the council. You will work within a dedicated product team, designing and developing high-quality data solutions that ensure data integrity, accessibility, and scalability. You will be responsible for building and running data products and services that generate high-quality insights, supporting the council’s mission to use data effectively in service delivery. This is an exciting opportunity to influence how a high-profile local authority utilizes data to benefit its residents and stakeholders. £427 PD 3 MONTH INITIAL CONTRACT Key Responsibilities Develop, optimize, and maintain scalable data pipelines and architectures. Ensure high data quality and availability, both internally and externally shared datasets. Build and run data products to provide high-quality insights. Work with modern data engineering tools and cloud-based technologies, such as Azure Data Factory, Synapse, and Snowflake. Implement dimensional data models and work with SQL and NoSQL databases, including time-series databases like InfluxDB. Utilize Python for data pipeline development and visualization. Deploy applications using Docker and contribute to CI/CD pipelines To succeed in this role, you will bring: Extensive experience in developing scalable, reusable data pipelines on cloud services. Strong cloud data engineering experience, particularly in Azure Data Factory, Synapse, and Snowflake. Proficiency in Python, SQL, and NoSQL databases, with a focus on time-series databases (e.g., InfluxDB). Knowledge of dimensional modeling and experience deploying applications using Docker. Familiarity with CI/CD operating models and best practices in data engineering. To be considered for this role, please confirm: Do you have extensive experience creating scalable, reusable pipelines built on cloud services? Have you worked with Synapse and/or InfluxDB for pipeline development? Do you have experience working with data platforms, including IoT data?