data warehouses. Our data engineers create pipelines that support our data scientists and power our front-end applications. This means we do data-intensive work for both OLTP and OLAP use cases. Our environments are primarily cloud-native spanning AWS, Azure and GCP, but we also work on systems running self-hosted open source services exclusively. We strive towards a More ❯
data warehouses. Our data engineers create pipelines that support our data scientists and power our front-end applications. This means we do data-intensive work for both OLTP and OLAP use cases. Our environments are primarily cloud-native spanning AWS, Azure and GCP, but we also work on systems running self-hosted open source services exclusively. We strive towards a More ❯
using tools such as Erwin, Power Designer, SQLDBM or Sparx EA. Minimum 10 years experience in using databases such as Oracle, SQL Server, Snowflake or any other OLTP and OLAP databases. Minimum 5 years experience with reporting tools: Power BI, Business Objects, Tableau or OBI. Understanding of Master Data Management technology landscape, processes and design principles. Minimum 3 years of More ❯
and reporting visualisation (e.g. Power BI, Tableau) About You: Proven experience designing data architectures for large-scale platforms and diverse stakeholder groups Strong data modelling skills across OLTP and OLAP systems, with experience building datamarts and warehouses Proficiency with cloud-native tools (e.g. Snowflake, Databricks, Azure Data Services, etc.) High-level SQL skills and experience with tools like SSMS, SSIS More ❯
Manchester, North West, United Kingdom Hybrid / WFH Options
Anson Mccade
and reporting visualisation (e.g. Power BI, Tableau) About You: Proven experience designing data architectures for large-scale platforms and diverse stakeholder groups Strong data modelling skills across OLTP and OLAP systems, with experience building datamarts and warehouses Proficiency with cloud-native tools (e.g. Snowflake, Databricks, Azure Data Services, etc.) High-level SQL skills and experience with tools like SSMS, SSIS More ❯
Leeds, West Yorkshire, Yorkshire, United Kingdom Hybrid / WFH Options
Anson Mccade
and reporting visualisation (e.g. Power BI, Tableau) About You: Proven experience designing data architectures for large-scale platforms and diverse stakeholder groups Strong data modelling skills across OLTP and OLAP systems, with experience building datamarts and warehouses Proficiency with cloud-native tools (e.g. Snowflake, Databricks, Azure Data Services, etc.) High-level SQL skills and experience with tools like SSMS, SSIS More ❯
Central London, London, United Kingdom Hybrid / WFH Options
Anson Mccade
and reporting visualisation (e.g. Power BI, Tableau) About You: Proven experience designing data architectures for large-scale platforms and diverse stakeholder groups Strong data modelling skills across OLTP and OLAP systems, with experience building datamarts and warehouses Proficiency with cloud-native tools (e.g. Snowflake, Databricks, Azure Data Services, etc.) High-level SQL skills and experience with tools like SSMS, SSIS More ❯
West Midlands, United Kingdom Hybrid / WFH Options
Anson Mccade
and reporting visualisation (e.g. Power BI, Tableau) About You: Proven experience designing data architectures for large-scale platforms and diverse stakeholder groups Strong data modelling skills across OLTP and OLAP systems, with experience building datamarts and warehouses Proficiency with cloud-native tools (e.g. Snowflake, Databricks, Azure Data Services, etc.) High-level SQL skills and experience with tools like SSMS, SSIS More ❯
Bristol, Avon, South West, United Kingdom Hybrid / WFH Options
Anson Mccade
and reporting visualisation (e.g. Power BI, Tableau) About You: Proven experience designing data architectures for large-scale platforms and diverse stakeholder groups Strong data modelling skills across OLTP and OLAP systems, with experience building datamarts and warehouses Proficiency with cloud-native tools (e.g. Snowflake, Databricks, Azure Data Services, etc.) High-level SQL skills and experience with tools like SSMS, SSIS More ❯
Excellent communication skills and ability to work collaboratively Highly Desirable: Experience with automation and DevOps Engineer tools for database management and CI/CD pipelines Familiarity with data warehousing, OLAP/OLTP concepts, and modern data stack technologies Worked with Geolocation data What We Offer Competitive salary and benefits (dependent on experience) Corporate benefits package Office-based role in central More ❯
efficient data models, databases, and processing systems Create and test the additional Reports/Extracts required for Customers Support the Data team with process implementation, E2E testing, OLTP/OLAP reconciliation activities, keeping documentation up to date, fixing any issues with data based on feedback from SMEs To build robust, fault-tolerant data pipelines for ingesting, processing and transforming large More ❯
Strong background in data architecture and cloud platforms (e.g. Snowflake, Databricks) Cloud experience with AWS, Azure or GCP Excellent SQL and data modelling skills (data lakes, warehousing, OLTP/OLAP) Experience with access control, data migration and data governance Proficient in reporting tools (Power BI, Tableau) and evaluation tools (Postman) Consultancy experience highly desirable What’s on offer More ❯
Manchester, North West, United Kingdom Hybrid / WFH Options
Anson Mccade
Strong background in data architecture and cloud platforms (e.g. Snowflake, Databricks) Cloud experience with AWS, Azure or GCP Excellent SQL and data modelling skills (data lakes, warehousing, OLTP/OLAP) Experience with access control, data migration and data governance Proficient in reporting tools (Power BI, Tableau) and evaluation tools (Postman) Consultancy experience highly desirable What's on offer More ❯
tools and technologies Deep understanding of data modelling, enterprise data lifecycle with an appreciation of consumer risk domain identifying differences between operational data processing ('OLTP') vs analytical data processing ('OLAP') Additional skills include: Appreciation of proprietary technologies such as Apache, Cloudera Hadoop, SAS (Statistical Analytic Systems) and their use in Banking Appreciation of change management delivery methodologies in Waterfall, Agile More ❯
and streaming frameworks (e.g., Apache Spark, Flink, Kafka Streams, Beam), including orchestration via Airflow, Prefect or Dagster. Data Modeling & Schema Management: Demonstrated expertise in designing, evolving, and documenting schemas (OLAP/OLTP, dimensional, star/snowflake, CDC), data contracts, and data cataloguing. API & Integration Fluency: Building data ingestion from REST/gRPC APIs, file drops, message queues (SQS, Kafka), and More ❯
information management solutions and end-to-end development life-cycle support and SDLC processes Excellent problem solving and data modelling skills (logical, physical, semantic and integration models) including normalisation, OLAP/OLTP principles and entity relationship analysis Experience of leading a team including architects and subject matter experts Excellent communication and presentational skills The ability to work in a team More ❯
and experience in developing and supporting the BI systems with the focus being on Hyperion Workspace 9.3.0.1. They must have very good experience in the development of Applications in OLAP Environments particularly Hyperion Planning 11.1.1.2 and Hyperion Essbase. They should also have experience with SQL Server and SQL Server Integration Services SSIS. Good business understanding and ability to analyse business More ❯
prior work experience is required in .NET (C# or VB.NET) Also, prior work experience in one or more of the following: Microsoft SQL Server (database design, DBA, stored procedures, OLAP and reporting) Web services integration using SOAP or REST APIs A degree in Computer Science would be an advantage The successful candidate will be a person that enjoys software development More ❯
years prior work experience in .NET (C# or VB.NET) Also, prior work experience in one or more of the following: o Microsoft SQL Server (database design, DBA, stored procedures, OLAP and reporting) o Web services integration using SOAP or REST APIs A degree in Computer Science would be an advantage The successful candidate will be a person that enjoys software More ❯
Python with libraries such as Pandas In-depth knowledge of various database system technologies (relational, document, columnar, etc.) Understanding and experience with relational databases and implementation of OLTP and OLAP systems Professional experience in data modeling and database optimisation Nice to have: Experience in implementing version control for data artifacts Expertise in data migration strategies Familiarity with machine learning integration More ❯
large and complex datasets Managing a team backlog using tools like Jira or Azure DevOps Agile ways of working Familiar with Online Transaction Processing (OLTP) and OnlineAnalyticalProcessing (OLAP) systems Creating conceptual, logical and physical data models Creating mapping specifications for data migrations Coordinating User Acceptance Testing (UAT) with business stakeholders Knowledge of python (pandas) Experience with Cloud platforms More ❯
Develop backend services using Node.js (Express/Nest.js), FastAPI (Python-based services), Ariadne (GraphQL APIs), and Golang (Streaming services). Integrate with Databricks to expose and manage OLAP (OnlineAnalyticalProcessing) workloads, enabling API-driven data querying and analytics at scale. Architect APIs following metadata-driven design principles, ensuring that data can be dynamically exposed to users inside or outside … Kubernetes (EKS) for serverless and microservices architectures. Hands-on experience designing scalable and modular API architectures. Expertise in OAuth2, JWT, API Gateway, and dynamic authentication mechanisms. Strong knowledge of OLAP workloads and Databricks integration for API-driven data analytics. Experience with SQL/NoSQL databases (MongoDB, PostgreSQL, DynamoDB). CI/CD automation expertise (Jenkins, GitHub Actions, AWS CodePipeline). More ❯