1 to 25 of 39 Permanent Dimensional Modelling Jobs

from SSRS into Snowflake Assess and rationalise existing reports (remove duplication, improve logic, simplify where possible) Redesign reporting structures to align with modern data modelling principles Define and Implement Best Practice Establish scalable standards for: Data modelling (e.g. dimensional modelling, layered architecture) Transformation workflows (ELT patterns … experience working with Snowflake (or similar cloud data warehouse) Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects) Strong data modelling experience (dimensional modelling, star schemas, etc.) Experience building transformation layers in ELT environments Track record of delivering in hands-on roles ...

Azure tools such as Data Factory and/or Fabric Data Pipelines Experience with Python or PySpark for data transformation Understanding of data modelling (dimensional modelling, medallion architecture) Strong communication skills and ability to work with non-technical stakeholders Desirable: Experience migrating from legacy systems (e.g. ...

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

progress Key Experience Strong SQL and Python, including query optimisation and window functions Hands-on experience with Databricks and Spark Strong understanding of data modelling (3NF, dimensional modelling, star/snowflake schemas, data vault concepts) Experience designing and operating ELT/ETL pipelines Familiarity with data quality ...

requirements, designing architectures, guiding build teams, and ensuring solutions are secure, well-governed, and ready for production. You will combine strong engineering fundamentals (data modelling, integration, analytics) with practical Generative AI delivery (for example, retrieval‐augmented generation), and you will communicate clearly with both technical and non‐technical stakeholders. … where required), with an engineering mindset around testing, readability, and performance. Strong analytics capability across the Microsoft BI stack (Power BI, semantic modelling, governance and performance), with experience modernising from legacy MSBI where applicable. Demonstrable understanding of enterprise data concepts: dimensional modelling, lakehouse/warehouse patterns, metadata ...

images, text) and transformation into structured/vectorized formats Strong SQL skills for analytical queries, performance tuning, and data modeling (star/snowflake schemas, dimensional modeling, partitioning, clustering). Unstructured data & AI/RAG: Understanding of vector databases (e.g., Elasticsearch, Milvus, pgvector), embedding models, and RAG architectures. Familiarity with ...

discipline Strong Python skills with production-level engineering experience Experience with tools/frameworks such as pandas, Polars, DBT Strong understanding of data warehousing, dimensional modelling and medallion architecture Hands-on experience with cloud platforms: AWS, Azure or GCP Experience with orchestration tools such as Airflow, Prefect ...

assets to deliver high-performing, low-latency analytics at scale. Provide technical guidance through code reviews and mentorship, raising standards across data modelling and visualisation. Your Skills and Experience Strong commercial experience in BI engineering, analytics engineering, or data engineering within a modern data stack. Advanced SQL capability, including … complex transformations, window functions, and performance optimisation. Proven experience working with cloud data warehouses such as Databricks, Snowflake, or BigQuery. Deep understanding of dimensional modelling techniques and tools such as dbt. Hands-on expertise with enterprise BI platforms, such as Power BI, Looker or Omni. Ability to communicate ...

including MS SQL Server 4 years of experience in DB Development (OLTP) using MS SQL 2 years of experience in building Data Marts using dimensional models 2 years of experience in building Dashboards and KPI visualization on Power BI and/or Tableau Strong reporting and data warehouse development ...

etc.) Design reliable ingestion processes from APIs, databases, and file-based sources Apply best-practice pipeline design patterns for resilience and re-runnability Data Modelling & Analytics Enablement Design analytical data models that are performant, maintainable, and business-friendly Apply dimensional modelling techniques for BI and reporting … joins, optimisation) Hands-on Python for data processing and pipeline development Experience with Microsoft Fabric and Power BI (datasets, semantic models) Understanding of data modelling for analytics and reporting Familiarity with CI/CD, testing, version control, and data quality practices Exposure to data mesh/domain-oriented data ...

concepts (incremental loads, Slowly Changing Dimensions) • Experience working with large healthcare datasets (clinical, financial). • 5+ Years of experience in Data warehousing concepts (dimensional modeling, star schema, fact/dimension tables) • 5+ Years of Experience in Epic Cogito, Clarity, and Chronicles data flow. • 5-8 years of experience ...

Data Analyst plays a critical role in delivering high-quality analytical insight that drives decisions across AJ Bell. The role blends advanced analytics, data modelling, and stakeholder engagement to deliver solutions that are accurate, scalable, and aligned to our strategic data ambitions. The jobholder will support cloud transformation, adoption … Delivery & Technical Excellence Deliver high-quality analytical outputs for senior data leadership. Proactively deep dive and explore challenges to create recommendations Conduct data design, modelling and exploration to support trusted reporting. Perform data discovery to understand new and existing data sources. Produce compelling visualisations and dashboards using Power BI. ...

logical and physical data models that support efficient reporting, analytics, and self-service BI capabilitiesEstablish architectural patterns and frameworks (e.g. medallion architecture, data vault, dimensional modelling) for consistent implementation across data solutionsEvaluate and recommend architectural approaches for data storage, processing, and consumption, including lakehouse, data warehousing, and data … concept and technical assessments to validate new technologies before adoptionMonitor industry best practices and ensure Arriva's architecture remains competitive and future-proofData Modelling & StandardsDefine and document standard business entities, metrics, and KPIs to ensure consistency across reportingReview and approve complex data models designed by BI Engineers, ensuring alignment ...

physical data models that support efficient reporting, analytics, and self-service BI capabilities* Establish architectural patterns and frameworks (e.g. medallion architecture, data vault, dimensional modelling) for consistent implementation across data solutions* Evaluate and recommend architectural approaches for data storage, processing, and consumption, including lakehouse, data warehousing, and data … technical assessments to validate new technologies before adoption* Monitor industry best practices and ensure Arriva's architecture remains competitive and future-proof## Data Modelling & Standards* Define and document standard business entities, metrics, and KPIs to ensure consistency across reporting* Review and approve complex data models designed by BI Engineers ...

physical data models that support efficient reporting, analytics, and self-service BI capabilities* Establish architectural patterns and frameworks (e.g. medallion architecture, data vault, dimensional modelling) for consistent implementation across data solutions* Evaluate and recommend architectural approaches for data storage, processing, and consumption, including lakehouse, data warehousing, and data … technical assessments to validate new technologies before adoption* Monitor industry best practices and ensure Arriva's architecture remains competitive and future-proof## Data Modelling & Standards* Define and document standard business entities, metrics, and KPIs to ensure consistency across reporting* Review and approve complex data models designed by BI Engineers ...

teams to deliver high-quality, trusted data products that support analytics, reporting, and emerging AI initiatives. Key Responsibilities Define and own enterprise-wide data modelling standards, including Data Vault, semantic layers, Star Schema patterns, Snowflake object hierarchies, and governance frameworks. Design scalable integration architectures for legacy platforms, including AS400 … implementing solutions within Snowflake. Demonstrated success delivering enterprise-scale data transformation programmes and modernising legacy data environments. Deep expertise in Data Vault 2.0, Kimball dimensional modelling, and Inmon methodologies, with the ability to select the right approach for varying business requirements. Advanced knowledge of dbt and Git-based ...

learning solutions, including generative AI and responsible AI approaches. Knowledge of modern data architecture patterns including lakehouse, data integration, ETL/ELT, MDM, and dimensional modelling. Familiarity with enterprise application integration and low-code platforms. Experience with software delivery lifecycle practices, DevOps, deployments, migrations, and production support. Strong Agile ...

computer science, health information or a related discipline. Evidence of advanced specialist training and ongoing CPD in information management/BI (e.g., advanced SQL, dimensional modelling, data quality methods, Power BI/DAX or equivalent). Desirable Postgraduate qualification or equivalent evidence of advanced practice in analytics/ ...

management, business intelligence and decision support Experience in logical and physical database design, hands‐on modeling techniques, and development methodology; physical schema design including dimensional modeling for Business Intelligence Solutions. Knowledge of Business Intelligence practices and toolsets. Microsoft toolset knowledge a plus. Experience working with the business to facilitate ...

requirements Deliver insights through reports and visualisations Translate business needs into technical solutions Maintain and enhance data platforms and analytics systems Build and manage dimensional data models Conduct testing, troubleshooting and performance tuning Evaluate and improve existing BI systems Collaborate with technical teams to integrate systems Create and maintain … also required. What you'll need to succeed Essential Skills & Experience Proven experience in a data-focused role Strong background in data warehousing and dimensional modelling Understanding of database management systems, OLAP and ETL frameworks Experience with cloud data platforms (ideally Microsoft Fabric) Familiarity with Power ...

roadmap, ensuring alignment with business objectives and the BI product strategy Establish architectural patterns and frameworks (such as Medallion architecture, data vault or dimensional modelling) for consistent implementation across data solutions Define and document standard business entities, metrics and KPIs to ensure consistency across reporting Work with Group … requirements include: Extensive experience in data architecture, with proven track record of designing and implementing enterprise-scale data solutions Deep expertise in data modelling techniques with strong SQL proficiency Good knowledge of cloud data platforms (AWS preferred: Redshift, Athena, S3, Glue, knowledge of Azure or GCP beneficial) and modern ...

looking for Essential skills and experience Strong, hands-on experience with Power BI development Advanced capability in DAX, Power Query and data modelling Proven experience delivering BI solutions within a structured IT environment Strong SQL skills Solid understanding of data warehousing and dimensional modelling Additional strengths Excellent ...

functions (Data Taxonomy, Data Lineage, Data Governance) Experience with data analysis and data wrangling using tools such as SQL, Python Knowledge of relational and dimensional modelling Knowledge of data warehouse, operational data store and data mart design concepts Knowledge of source code management and DevOps platforms such ...

partnering closely with stakeholders across the organisation. The Role Support a major data platform migration, helping to build strong architectural foundations. Design and implement dimensional models and a robust semantic layer to enable trusted, self service analytics. Introduce and embed dbt as part of the transformation and modelling … where needed. Your Skills and Experience Strong commercial experience as a BI Data Architect or BI Engineer in modern analytics environments. Proven capability in dimensional modelling and designing semantic layers for BI tools. Hands on experience with Databricks and lakehouse style architectures. Working knowledge of Unity Catalog ...

join a rapidly growing practice and take your career to the next level. Responsibilities Conduct user requirements analysis and facilitate business process design and modelling workshops with client subject matter experts Identify gaps, issues and reporting risk areas as part of an implementation team Translate business processes and requirements … managerial, technical and business stakeholders Understand and manage priorities, scope, timelines, objectives and key milestones Required Skills and Experience Background in business, finance, multi-dimensional modelling, data analytics, business intelligence or consulting Strong analytical and problem-solving capabilities Proven experience with Anaplan, including model design, implementation and optimisation ...