BI Developer
Accountable for building, verifying and sustaining trusted BI reports and the semantic models behind them.
2tasks in this job
19skills it uses
6tools named
The skills this job leans on most
- 1Verifying reports and dashboards before and after releaseNeeded in 2 of 2 tasks
- 2Specifying BI measure semantics: additivity, aggregation and timeNeeded in 2 of 2 tasks
- 3Building decision-focused reports and dashboardsNeeded in 1 of 2 tasks
ToolsMicrosoft Power BIMicrosoft ExcelSQL (query language)TableauQlik SenseAzure DevOpsPower AutomatePower QuerySQL Server Analysis Services (SSAS)
All 2 tasks, where people get stuck and all 19 skills
Tasks
Where people get stuck
- Designing relational schemas: keys, constraints and normalisation
- Designing dimensional models with explicit grain
- Engineering production data transformations
All skills
- Building decision-focused reports and dashboards
- Specifying BI measure semantics: additivity, aggregation and time
- Assigning and operating data ownership and stewardship
- Comparing periods consistently
- Designing automated pipelines and processes that fail safely and recover
- Designing semantic models for governed analytics
- Explaining how business events flow into accounting records
- Gating releases on evidence with rollback ready
- Identifying keys and testing referential integrity
- Mapping stakeholders' decisions, constraints and needs
- Monitoring data quality and freshness in production
- Reading business metrics
- Reading data tables: rows, fields, types and units
- Reconciling conflicting reports
- Specifying decision-useful reports
- Standardising and cleaning data under agreed rules
- Tracing data lineage upstream and downstream
- Validating records by matching, recomputation and end-to-end tracing
- Writing data quality rules
Paths to start
Tool Path
SQL for Analysis
Answer real business questions with SQL, from your first query to finding why a number moved.
- Modules
- 5 open
- Runs in
- Your browser
Tool Path
Excel for Analysis and Decision Models
Build and check Excel workbooks others can trust.
- Modules
- 5 open
- Runs in
- Your browser
Skill Path
Data Visualisation and Dashboard Design
Design honest, accessible charts and decision-useful dashboards and verify them before release.
- Modules
- 5 open
- Practice data
- Raket Parts
5tasks in this job
45skills it uses
9tools named
The skills this job leans on most
- 1Verifying reports and dashboards before and after releaseNeeded in 5 of 5 tasks
- 2Designing dimensional models with explicit grainNeeded in 5 of 5 tasks
- 3Specifying BI measure semantics: additivity, aggregation and timeNeeded in 4 of 5 tasks
- 4Building decision-focused reports and dashboardsNeeded in 3 of 5 tasks
- 5Designing relational schemas: keys, constraints and normalisationNeeded in 3 of 5 tasks
ToolsMicrosoft Power BIMicrosoft ExcelSQL (query language)TableauQlik SenseAzure DevOps+ 3 more
All 5 tasks, where people get stuck and all 45 skills
Tasks
- Define and govern a KPI metric contract
- Investigate inconsistent BI reporting
- Deliver and sustain a trusted BI report or dashboard
- Automate a recurring reporting or data task with controls and a named owner
- Design and build a tested, governed analytical data model
Where people get stuck
All skills
- Building decision-focused reports and dashboards
- Designing dimensional models with explicit grain
- Specifying BI measure semantics: additivity, aggregation and time
- Assessing data source credibility and fitness for a question
- Assigning and operating data ownership and stewardship
- Building data protection by design into data products and pipelines
- Calculating and verifying KPIs against their specification
- Combining tables safely: cardinality, fan-out and conservation of totals
- Comparing periods consistently
- Designing and validating digital analytics event measurement
- Designing and versioning data contracts for consumers
- Designing automated pipelines and processes that fail safely and recover
- Designing efficient and reproducible investigations
- Designing semantic models for governed analytics
- Diagnosing data quality exceptions
- Diagnosing operational handoffs and flow
- Engineering production data transformations
- Escalating unresolved risks with evidence and clear ownership
- Establishing and declaring data grain
- Explaining how business events flow into accounting records
- Facilitating evidence-led retrospectives and corrective actions
- Gating releases on evidence with rollback ready
- Governing shared data definitions
- Identifying keys and testing referential integrity
- Influencing change without formal authority
- Investigating anomalies
- Investigating procurement spend leakage and duplicate commitments
- Judging the materiality of defects and deficiencies for the intended use
- Mapping stakeholders' decisions, constraints and needs
- Monitoring data quality and freshness in production
- Reading business metrics
- Reading data tables: rows, fields, types and units
- Recognising statutory incident reporting duties and deadlines
- Reconciling conflicting reports
- Reconciling finance subledgers and close records
- Repairing data defects reversibly under owner authority
- Setting and reviewing reliability objectives and error budgets for data and AI services
- Specifying decision-useful reports
- Standardising and cleaning data under agreed rules
- Testing changes to data services and business systems for business meaning and downstream impact
- Testing competing explanations with discriminating evidence
- Tracing data lineage upstream and downstream
- Validating records by matching, recomputation and end-to-end tracing
- Working through stakeholder conflict over evidence and responsibility
- Writing data quality rules
Paths to start
Tool Path
SQL for Analysis
Answer real business questions with SQL, from your first query to finding why a number moved.
- Modules
- 5 open
- Runs in
- Your browser
Tool Path
Excel for Analysis and Decision Models
Build and check Excel workbooks others can trust.
- Modules
- 5 open
- Runs in
- Your browser
Skill Path
Data Visualisation and Dashboard Design
Design honest, accessible charts and decision-useful dashboards and verify them before release.
- Modules
- 5 open
- Practice data
- Raket Parts
Coming soonAnalytics Engineering: Tested, Version-controlled Transformation
6tasks in this job
55skills it uses
10tools named
The skills this job leans on most
- 1Verifying reports and dashboards before and after releaseNeeded in 5 of 6 tasks
- 2Reconciling conflicting reportsNeeded in 4 of 6 tasks
- 3Specifying BI measure semantics: additivity, aggregation and timeNeeded in 4 of 6 tasks
- 4Building decision-focused reports and dashboardsNeeded in 3 of 6 tasks
- 5Diagnosing incorrect query and calculation resultsCore to this role
ToolsMicrosoft Power BIMicrosoft SharePointSQL (query language)Microsoft ExcelMicrosoft PurviewTableau+ 4 more
All 6 tasks, where people get stuck and all 55 skills
Tasks
- Define and govern a KPI metric contract
- Investigate inconsistent BI reporting
- Deliver and sustain a trusted BI report or dashboard
- Automate a recurring reporting or data task with controls and a named owner
- Design and build a tested, governed analytical data model
- Set and maintain working standards for a team's analytical, reporting and modelling work products
Where people get stuck
All skills
- Building decision-focused reports and dashboards
- Reconciling conflicting reports
- Specifying BI measure semantics: additivity, aggregation and time
- Verifying reports and dashboards before and after release
- Applying data classification and handling rules
- Assessing data source credibility and fitness for a question
- Assigning and operating data ownership and stewardship
- Building data protection by design into data products and pipelines
- Calculating and verifying KPIs against their specification
- Combining tables safely: cardinality, fan-out and conservation of totals
- Comparing periods consistently
- Designing and validating digital analytics event measurement
- Designing and versioning data contracts for consumers
- Designing automated pipelines and processes that fail safely and recover
- Designing dimensional models with explicit grain
- Designing efficient and reproducible investigations
- Designing semantic models for governed analytics
- Diagnosing data quality exceptions
- Diagnosing misleading data visualisations
- Diagnosing operational handoffs and flow
- Disclosing AI contribution to professional work
- Engineering production data transformations
- Escalating unresolved risks with evidence and clear ownership
- Establishing and declaring data grain
- Explaining how business events flow into accounting records
- Facilitating evidence-led retrospectives and corrective actions
- Gating releases on evidence with rollback ready
- Giving specific developmental feedback on data and AI work
- Governing shared data definitions
- Identifying keys and testing referential integrity
- Independently checking analytical conclusions and claims
- Influencing change without formal authority
- Investigating anomalies
- Investigating procurement spend leakage and duplicate commitments
- Judging the materiality of defects and deficiencies for the intended use
- Mapping stakeholders' decisions, constraints and needs
- Monitoring data quality and freshness in production
- Reading and tracing unfamiliar code
- Reading business metrics
- Reading data tables: rows, fields, types and units
- Recognising statutory incident reporting duties and deadlines
- Reconciling finance subledgers and close records
- Repairing data defects reversibly under owner authority
- Reviewing human- and AI-generated code changes for correctness and risk
- Sampling and reviewing a team's work against standards
- Setting and reviewing reliability objectives and error budgets for data and AI services
- Specifying decision-useful reports
- Standardising and cleaning data under agreed rules
- Testing changes to data services and business systems for business meaning and downstream impact
- Testing competing explanations with discriminating evidence
- Tracing data lineage upstream and downstream
- Validating records by matching, recomputation and end-to-end tracing
- Verifying AI-assisted outputs against sources
- Working through stakeholder conflict over evidence and responsibility
- Writing data quality rules
All tools
- Microsoft Power BI
- Microsoft SharePoint
- SQL (query language)
- Microsoft Excel
- Microsoft Purview
- Tableau
- Git / GitHub
- Power Automate
- SQL Server Analysis Services (SSAS)
- Power Query
Paths to start
Tool Path
SQL for Analysis
Answer real business questions with SQL, from your first query to finding why a number moved.
- Modules
- 5 open
- Runs in
- Your browser
Tool Path
Excel for Analysis and Decision Models
Build and check Excel workbooks others can trust.
- Modules
- 5 open
- Runs in
- Your browser
Skill Path
Data Visualisation and Dashboard Design
Design honest, accessible charts and decision-useful dashboards and verify them before release.
- Modules
- 5 open
- Practice data
- Raket Parts
Coming soonAnalytics Engineering: Tested, Version-controlled Transformation
About the role
Accountable for building, verifying and sustaining trusted BI reports and the semantic models behind them. Decides report design, model structure in the BI tool and when a release is correct enough to publish. Delivers a maintained reporting product, where a Data Analyst delivers a finding for one decision.
Also called Power BI Developer, Business Intelligence Developer