Power BI Developer Level 1
Confirmed on the employer's own hiring board on Oct 25, 2026. First seen by Alion on Sep 19, 2026. Cloudstaff scores B on the Alion truth index.
Position Overview
The Power BI Developer Level 1 is responsible fordeveloping, publishing, and maintainingthe reporting assets that business leaders and operational teams rely on to run the business day to day. The role covers the full reporting lifecycle, from gathering requirements and interrogating source systems, through to data modelling, dashboard build, and ongoing maintenance of published reports.
This is a hands-on delivery role, but it is not purely a build role. The right person is comfortable questioning the data in front of them, spotting when numbers do not reconcile, and explaining what a result actually means to a stakeholder who does not work with data every day.The reporting produced in this role is used by senior stakeholders to make decisions, so accuracy, clarity, and reliable turnaround matter as much as technical skill.
Key Responsibilities
Report and Dashboard Development
Design, develop, publish, and schedule Power BI reports and dashboards against agreed business requirements.
Build and maintaindata models that are structured, documented, and performant, applying appropriate relationships, hierarchies, and row-level security where required.
Write and optimiseDAX measures and calculation logic, and maintainconsistency with team standards for naming, formatting, and visual design.
Monitor refresh performance and report usage, andremediate failures or slow-running datasets.
Data Preparation and Analysis
Write, test, and optimiseSQL queries to extract and transform data from source systems and warehouses.
Use Python for data cleaning, reconciliation, and automation tasks where Power Query or SQL is not the right tool.
Build and maintainsupporting Excel models and working files, including formula-driven workbooks used for validation and ad hoc analysis.
Validate outputs before release, reconciling against source systems and flagging data quality issues to the relevant owner.
Automation and Process Support
Build and maintainPower Automate flows supporting recurring reporting, data movement, alerting, and approvalworkflows.
Identifymanual reporting steps that can be automated and propose practical improvements.
Stakeholder Engagement
Work directly with business stakeholders to gather requirements, clarify definitions, and translate business questions into technical specifications.
Present and walk through completed reports, providing enough context that users can interpret the output on their own.
Document datasets, measures, and business logicso reports remainsupportable when the developer is unavailable.
Respond to ad hoc data requests within agreed turnaround times.
Qualifications
Qualifications and Experience
Approximately 5 years of combined experience in data analysis, reporting, or business intelligence roles, of which at least 2 to 3 years must be hands-on Power BI development.
Demonstrated data acumen: able to interrogate a dataset independently, identifyanomalies, understand how source system behaviouraffects the numbers, and reach a defensible conclusion rather than simply reproducing a visual.
Strong working proficiencyin Power BI, including Power Query, DAX, data modelling, and publishing to the service.
Solid SQL capability, including joins, aggregations, window functions, and query optimisation.
Working knowledge of Python for data manipulation and automation.
Advanced Excel, including complex formulas, pivot-based analysis, and structured workbook design.
Practical experience building Power Automate flows in a production environment.
Clear written and verbal communication, with the ability to explain technical detail simply to non-technical stakeholders.
Tertiary qualification in business, data or computer science, statistics, information systems, or a related field preferred.
Advantageous Skills and Experience
The following are not entry requirements, but will be viewed favourablyand may influence placement within the level:
Exposure to other data visualisationplatforms such as Tableau, Grafana, or Superset, indicatingadaptability across BI tooling rather than dependence on a single product.
Practical use of AI-assisted development tools such as GitHub Copilot or Claude Code in day-to-day delivery work, and an interest in applying them to improve turnaround and code quality.
Experience in a fast-paced, multi-site, or distributed organisation.
Familiarity with data governance concepts such as lineage, access control, and data quality management.
Relevant Microsoft certifications, for examplePL-300.
Perks and benefits
-