At a Glance
- Tasks: Lead the design and development of data models for a modern financial services platform.
- Company: Transform Together, a digital transformation consultancy driving business and technology change.
- Benefits: Competitive salary, hybrid work options, and potential for permanent position.
- Other info: Join a collaborative team focused on innovation and professional growth.
- Why this job: Shape the future of data in a dynamic environment with real impact on financial services.
- Qualifications: Experience in data analysis, modelling, and strong SQL skills required.
The predicted salary is between 54000 - 72000 £ per year.
Principal Consultant - Lead Data Analyst / Data Modeller
Company
Transform Together
Contract
6-month Fixed Term Contract, with option to extend or become a permanent member of the team
Compensation
Location
Hybrid / client-site as required
Technology environment
- AWS, Databricks, lakehouse architecture, complex relational databases, ETL/CDC pipelines
- About Transform Together
Transform Together is a digital transformation consultancy helping organisations deliver business and technology change.
We work with clients to bridge the gap between business ambition, operating model change and technology delivery.
We are growing our data and AI delivery capability and are looking for a Lead Data Analyst / Data Modeller to support the delivery of a strategic data platform within a complex financial services environment.
Role Overview
We are looking for a hands-on Lead Data Analyst / Data Modeller to define, build and govern canonical data models that will underpin a modern cloud-based data platform.
This is not a pure reporting analyst role.
The role requires someone who can understand complex financial services data, translate operational processes and business logic into clear data requirements, and work closely with engineering and architecture teams to turn those requirements into scalable AWS and Databricks-based data products.
The successful candidate will be central to shaping the data foundation for multiple platform capabilities, including:
- Data extraction and ingestion from complex relational databases.
- Data quality, validation and exception management.
- Outbound client reporting and self-service reporting.
- Reconciliation and data movement processing.
- Automated analytical outputs and operational data products.
The core outcome of the role is to create a reusable, governed, canonical data model that standardises data across clients, schemes, source systems, processes and downstream outputs.
Key Responsibilities
- Canonical Data Modelling
- Lead the design and development of canonical data models for a modern financial services data platform.
- Define conceptual, logical and physical data structures across key business entities, including clients, schemes, members, benefits, products, sources, transactions, movements, payroll, validation results and reporting outputs.
- Translate data from complex relational databases, operational systems, client files and third-party data sources into standardised canonical structures.
- Define source-to-target mappings, transformation rules, data definitions and data lineage.
- Ensure the canonical model supports downstream capabilities including validations, reporting, reconciliation, automated processing, analytics and future AI-enabled use cases.
- Work with Solution Architects and Data Engineers to ensure the model is implementable within AWS and Databricks architecture.
- Data Analysis, Requirements and Quality Control
- Interpret complex operational processes, data flows, business logic and stakeholder needs.
- Convert business and operational requirements into clear data requirements, mapping documents, model specifications and acceptance criteria.
- Support workshops with business SMEs, technology stakeholders, architects and engineering teams.
- Challenge unclear or incomplete requirements and identify where business logic is hidden in spreadsheets, manual processes or individual SME knowledge.
- Analyse legacy data structures and identify standardisation, cleansing, transformation and remediation needs.
- Define data quality rules, validation logic and exception handling requirements.
- Support metadata-driven validation design, ensuring validation rules can be stored, maintained and audited against the canonical model.
- Analyse data quality issues and identify repeatable remediation patterns.
- Define data quality dashboards, exception reporting and data health metrics.
- Ensure validation outputs can support audit, regulatory assurance and operational sign-off.
- ETL, CDC and Engineering Collaboration
- Work with Data Engineers to define ingestion requirements from complex relational databases, operational platforms and structured client files.
- Produce clear source-to-target mapping documents for ETL and CDC pipelines.
- Validate that engineering outputs align to the agreed canonical model and business rules.
- Support data reconciliation between source systems, staging layers, transformed data and reporting outputs.
- Reporting, Reconciliation and Data Product Enablement
- Define the data structures required for outbound client reporting, including client-level, scheme-level, member-level and movement-based reporting.
- Support automated report data models for PDF, Excel, dashboards and client self-service outputs.
- Support reconciliation use cases by defining movement, current-position and exception-based data requirements.
- Support automation use cases by identifying data needed to populate operational tools, automate filtering and create reusable outputs.
- Ensure data models can support client-specific variations while avoiding excessive bespoke build.
- Documentation and Governance
- Produce and maintain data dictionaries, entity relationship models, lineage documentation, mapping specifications and data quality rule catalogues.
- Document assumptions, unresolved questions, data risks and model design decisions.
- Support architecture review and governance forums with clear data analysis evidence.
- Ensure documentation is usable by engineering, QA, business stakeholders and future support teams.
- Help establish data modelling standards and reusable templates for Transform Together’s wider data and AI delivery capability.
- Key Deliverables
The Lead Data Analyst / Data Modeller will be expected to produce and own the following outputs:
- Canonical data model.
- Conceptual, logical and physical data model views.
- Source-to-target mapping documents for complex relational databases and structured data sources.
- Data dictionary and business glossary.
- Data quality and validation rule catalogue.
- Data lineage and transformation documentation.
- Data requirements for ingestion, validation, reporting, reconciliation and automation capabilities.
- Reporting data model and movement/reconciliation data structures.
- Data acceptance criteria and test support documentation.
- Data issue log, assumptions log and model decision log.
- Handover documentation for engineering, QA and operational support.
Essential Skills and Experience
- Experience in financial services, pensions, insurance, wealth management, asset management or regulated data environments.
- Strong experience as a Lead Data Analyst, Data Modeller or Senior Data Analyst on complex data platform delivery.
- Proven experience designing canonical data models or enterprise logical data models.
- Strong understanding of data modelling techniques, including conceptual, logical and physical modelling.
- Strong SQL skills and ability to interrogate complex relational data structures.
- Experience working with cloud data platforms, ideally AWS and Databricks.
- Understanding of modern data architecture, data ingestion, ETL/ELT pipelines and CDC patterns.
- Ability to work closely with Data Engineers, Solution Architects, QA, business SMEs and senior stakeholders.
- Strong understanding of data quality, validation rules, reconciliation and exception management.
- Experience working in Agile or hybrid delivery environments.
- Excellent stakeholder management skills, with the ability to explain complex data topics to non-technical audiences.
- Strong documentation discipline and attention to detail.
Desirable Experience
- Experience working with complex relational databases and legacy operational platforms.
- Experience with regulatory, client or operational reporting.
- Experience supporting data migration, legacy system modernisation or platform replacement.
- Experience with Databricks, Delta Lake, Spark SQL or Py Spark.
- Experience defining validation frameworks, data quality dashboards or metadata-driven rule engines.
- Experience working in consultancy or client-facing delivery environments.
- Behaviours and Consulting Fit
We are looking for someone who can operate with the pace, ownership and clarity expected in a consulting environment.
The right person will be
- Structured and analytical, with strong attention to detail.
- Comfortable working with ambiguity and incomplete documentation.
- Confident challenging business and technical stakeholders when requirements are unclear.
- Collaborative, pragmatic and delivery-focused.
- Able to bridge business, data and engineering teams.
- Comfortable working at both detailed data-field level and wider platform-design level.
- Proactive in identifying risks, assumptions and dependencies.
- Clear in communication and able to simplify complexity.
- Accountable for outcomes, not just analysis outputs.
Contact Details:
Transform Together Consulting Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Principal Consultant - Lead Data Analyst / Data Modeller in Slough
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Transform Together Consulting!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Principal Consultant - Lead Data Analyst / Data Modeller at Transform Together Consulting.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Transform Together Consulting.
✨Apply Directly through Our Website
When you find a suitable opening like Principal Consultant - Lead Data Analyst / Data Modeller at Transform Together Consulting, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Principal Consultant - Lead Data Analyst / Data Modeller in Slough
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Transform Together Consulting, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Transform Together Consulting. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Transform Together Consulting
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Transform Together Consulting!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
