11 of 11 Permanent OLAP Jobs

issues from logs and metrics. Deep SQL knowledge and experience with analytical/columnar databases. ClickHouse experience is a significant plus; experience with any OLAP system (BigQuery, Redshift, DuckDB, Druid) translates well. Experience designing data models for large-scale analytical workloads — you understand denormalisation trade-offs, partitioning strategies ...

Desirable Good knowledge of business change techniques. Experience in developing and implementing roadmaps and strategies. Use of reporting tools linked to SQL databases incorporating OLAP "cubes" Use of MS Reporting Services Use of Business Objects Personal Qualities Essential Excellent team worker. Systematic in approach. Confident, highly motivated and able ...

Microsoft SQL Server fundamentals including, indexes, statistics, query plans, tempdb, installation, configuration, DMVs and, troubleshooting. A good understanding relational table design including normalisation, constraints, OLAP vs OLTP, traditional data warehousing. Experienced in critical thinking and troubleshooting. Experience with Azure SQL Database and Azure SQL Managed instance would be beneficial. Experience ...

organise information in order to elicit requirements and identify solution ideas Working knowledge of data management and business intelligence concepts (e.g. reporting, querying software, OLAP, spreadsheets, dashboards, and data mining) Ability to facilitate the implementation of new functionality through training sessions, demos, and the development of appropriate documentation Familiarity with ...

within the decision support team to contribute to data analysis and data-mining projects. Maintain and improve self-service business intelligence tools (such as OLAP cubes and Power BI), ensuring information is accurate, up to date, and any issues are quickly resolved. Extract and analyse data from multiple sources ...

robust data ingestion pipelines from telematics providers handling high-volume, multi-tenant data reliably Develop and maintain our analytics processing layer, working with modern OLAP tooling to power real-time fleet intelligence Build and maintain APIs that serve data to internal systems and customer-facing products Contribute to front ...

. You will understand Metadata management tools, TSQL/Stored procedure generation/Query Optimisation, SQL Server Integration Services (SSIS), Analysis Services (SSAS) including OLAP cube design and dimension modelling, Administration (backup, infrastructure provisioning, replication, security, Analysis and presentation (MS Excel, PowerPivot, SSRS, Tableau) experience of automated data integration using ...

. You will understand Metadata management tools, TSQL/Stored procedure generation/Query Optimisation, SQL Server Integration Services (SSIS), Analysis Services (SSAS) including OLAP cube design and dimension modelling, Administration (backup, infrastructure provisioning, replication, security, Analysis and presentation (MS Excel, PowerPivot, SSRS, Tableau) experience of automated data integration using ...

. You will understand Metadata management tools, TSQL/Stored procedure generation/Query Optimisation, SQL Server Integration Services (SSIS), Analysis Services (SSAS) including OLAP cube design and dimension modelling, Administration (backup, infrastructure provisioning, replication, security, Analysis and presentation (MS Excel, PowerPivot, SSRS, Tableau) experience of automated data integration using ...

What You Will Be Doing • Design and build a scalable analytics architecture capable of handling hundreds of millions of transactions • Build and optimise an OLAP analytics stack separate from the transactional database • Design and maintain ETL/ELT pipelines moving data from transactional systems into the analytics warehouse • Ensure data … experience as a Senior Data Engineer • Advanced SQL skills and strong query optimisation experience • Experience building large scale analytics systems • Hands-on experience with OLAP databases such as ClickHouse, Snowflake or Amazon Redshift • Experience designing and implementing ETL pipelines from scratch • Experience implementing caching strategies using Redis or AWS ElastiCache ...

Data Analyst you will play a key role in designing, building and maintaining our business intelligence tools such as Power BI and OLAP Cubes and develop SQL data solutions. The BI and Data Analyst will ensure accuracy and timeliness of information, investigating and correcting any discrepancies found. This role … within the decision support team to contribute to data analysis and data-mining projects. Maintain and improve self-service business intelligence tools (such as OLAP cubes and Power BI), ensuring information is accurate, up to date, and any issues are quickly resolved. Extract and analyse data from multiple sources ...