solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of StarSchema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯
application SQL Server database performance and SQL tuning Experience in handling large databases Knowledge of column store indexes Very good SSRS skills Data warehouse experience, design of data marts, star schemas and type 2 slowly changing dimensions Data analysis skills Desirable Skills and Knowledge: Experience with tSQLt unit testing Understands the Agile software development lifecycle and working knowledge of More ❯
user stories Building and optimising Power BI reports in line with stakeholder requirements Querying and transforming data from SQL Server and Snowflake Transforming data using PowerQuery Modelling data into STAR schemas What makes a great Grayce Analyst? Analytical Problem Solving: We're looking for analytical minds that can spot patterns and think creatively. Whether it's dissecting complex issues More ❯
user stories Building and optimising Power BI reports in line with stakeholder requirements Querying and transforming data from SQL Server and Snowflake Transforming data using PowerQuery Modelling data into STAR schemas What makes a great Grayce Analyst? Analytical Problem Solving: We're looking for analytical minds that can spot patterns and think creatively. Whether it's dissecting complex issues More ❯
extension. This role offers a hybrid working arrangement, requiring 1-2 days per week onsite at Heathrow, Hounslow, with on-site parking available. Responsibilities: Data Modelling: Design and optimize starschema data models tailored to our client's business needs for streamlined analytics and reporting. Collaboration: Work closely with data architects, BI developers, and business analysts to translate … governance practices to ensure accuracy and integrity within data models. Skills/Must have: Proven experience in data modelling using Kimball methodology, with a focus on dimensional modelling and star schemas. Strong proficiency in SQL and experience with data modelling tools like ER Studio, Power Designer, or similar. Ability to translate complex business needs into structured, efficient data models. More ❯
The role involves building strong relationships across the business to support existing systems and contribute to future upgrades and system improvements. Key Responsibilities: Design, develop, and test data warehouse (Starschema dimensional model), reporting, and dashboard solutions (SSRS/Power BI). Create, maintain, and enhance data integrations (IntApp Integrate/SSIS). Analyse database data to identify More ❯
The role involves building strong relationships across the business to support existing systems and contribute to future upgrades and system improvements. Key Responsibilities: Design, develop, and test data warehouse (Starschema dimensional model), reporting, and dashboard solutions (SSRS/Power BI). Create, maintain, and enhance data integrations (IntApp Integrate/SSIS). Analyse database data to identify More ❯
You would be responsible for designing, testing, and troubleshooting the company's data storage system before it goes live. Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts Define scope, execution plans, and coordinate test activities Ensure all sign-offs on deliverables (overall test strategy, test plan, test cases, ) and that testing meets More ❯
You would be responsible for designing, testing, and troubleshooting the company's data storage system before it goes live. Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts Define scope, execution plans, and coordinate test activities Ensure all sign-offs on deliverables (overall test strategy, test plan, test cases, ) and that testing meets More ❯
City of London, London, United Kingdom Hybrid / WFH Options
Lorien
when needed Excellent requirements, Epics, 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+ years of direct experience of More ❯
when needed Excellent requirements, Epics, 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+ years of direct experience of More ❯
cross-functional stakeholder management, and 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 your mark for patients? If More ❯
