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 »
West Midlands, England, United Kingdom Hybrid / WFH Options
Concept
Azure DevOps and CI/CD pipelines. Competencies: Knowledge of data warehouse management best practices. Solution design, build, and testing. ETL design and dimensional, OLAP, and relational-based solutions. Kimball and Inmon architectures. Design data quality and master data management processes. Thinking Orientation Acumen Collaborative Relationships Credibility Requirements: This role more »
West Midlands, Dudley, West Midlands (County), United Kingdom
Concept Resourcing
CD pipelines. Competencies: Strong knowledge of data warehouse management best practices. Proficiency in solution design, build, and testing. Skilled in ETL design and dimensional, OLAP, and relational-based solutions. Experience with Kimball and Inmon architectures. Ability to design data quality and master data management processes. Forward Thinking Results Orientation Business more »
West Midlands, Dudley, West Midlands (County), United Kingdom Hybrid / WFH Options
Concept Resourcing
challenging and complex environments. Competencies: Proficiency in data warehouse management best practices, controls, and standards. Ability to design and code ETL solutions for dimensional, OLAP, and relational-based systems. Experience with Kimball and Inmon architectures for solution design. Knowledge of designing data quality and master data management processes. Forward Thinking more »
West Midlands, Dudley, West Midlands (County), United Kingdom Hybrid / WFH Options
Concept Resourcing
challenging and complex environments. Competencies: Proficiency in data warehouse management best practices, controls, and standards. Ability to design and code ETL solutions for dimensional, OLAP, and relational-based systems. Experience with Kimball and Inmon architectures for solution design. Knowledge of designing data quality and master data management processes. Forward Thinking more »
big data initiatives. Good level of experience is required. Responsibilities: Build robust, high-performance, and adaptable solutions for modern platforms (GCP Big Query,Relational, OLAP) Finance data modelling extensive experience desired as the data lead. Talend/Informatica transformation logic experience is required Technical thought leadership on architecture, data modeling more »
of database tuning, process automation and delivery mechanisms e.g. query plans, indexing Desirable Demonstrate knowledge in any of the following areas: Relational Databases Linux OLAP Qualifications Essential Degree or equivalent in an Information Technology, or Information Technology related field or significant equivalent experience. Desirable Accredited Counter Fraud Specialist Communication Skills more »
of database tuning, process automation and delivery mechanisms e.g. query plans, indexing Desirable Demonstrate knowledge in any of the following areas: Relational Databases Linux OLAP Qualifications Essential Degree or equivalent in an Information Technology, or Information Technology related field or significant equivalent experience. Desirable Accredited Counter Fraud Specialist Communication Skills more »
have a strong understanding of data. Have experience working with large volumes of data (millions or records per day). Can build tabular (or OLAP) cubes properly (with DAX or MDX). Advanced SQL knowledge and ability to write performance optimized queries. You should have industry standard Data Modelling skills 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 »
Winchester Hampshire, Winchester, Hampshire, England
Nexus Jobs Limited
BI tools: SQL skills (2012), including writing stored procedures SQL Server Reporting Services SQL Server Analysis Services SQL Server Integration Services MDX to query OLAP cubes QlikView & QlikSense development Future tools may include: Windows SharePoint Services ASP.NET development in C# Location is Winchester Hampshire. Salary for this role will be more »
of the warehouse eg Power BI. Must have worked with Cloud Database technology like Google BigQuery, Snowflake etc. Should have Experience with Multi-dimensional OLAP cubes to store/reference data in semantic data layer. Asset Management data expertise. Strong SQL but MUST have DBT. ETL or ELT The position more »
Mongo, Cassandra, Postgres,BigQuery ..etc) and data modelling techniques Create conceptual, logical and physical data models with enterprise best practises and standards Worked on OLAP and OLTP applications Very good knowledge on ERStudio and Hackolade. Designed logical data model to consolidate various subject as including standard definition, data types, size more »
Degree level or equivalent qualification/experience plus additional specialist knowledge Experience Essential Significant relevant experience of hands on SQL queries, stored procedures and OLAP structures in an enterprise database environment Experience of scripting language (e.g. Python, Perl, Powershell) Demonstratable experience of data mining toolsets and software Relevant practical experience more »
years prior experience is required in one or more of the following: - .NET (C# or VB.NET) - Microsoft SQL Server (database design, DBA, stored procedures, OLAP and reporting) - Web services integration using SOAP or REST APIs Training in C/C++ will be provided but prior experience will be an advantage more »
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 more »
dimensions based on business needs. Development and Implementation: Develop ETL processes to extract, transform, and load data into Jedox. Build and configure multidimensional cubes, OLAP databases, and data models. Design and create reports, dashboards, and scorecards using Jedox Web or Excel add-in. Performance Optimization: Optimize cube performance by tuning more »
for data manipulation and query optimisation. Data Modelling : Familiarity with design tools like Kimball and DataVault. OLAP and OLTP : Strong understanding of both OnlineAnalyticalProcessing and Online Transaction Processing. Cloud Platforms : Experience with cloud services, preferably AWS or GCP. Data Models : Ability to create and implement both logical and more »