20 of 20 Dimensional Modelling Jobs in the South East

built on robust, scalable information models that align with enterprise architecture, governance standards and domain ownership principles. You’ll also provide guidance on modelling best practices, data standards and business terminology, helping establish a consistent and trusted data foundation that supports both operational decision‐making and strategic insight. What … Data Engineers to validate models against ingestion pipelines and sample data Providing high‐quality model documentation to support downstream development and analytics Maintaining data modelling standards and best practices across squads Applying change management principles to ensure consistency and traceability of model changes Supporting governance and metadata management using ...

built on robust, scalable information models that align with enterprise architecture, governance standards and domain ownership principles. You’ll also provide guidance on modelling best practices, data standards and business terminology, helping establish a consistent and trusted data foundation that supports both operational decision-making and strategic insight.**What … Data Engineers to validate models against ingestion pipelines and sample data* Providing high‐quality model documentation to support downstream development and analytics* Maintaining data modelling standards and best practices across squads* Applying change management principles to ensure consistency and traceability of model changes* Supporting governance and metadata management using ...

processes. This creates an excellent opportunity for a Senior Data Architect to make a lasting impact. The Role You will lead the data modelling and architecture strategy across a modern Azure Data Lakehouse environment, ensuring scalable and governed data solutions that support both current reporting and future analytical … cases. Key responsibilities include: Designing and governing enterprise-wide data models across Medallion Architecture layers. Creating curated semantic and analytical data models using dimensional modelling and Kimball methodologies. Defining data modelling standards, governance frameworks, and data feed specifications. Collaborating with Data Engineers, Analytics Engineers, and business stakeholders ...

skills, including experience with T-SQL and DAX Experience designing and developing ETL and ELT data pipelines A solid understanding of data warehousing, data modelling, dimensional modelling and data architecture Strong analytical and problem-solving skills Experience gathering, analysing and refining requirements with business stakeholders The ability ...

data within a large, complex organisation that is investing heavily in its analytics and data capabilities. You will take ownership of enterprise data modelling and architecture, helping to transform how data is structured, governed, and consumed across the business. ROLES AND RESPONSIBILITIES: The Senior Data Architect will: Design … govern enterprise-wide data models across bronze, silver and gold layers within a Medallion Architecture. Create scalable curated data models using dimensional modelling, star schemas, facts and dimensions, and Kimball methodologies. Define semantic data layers, modelling standards, and governance frameworks to improve consistency, quality, and reusability. Manage ...

fantastic opportunity to join a major organisation undergoing a significant Azure Data Lakehouse transformation. You'll take ownership of enterprise-wide data modelling and architecture, helping the business evolve from traditional reporting towards advanced analytics and data-driven decision making. THE COMPANY: This well-established UK professional services organisation … include: Designing and governing enterprise-wide data models across Bronze, Silver and Gold layers within a Medallion Architecture. Creating scalable curated data models using dimensional modelling and Kimball methodologies. Defining semantic data layers, standards and governance practices that ensure consistency, quality and efficiency across the data platform. Managing ...

scalability and end-user experience. Apply data security controls and reporting governance best practices. Support testing, deployment and ongoing optimisation of reporting products. Data Modelling & Analytics Design robust dimensional models to enable accurate and consistent reporting. Build and maintain fact and dimension structures aligned to business needs. Work … training, adoption and knowledge sharing. Required Experience We're interested in candidates who can demonstrate strong commercial experience across business intelligence, reporting and data modelling disciplines. Technical Requirements Proven expertise delivering Power BI solutions in enterprise environments. Advanced DAX development experience. Strong SQL querying and performance optimisation skills. Experience ...

leadership experience working with a modern cloud data platform (must have some direct Snowflake exposure to be able to hit the ground running) Dbt modelling experience, or the demonstrable capability and willingness to own that learning quickly, alongside a commitment to continuous professional development Advanced SQL, including complex transformation … logic, data modelling and query performance optimisation Strong dimensional modelling knowledge: facts, dimensions, conformed dimensions and slowly changing dimensions Hands-on engineering credibility, with the judgement to know when to build, when to simplify, and when to stop Proven people leadership: setting direction, giving feedback, and developing ...

large-scale Azure data transformation programme. You'll play a key role in shaping a modern Data Lakehouse environment, driving best practice in data modelling, governance, and analytics while working closely with senior stakeholders across the business. The Company This organisation is a well-established UK professional services business … focused on improving data visibility, strengthening governance, and enabling more advanced analytics across the business. The Role You will lead data architecture and modelling across a modern cloud platform, ensuring data is structured, governed, and accessible for reporting and analytics.Responsibilities include: Designing enterprise-wide data models within a Medallion ...

enabled analytics, Copilot and natural language reporting capabilities. Desirable Exposure to Microsoft Fabric including Lakehouses, Warehouses, Dataflows Gen2 and Semantic Models. Experience designing dimensional models and star schemas to support reporting and analytics solutions. Azure data services, Databricks or cloud-based analytics platforms. Agile delivery environments. Data dictionaries, report ...

leadership experience working with a modern cloud data platform (must have some direct Snowflake exposure to be able to hit the ground running) Dbt modelling experience, or the demonstrable capability and willingness to own that learning quickly, alongside a commitment to continuous professional development Advanced SQL, including complex transformation … logic, data modelling and query performance optimisation Strong dimensional modelling knowledge: facts, dimensions, conformed dimensions and slowly changing dimensions Hands-on engineering credibility, with the judgement to know when to build, when to simplify, and when to stop Proven people leadership: setting direction, giving feedback, and developing ...

cloud-based data platforms. Advanced SQL skills and experience building transformation pipelines. Strong Python capability for orchestration, automation, and data tooling. Excellent understanding of dimensional modelling and scalable data architecture. Experience working with cloud technologies such as Azure, AWS, or GCP. Knowledge of CI/CD practices ...

transformation processes. Key Responsibilities Analyse existing datasets and data structures to help prioritise, design and implement the enterprise data platform. Design and implement dimensional data models within Snowflake to support enterprise reporting and analytics. Build and maintain production-grade data transformation workflows using robust development, testing, version control … client data. Contribute to data engineering standards, naming conventions, development practices and CI/CD processes. Support data analysis, data architecture and enterprise data modelling activities across existing and new data platforms. Work closely with technical and business stakeholders to understand requirements and translate them into effective data solutions. ...

. Extensive SQL development and performance tuning expertise. Experience building and supporting ETL/ELT frameworks. Strong understanding of data warehousing concepts and dimensional modelling. AWS experience, including services such as S3, Glue, EMR, or PySpark . Knowledge of data governance, quality controls, and testing practices. Experience working within ...

writing complex queries and stored procedures Hands-on experience with Power BI, Tableau or a similar BI platform Experience building data models (star schema, dimensional modelling) - desirable Familiarity with ETL tools and processes Experience with Azure Data Factory, SSIS or similar - desirable Strong stakeholder management and communication skills ...

integration technologies. MySQL database administration. Structured and semi‐structured data formats. Network infrastructure and system dependencies affecting database services. Data warehousing, ETL processes and dimensional modelling. Experience supporting and maintaining SSRS and SSIS solutions. Why join Castle Trust Bank? Competitive salary Performance bonus (based on individual and company performance ...

Integration solutions.Strong programming experience with VB.NET.Advanced SQL development and database skills.Experience developing and supporting integrations between OneStream and enterprise applications.Experience working with OneStream metadata, dimensional modeling, security, and application administration concepts.Solid understanding of financial close, consolidation, planning, forecasting, account reconciliations, and management reporting processes.Experience troubleshooting, optimizing, and supporting enterprise ...

rule definition, thresholding, automated alerting, and root-cause remediation). Craft complex SQL transformations, optimize query performance, handle advanced window functions, and design conformed dimensional models for curated platform layers. Map end-to-end data flows from ingestion to serving, defining upstream/downstream contracts and data ownership boundaries. ...

leading or mentoring Business Analysts within a project environment Experience working on Finance Reporting, Finance Transformation or Finance Systems programmes Strong understanding of data modelling, reporting and analytics solutions Ability to bring structure and governance to a fast-moving agile delivery environment Essential Domain Experience Candidates must be able … these finance reporting workstreams: Case Margin Reporting Working Capital Reporting Revenue Recognition Reporting Margin, Profitability or Sold vs Actual Analysis Global Finance Reporting and Dimensional Models Investment Reporting, Insights or Analytics Applicants who can demonstrate multiple examples across these areas will be particularly well suited to the programme. Highly ...

performance Lead flow and operational KPIs SLA monitoring and business performance Compliance and regulatory reporting Marketing and campaign effectiveness Cost-to-outcome analysis Data Modelling & SQL Analysis Work with integrated, mastered datasets from multiple systems. Develop dimensional models that support self-service reporting. Use SQL to validate, interrogate … including: LOD Expressions Complex calculations Performance optimisation Permissions and security models Strong SQL skills and experience working with complex enterprise data environments. Experience designing dimensional data models and reporting layers. Proven ability to gather requirements and deliver business-facing dashboards. Excellent stakeholder management and workshop facilitation skills. Desirable Experience ...