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 ❯
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 ❯
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 ❯
proficiency in writing complex queries and optimizing performance. Python: Experience in data manipulation and scripting. Cloud Platforms: Hands-on experience with cloud data warehouses like Snowflake, Databricks, or BigQuery. OLAP, click stream, real time event processing databases. On prem data warehouse experience is valuable. Data Modeling: Expertise in designing and implementing data models for analytics. Data orchestration and transformation tools 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 ❯
