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 More ❯
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 More ❯
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 More ❯
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 More ❯
years of experience on BA in fintech or banking Sound understanding of BI best practices/methodologies, relational structures, dimensional data modelling (OLAP, OLTP, etc.), scale, structured query language (SQL) skills, query performance tuning, data warehouse and reporting techniques In-depth analytical/problem solving mind set, with the capability More ❯
platforms (Azure Synapse, Snowflake, GCP BigQuery) and modern data storage solutions. Strong SQL skills and good knowledge of data warehousing, lakehouses, and OLTP/OLAP systems. Solid understanding of data governance, data quality, and master data management principles. Familiarity with data privacy, compliance, and security standards (e.g., GDPR, PCI-DSS More ❯
Visio). Experience with database management systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL). Familiarity with data warehousing concepts and technologies (e.g., ETL processes, OLAP). Understanding of data governance, data quality, and data management best practices. Proficiency in SQL and ability to write complex queries for data extraction and More ❯
data structures for analytics and Reporting. - Implement data structures using best practices in data modeling, ETL/ELT processes, and SQL, AWS - Redshift, and OLAP technologies, Model data and metadata for ad hoc and pre-built reporting. - Work with product tech teams and build robust and scalable data integration (ETL More ❯
You’ll design and implement data pipelines in Python within an AWS cloud environment, working on data modelling for large-scale Data Lake and OLAP systems. Key responsibilities will include optimising performance in cross-region setups, ensuring data completeness and quality, and contributing to the software and infrastructure design. This More ❯
City of London, London, United Kingdom Hybrid / WFH Options
Xcede
You’ll design and implement data pipelines in Python within an AWS cloud environment, working on data modelling for large-scale Data Lake and OLAP systems. Key responsibilities will include optimising performance in cross-region setups, ensuring data completeness and quality, and contributing to the software and infrastructure design. This More ❯
London, England, United Kingdom Hybrid / WFH Options
Leidos
mirroring and shared-storage clusters • Administration of Windows Server Failover Cluster Good working knowledge of Windows Server 2012R2 - 2022 • Good understanding of OLTP and OLAP databases and the ACID properties of transactional processes • High level security and auditing best practice knowledge Advantageous: • T-SQL scripting • PowerBI reporting • Utilising the Sysinternals More ❯
Cloud computing Globally-distributed database replication/synchronization patterns Technical skills needed: MSSQL 2008 up thru 2016 Postgres Informatics Tableau MS SSIS - SSAS - BI OLAP This is a 6-month contract in Canary Wharf, London. Please send your CV to us in Word format. More ❯
London, England, United Kingdom Hybrid / WFH Options
Endeavour Recruitment Solutions
and Data Marts in AWS. Creating efficient SQL queries and understanding query execution plans for tuning queries on engines like PostgreSQL. Performance tuning of OLAP/OLTP databases by creating indices, tables, and views. Write Python, Scala scripts for orchestration of data pipeline. Technical Experience and Skill set: 5+ years More ❯
Experience of database tuning, process automation and delivery mechanisms e.g. query plans, indexing. Demonstrate knowledge in any of the following areas: Relational Databases Linux OLAP Qualifications Degree or equivalent in an Information Technology, or Information Technology related field or significant equivalent experience. Communication Skills Good communication and interpersonal skills. Disclosure More ❯
SSIS, SSAS, SSRS) Design and implement complex SQL queries, stored procedures, and performance tuning Contribute to data warehouse architecture and dimensional modeling Work within OLAP and ETL frameworks to support scalable BI solutions Collaborate with cross-functional teams to translate business needs into technical solutions Required Skills & Experience: Proven experience … level proficiency in SQL and complex query development Solid understanding of data warehousing concepts and data mining techniques Familiarity with database management systems and OLAP architecture Awareness of AWS platforms is a plus Excellent analytical and problem-solving skills Nice to Have: Experience with Power BI and Master Data Services More ❯
London, England, United Kingdom Hybrid / WFH Options
Cleo
or similar). Experience with at least one distributed data-processing framework (Spark, Flink, Kafka, etc.). Familiarity with different storage solutions (e.g., OLTP, OLAP, NoSQL, object storage) and their trade-offs. Product mindset and ability to link technical decisions to business impact. Excellent cross-functional communication—able to partner More ❯
ClickHouse Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries, emphasizing speed in managing escalating data volumes.Enterprises globally, including Lyft More ❯
in a fast-paced environment. Excellent communication skills, a collaborative mindset, and a passion for continuous improvement are essential. Experience with financial reporting structures, OLAP cubes, or platforms like App Studio is advantageous, as is a background in finance or high-volume transactional environments. This role is offered on a More ❯
translate them into technical solutions. • Build compelling story, new product features and actionable insights using Data • Manage ad hoc analytic requests for OLTP and OLAP systems in an accurate and efficient manner. • Responsible for reviewing and optimization of SQL queries and investigating database performance issues. • Support Predictive Modeling, Forecasting and More ❯
volumes (100’s GB) of data over Kafka Large (100’s TB) data lake applications Large (10’s TB) databases (such as relational, timeseries, olap) Proven experience working with all of Expert level .net knowledge with few years of commercial .net development experience (ideally C# with .net Core 5+) A More ❯
on data-model trade-offs. What We’re Looking For: 5+ yrs building high-throughput backend systems Experience with BI/reporting engines or OLAP stores Deep Ruby/Rails & ActiveRecord expertise Exposure to ClickHouse/Redshift/BigQuery Event-driven or stream processing (Kafka, Kinesis) Familiarity with data-viz More ❯
What We’re Looking For Must-Have Nice-to-Have 5+ yrs building high-throughput backend systems Experience with BI/reporting engines or OLAP stores Deep Ruby/Rails & ActiveRecord expertise Exposure to ClickHouse/Redshift/BigQuery Event-driven or stream processing (Kafka, Kinesis) Familiarity with data-viz More ❯