Design, develop, test, publish, and maintain production-ready Power BI reports, dashboards, scorecards, semantic models, and datasets supporting North American Manufacturing and Supply Chain operations
Connect to and transform governed data from the enterprise data lake, Microsoft Fabric, relational databases, ERP systems, and other approved sources using Power Query, SQL, dataflows, and supported Power BI connectivity methods
Analyze source tables, keys, data grain, cardinality, relationships, and business rules to build accurate star-schema or other fit-for-purpose data models
Create clear, reusable DAX measures and calculation logic that produce consistent business results while minimizing unnecessary model complexity
Optimize semantic models and reports for responsiveness and capacity efficiency by reducing model size, limiting high-cardinality columns, preserving query folding when available, selecting appropriate storage modes, and removing unnecessary visuals, queries, and calculations
Requirements
Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, Business Analytics, Supply Chain Management, or a related field
Lead-level Power BI specialist designing and delivering semantic models and reports with focus on performance and cost optimisation.
Responsibilities
Design, build and maintain Power BI semantic models and reports to a high technical standard
Develop robust data models in Power BI using DAX and Power Query (M)
Optimise model and report performance through aggregations, incremental refresh, composite models, query folding, relationship design and storage-mode choices
Optimise Power BI or Fabric capacity usage and cost
Connect Power BI to Databricks as a data source
Requirements
A degree in Computer Science, Information Systems, Engineering, Mathematics or a related field, or equivalent practical experience
