5 of 5 Remote/Hybrid Dimensional Modelling Jobs in the West Midlands

data transformation, reconciliation, profiling and analysis across OLTP and analytical data platforms. Design data models for operational and analytical use cases, including dimensional modelling, slowly changing dimensions, lakehouse and data-lake patterns. Work with platforms such as Snowflake and relational databases including DB2 and PostgreSQL, applying sound principles … experience writing testable and maintainable code. Strong SQL proficiency and practical understanding of OLTP databases, relational design and query performance. Strong understanding of data modelling, data warehousing, dimensional modelling and slowly changing dimensions. Experience designing and implementing ETL/ELT pipelines and working with data‐lake, lakehouse ...

deployment, optimisation and support. Key duties: Business Intelligence & Reporting Design, develop and maintain enterprise Power BI solutions Design and maintain scalable data models using dimensional modelling and star schema best practices Create intuitive dashboards, reports and visualisations that enable data-driven decision making. Develop and maintain semantic models … including: DAX Power Query Semantic Models Row Level Security (RLS) Workspace and deployment management Extensive SQL Server development experience Experience designing and implementing dimensional models Experience gathering requirements and producing technical documentation Experience working directly with business stakeholders and clients Experience troubleshooting and performance tuning reporting and database solutions ...

Databricks Structured Streaming and Azure Stream Analytics Developing and maintaining modern data platforms, including Delta Lake/Lakehouse architectures on ADLS Gen2, curated datasets, dimensional models and Azure Synapse Dedicated SQL Pools Analysing current business practices, processes and procedures, identifying opportunities to leverage Microsoft Azure Data & Analytics Services ...

Airflow. Advanced Python and SQL skills with a strong software engineering mindset. Proven experience building complex, scalable batch and event-driven pipelines. Strong data modelling experience, including dimensional modelling, Data Vault or equivalent. Experience with Dataform or similar SQL-based transformation tooling. Understanding of CI/ ...

role offers stakeholder engagement, mentoring of junior developers and end-to-end BI lifecycle exposure. You will build enterprise Power BI reporting platforms, develop dimensional models, DAX calculations and performance optimisations, while guiding best practices and governance across projects. #J-18808-Ljbffr ...