streamlining manual processes into automated flows. Familiarity with pharmaceutical compliance risks or compliance considerations for stakeholder engagements is a plus. Fluency in SQL, PowerQuery, star-schemas, DAX, or similar coding languages and approaches is preferred but not required. Are you ready to 'go beyond' to create value and make More ❯
User Stories and Acceptance Criteria specification Managing agile product backlogs in scrum Process and requirements modelling Data Modelling of financial data and CUBE/StarSchema Data Analysis Reconciliation Defect triage and classification of bug prioritisation and severity Financial modelling and statutory reporting platforms Knowledge and Experience 7+ More ❯
london, south east england, united kingdom Hybrid / WFH Options
Lorien
User Stories and Acceptance Criteria specification Managing agile product backlogs in scrum Process and requirements modelling Data Modelling of financial data and CUBE/StarSchema Data Analysis Reconciliation Defect triage and classification of bug prioritisation and severity Financial modelling and statutory reporting platforms Knowledge and Experience 7+ More ❯
delivering fully reconciled Facts and Dimensions and accurate end user reports. Hands on and technical understanding of complex Data Warehousing, including Data Warehouse design; Starschema and dimensional modelling Proficient with using OAS (or similar reporting tools) and validating subject areas and reports. Experience of working with and More ❯
service principals. Enabling parallel processing in pipelines. Creating reusable templates for onboarding new datasets. Azure SQL: Securing database access via Microsoft Entra ID. Building STARschema-based data models. Establishing naming conventions and best practices. Shifting data processing from Power BI to Azure SQL. Organising data with schemas More ❯
role will focus on designing and developing both relational and dimensional data models to support robust, scalable data solutions. You’ll work extensively with STAR schemas, role-playing dimensions, and handle late-arriving data scenarios as part of building high-quality data models. In addition to modelling, the role … and dimensional data models, applying best practices in normalisation and working with complex structures like parent-child tables. You’ll leverage your understanding of STAR schemas and role-playing dimensions to support reporting and analytics needs. ETL and Metadata Management: Lead the design and optimisation of ETL processes and … understand client data needs and deliver actionable insights within a consulting framework Required Experience: Proven experience in designing relational and dimensional data models, including STAR schemas and role-playing dimensions. Strong understanding of data modelling concepts such as normalisation types, parent-child table structures, and handling of late-arriving More ❯