We are looking for a Mid-Level Power BI / Azure Fabric Developer with a strong emphasis on data modelling and semantic model development, rather than visual design. The primary focus of this role is to build and optimise Power BI datasets that support self-service analytics in both Power BI and Excel. This includes integrating data from multiple sources, applying best practices in model design, and ensuring performance, accuracy, and usability for business stakeholders.

This role is ideal for a technically skilled Power BI developer who enjoys working behind the scenes to structure and optimise data models that drive high-quality analytics solutions.

Key Responsibilities

• Develop and maintain semantic models (Power BI datasets) that enable streamlined, business-friendly analysis
• Apply best practices in data modelling using star/snowflake schema and appropriate aggregation techniques
• Write advanced DAX measures, calculated columns, and time intelligence calculations
• Integrate data from diverse cloud-based sources including AWS Aurora Postgres and AWS Redshift using Power Query (M)
• Collaborate with business users and report developers to gather requirements and design fit-for-purpose datasets
• Ensure accuracy and consistency of data within models, along with optimisation for performance and usability
• Participate in code reviews and help define modelling standards and governance across the Power BI ecosystem
• Support Excel users by designing datasets that are easily consumed in PivotTables connected to Power BI models
• Use version control (e.g., Git) and deployment pipelines to manage releases and updates

Required Skills and Experience

• Minimum 3 years of hands-on Power BI development experience focused on semantic modelling
• Proficient in DAX and Power Query (M)
• Solid understanding of star/snowflake schema design and data warehouse principles
• Demonstrated ability to develop Excel-friendly datasets via Power BI
• Experience integrating cloud-based data sources, especially AWS Aurora Postgres and AWS Redshift
• Familiarity with Power BI deployment pipelines and source control tools like Git
• Skilled in performance tuning and model optimisation strategies (e.g., reducing query load, managing relationships, aggregations)
• Strong analytical thinking, problem-solving, and communication skills
• Comfortable collaborating in cross-functional teams and translating business requirements into data models

Desirable / Nice to Have

• Experience in financial or accounting-related data modelling
• Understanding of semantic modelling practices for regulated or sensitive data domains
• Exposure to Azure Fabric tools within the Microsoft analytics stack