and assist the organisation to migrate to later versions. o Exposure and high-level understanding of the SSAS and MDX language (although the organisation currently does not use OLAP). o Good exposure to PowerBI and advance knowledge of DAX (query language) and data modelling using this tool. o Good working knowledge of Excel capability, use of the reporting purposes 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 ❯
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 ❯
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 ❯
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 ❯
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 ❯
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 ❯
or related field. - Experience gathering business requirements, using industry standard business intelligence tools to extract data, formulate metrics and build reports. - Hands-on experience in writing complex, highly-optimized OLAP SQL queries across large data sets. - Hands-on experience using large-scale data sets from complex multiple sources including the capability of investigating, familiarizing and mastering new data sets quickly. 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 ❯
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 ❯
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 ❯
Experience migrating mission-critical database applications from on-premise to the cloud or managing a hybrid cloud environment for large enterprise applications. Proficient in data modeling for OLTP and OLAP workloads. Extensive experience in performance monitoring, troubleshooting, and performance tuning. Experience influencing product roadmap and strategy, and prioritizing existing database initiatives to drive business outcomes. Experience writing high-performance Postgres 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 ❯
Technologies: TSQL MS SQL OLTP OLAP Data Warehouse Database BI Business Intelligence Reverse Engineer Database Security Endeavour Recruitment has a fantastic opportunity for an experienced Database Developer. In-depth T-SQL knowledge is essential. This role is in a prime location close to Air/Rail/Road Networks. Candidates should have a minimum of 4 years' experience. Salary guide … from you to discuss your experience. The ideal candidate will have wide experience of different database types, specifically OLTP and OLAP. Writing and Refactoring SQL and T-SQL OLTP, OLAP and Data Warehouse SQL/DB Best Practice Knowledge of Logical and Physical Design for Performance SQL Server Database Security Data and Algorithmic Analysis Advantageous Experience: Unit Testing TFS, GIT More ❯