8 of 8 Star Schema Jobs in the North of England

Server, Azure SQL Database and T-SQL. Experience with ETL/ELT and data integration tools, ideally Informatica. Strong understanding of dimensional modelling, including Star Schema. Experience optimising BI models, queries and reporting performance. Understanding of Power BI Service administration and governance. Experience working in an agile environment, ideally ...

data from APIs, databases, CRM, ERP and third party platforms • Support both batch and real time data processing • Develop semantic models and work with Star Schema and Kimball modelling • Implement CI/CD and automated deployment of data solutions • Build monitoring, data quality, lineage and observability into data ...

strong hands-on experience with PySpark. Proven experience working with Databricks and Lakehouse architectures. Strong understanding of dimensional modelling, including fact tables, dimension tables, star schemas and semantic layers. Experience developing curated, analytics-ready datasets for business intelligence and analytics consumption. Ability to translate complex business requirements into well ...

following skills, knowledge and experienceStrong SQL skills and experience building analytical data models in a production environmentData modelling approaches such as dimensional modelling, star schemas, metric layers or similarWorking with dbt or similar transformation and orchestration toolsBuilding semantic models or reusable business logic for BI, analytics or self-service ...

criteria: Essential CriteriaQualifications/ExperienceEducated to degree level (or equivalent experience).Professional practitioner with specialist knowledge of dimensional/semantic data modelling (for example star schemas, complex relationships and calculation logic), whether within BI tools such as Power BI or on data warehouse or modern data platform services, with ...

requirements and deliver practical solutions. Ensure data quality and consistency across reporting pipelines. What We’re Looking For Power BI Expertise: Advanced data modelling (STAR schema, relationships, filter direction). Strong DAX skills for measures and calculations. Experience optimizing performance for large datasets. Excel Mastery: Advanced formulas (SUMIFS ...

requirements and deliver practical solutions. Ensure data quality and consistency across reporting pipelines. What We’re Looking For Power BI Expertise: Advanced data modelling (STAR schema, relationships, filter direction). Strong DAX skills for measures and calculations. Experience optimizing performance for large datasets. Excel Mastery: Advanced formulas (SUMIFS ...

Performance tuning and query optimisationPythonAWS cloud databases such as Aurora and DynamoDBUnderstanding of different database designs, such as relational, NoSQL, ledger and data warehouse star schemasGDPR and information security awarenessExperience within Insurance, Claims, Fraud or Financial Services#LI-HybridResponsibilitiesDevelop database code, including stored procedures, functions and schema changesInvestigate production ...