Senior Software Engineer - Power BI

Job description:

We are looking for a Senior Power BI Developer with 3 to 5 years of experience to own the full analytics delivery lifecycle across our business units. Working directly with the Senior Specialist, Data Management, you will lead requirement gathering, prototype and iterate on dashboards, and drive solutions from concept through to production deployment and user adoption. This role sits at the intersection of business analysis and technical development, requiring someone who can translate complex operational data into clear, actionable insights for stakeholders at every level.

Key Responsibilities:

• Requirement Gathering
• Document end-to-end Business Requirements Documents (BRD) as a formal output of each requirement gathering session, ensuring full traceability from stakeholder needs to delivered solution.
• Data Modelling & DAX
• Design and build robust semantic models in Power BI Desktop, including star/snowflake schemas, calculated columns, and measures.
• Author advanced DAX expressions for time-intelligence, dynamic filtering, variance analysis, and complex aggregations.
• Optimise model performance via query folding, aggregations, and incremental refresh strategies.
• Data Transformation
• Build and maintain clean, reusable Power Query (M) transformations to shape raw data from multiple sources including SQL databases, Dataverse, SharePoint, and flat files.
• Apply data quality rules and transformation logic that align with the Data Management team's governance standards.
• Stakeholder Management & Training
• Translate field and business requirements from Sales and Operations teams into functional, intuitive reporting features.
• Conduct user training sessions and produce concise documentation to drive self-service adoption across the organisation.
• Communicate technical constraints and design trade-offs clearly to non-technical audiences.

Requirements:

• Technical Skills Required
• Power BI Desktop & Service: Expert-level report and dashboard development; workspace management, deployment pipelines, and gateway configuration.
• DAX: Mastery of DAX including time-intelligence functions, CALCULATE, FILTER, iterators, and performance-aware measure design.
• Data Modelling: Proven ability to design normalised semantic models; understanding of cardinality, relationships, and aggregation patterns.
• SQL: Proficiency in writing optimised SQL queries for report data extraction from relational databases (SQL Server, Azure SQL, or equivalent).
• Row-Level Security: Experience configuring static and dynamic RLS roles within Power BI Service for multi-group access control.

Preferred / Nice to Have:

• Familiarity with Azure Databricks, Azure Data Factory, or Fabric for upstream data pipeline work: Azure Data Services
• Exposure to embedding reports in external applications via the Power BI REST API or Embedded Analytics: Power BI Embedded
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Soft Skills:

• Ability to manage multiple projects, self-prioritise, and proactively flag blockers: Ownership
• Ability to deconstruct complex business processes and identify the metrics that matter most to operational and strategic decisions: Analytical Thinking
• Strong ability to facilitate requirement gathering sessions and explain data logic to non-technical stakeholders in Sales and Operations: Communication
• Comfortable working in feedback loops, designing for change from the prototype stage through to post-launch refinements: Iterative Mindset

Skills

Azure SQL, DAX, Power BI, Power BI Desktop, SQL, SQL Server