Role Description
The Power Platform / BI Engineer is a hands-on technical role responsible for designing, building, and maintaining high quality reporting, automation, and data solutions using the Microsoft Power Platform. This role underpins the organisation’s business intelligence and automation capabilities by developing robust, scalable workflows, structured data capture solutions, and performant reporting datasets.
The Power Platform / BI Engineer provides the technical foundation, ensuring that data flows, datasets, semantic models, automations, and platforms are reliable, secure, and engineered to best practice standards.
This role plays a crucial part in maturing GBE‑N’s digital and data capability, developing repeatable design patterns, strengthening governance, and accelerating reporting and insight delivery across the organisation.
Key Responsibilities
Power Platform & Reporting Solution Delivery - design and deliver end-to-end Power BI solutions, including optimised data models, DAX, and performance tuning. Build and operate Power Automate workflows for ingestion, validation, transformation, refresh cycles, notifications, and exception handling. Establish reusable templates and standards for reports, themes, flows, and SharePoint Online Lists to ensure consistent, scalable delivery.
Data Integration & Architecture - integrate data from Excel, SharePoint, REST APIs, SQL sources, and systems such as P6, ensuring transformations are validated and documented. Maintain clear lineage, metadata, and mapping so technical change is traceable and reproducible.
Governance, Quality & Platform Standards - apply Power Platform governance across environments, access, data classification, and solution lifecycle management. Implement CI/CD pipelines and DevOps practices for Power BI and Power Platform solutions to ensure controlled deployments and versioning.
Collaboration, Stakeholder Engagement & BI Team Delivery - work together with the Data Analyst to translate business needs into resilient technical solutions that enable accurate, meaningful reporting and automation. Participate in stakeholder conversations when needed to clarify feasibility, constraints, and design options. Document solutions clearly for handover and governance.
Continuous Improvement & Innovation - evaluate new capabilities across Power BI, Power Automate, and emerging features (e.g., Fabric aligned patterns) and recommend pragmatic adoption paths. Identify repeatable patterns to reduce delivery time, improve quality, and replace manual processes with structured automation.
Knowledge, Skills and Experience Required
Technical Proficiency:
* Strong hands-on experience in Power BI development (data modelling, DAX, optimization, incremental refresh).
* Extensive experience building Power Automate flows with robust error handling and monitoring.
* Proficiency in SharePoint Online Lists, permissions models, and structured information design.
* Strong data handling skills including SQL, data shaping, validation, and working with inconsistent, real-world datasets.
* Experience implementing CI/CD pipelines and DevOps practices for Power BI and Power Platform solutions.
* Experience consuming REST APIs (authentication, pagination, best practice patterns).
* Understanding of Power Platform governance frameworks and administrative controls.
* Familiarity with Microsoft Fabric or other pipeline/orchestration tools.
* Experience delivering solutions in fast-growing or immature data environments.
* Proven experience replacing manual Excel-based reporting
* Comfortable working without perfect data or complete spec
Sector Experience:
* Experience in energy, infrastructure, or government programs is highly desirable.
* Familiarity with nuclear program delivery, SMR technology, or regulated environments is a plus.
Qualifications
* Bachelors or Masters degree in Computer Science, Data Engineering, Information Systems, or a related field preferred.
* Professional certifications in related platforms are advantageous.
* Experience with Agile methodologies and DevOps practices is preferred.
#J-18808-Ljbffr