6tasks in this job
40skills it uses
9tools named
The skills this job leans on most
- 1Monitoring data quality and freshness in productionNeeded in 3 of 6 tasks
- 2Testing changes to data services and business systems for business meaning and downstream impactNeeded in 3 of 6 tasks
- 3Recovering data pipelines safelyNeeded in 3 of 6 tasks
- 4Running incident command: severity, timeline and status updatesNeeded in 2 of 6 tasks
- 5Preparing change records with impact assessment and rollbackNeeded in 1 of 6 tasks
ToolsMicrosoft ExcelOneStreamOracle Hyperion and Oracle EPM Cloud (Planning, HFM, FCCS, EPBCS)ServiceNowMicrosoft Power BIPower QuerySAP S/4HANAOracle NetSuiteAnaplan
All 6 tasks, where people get stuck and all 40 skills
Tasks
- Diagnose a data pipeline failure and recover safely
- Apply an approved data access grant or revocation and prove its effect
- Deliver and sustain a trusted BI report or dashboard
- Monitor and correct data quality in a domain or system of record and drive remediation at source
- Consolidate entity results into group accounts and decide which entity data the group relies on
- Configure, test and release a change to a business system of record under change control
Where people get stuck
- Verifying reports and dashboards before and after release
- Building decision-focused reports and dashboards
- Specifying BI measure semantics: additivity, aggregation and time
All skills
- Monitoring data quality and freshness in production
- Preparing change records with impact assessment and rollback
- Testing changes to data services and business systems for business meaning and downstream impact
- Applying data classification and handling rules
- Assessing data source credibility and fitness for a question
- Assigning and operating data ownership and stewardship
- Building decision-focused reports and dashboards
- 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 automated pipelines and processes that fail safely and recover
- Designing role-based access entitlement models
- Designing semantic models for governed analytics
- Diagnosing data quality exceptions
- Enforcing and auditing data access
- Escalating unresolved risks with evidence and clear ownership
- Establishing and declaring data grain
- Explaining how business events flow into accounting records
- Gating releases on evidence with rollback ready
- Identifying keys and testing referential integrity
- Interpreting policy scope and delegated authority limits
- 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 and testing data control effectiveness
- Reading business metrics
- Reading data tables: rows, fields, types and units
- Recognising personal data and privacy duties
- Recognising statutory incident reporting duties and deadlines
- Reconciling conflicting reports
- Reconciling finance subledgers and close records
- Repairing data defects reversibly under owner authority
- Specifying BI measure semantics: additivity, aggregation and time
- 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
- Writing verifiable requirements and acceptance criteria
Paths to start
Coming soonData Product Reliability: Release Gates, Service Levels and IncidentsAnalytics Engineering: Tested, Version-controlled Transformation
6tasks in this job
53skills it uses
12tools named
The skills this job leans on most
- 1Verifying reports and dashboards before and after releaseNeeded in 6 of 6 tasks
- 2Testing changes to data services and business systems for business meaning and downstream impactNeeded in 4 of 6 tasks
- 3Monitoring data quality and freshness in productionNeeded in 3 of 6 tasks
- 4Building decision-focused reports and dashboardsNeeded in 3 of 6 tasks
- 5Specifying BI measure semantics: additivity, aggregation and timeNeeded in 2 of 6 tasks
ToolsPower QueryMicrosoft Power BIMicrosoft SQL Server (with SSMS)ServiceNowOracle BI Publisher and Oracle ReportsPower Automate+ 6 more
All 6 tasks, where people get stuck and all 53 skills
Tasks
- Investigate inconsistent BI reporting
- Diagnose a data pipeline failure and recover safely
- Deliver and sustain a trusted BI report or dashboard
- Automate a recurring reporting or data task with controls and a named owner
- Consolidate entity results into group accounts and decide which entity data the group relies on
- Configure, test and release a change to a business system of record under change control
Where people get stuck
- Gating releases on evidence with rollback ready
- Planning and validating controlled data migrations
- Assessing change risk, collisions and go or no-go
All skills
- Building decision-focused reports and dashboards
- Monitoring data quality and freshness in production
- Specifying BI measure semantics: additivity, aggregation and time
- Testing changes to data services and business systems for business meaning and downstream impact
- 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 efficient and reproducible investigations
- Designing role-based access entitlement models
- Designing semantic models for governed analytics
- Diagnosing data quality exceptions
- Diagnosing operational handoffs and flow
- Enforcing and auditing data access
- 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
- Interpreting policy scope and delegated authority limits
- 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 and testing data control effectiveness
- Preparing change records with impact assessment and rollback
- Reading business metrics
- Reading data tables: rows, fields, types and units
- Recognising and containing suspected personal data breaches
- Recognising personal data and privacy duties
- Recognising statutory incident reporting duties and deadlines
- Reconciling conflicting reports
- Reconciling finance subledgers and close records
- Repairing data defects reversibly under owner authority
- Running incident command: severity, timeline and status updates
- 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 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
- Writing verifiable requirements and acceptance criteria
All tools
- Power Query
- Microsoft Power BI
- Microsoft SQL Server (with SSMS)
- ServiceNow
- Oracle BI Publisher and Oracle Reports
- Power Automate
- Anaplan
- OneStream
- Oracle Hyperion and Oracle EPM Cloud (Planning, HFM, FCCS, EPBCS)
- SAP S/4HANA
- Oracle Fusion ERP and E-Business Suite
- Oracle NetSuite
Paths to start
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 soonData Product Reliability: Release Gates, Service Levels and IncidentsManaging Data and AI Products
8tasks in this job
72skills it uses
11tools named
The skills this job leans on most
- 1Gating releases on evidence with rollback readyNeeded in 5 of 8 tasks
- 2Testing changes to data services and business systems for business meaning and downstream impactNeeded in 5 of 8 tasks
- 3Planning and validating controlled data migrationsNeeded in 2 of 8 tasks
- 4Preparing change records with impact assessment and rollbackNeeded in 2 of 8 tasks
- 5Assessing change risk, collisions and go or no-goNeeded in 2 of 8 tasks
ToolsMicrosoft SQL Server (with SSMS)ServiceNowSAP S/4HANAOracle Fusion ERP and E-Business SuiteMicrosoft Power BIPower Automate+ 5 more
All 8 tasks, where people get stuck and all 72 skills
Tasks
- Diagnose a data pipeline failure and recover safely
- Prepare and verify a data-service release or migration for change approval
- Deliver and sustain a trusted BI report or dashboard
- Automate a recurring reporting or data task with controls and a named owner
- Elicit, analyse and manage requirements for a data, analytics or system change
- Consolidate entity results into group accounts and decide which entity data the group relies on
- Design data-dependent controls for a new or changed finance or people process, system or automation
- Configure, test and release a change to a business system of record under change control
Where people get stuck
All skills
- Assessing change risk, collisions and go or no-go
- Gating releases on evidence with rollback ready
- Planning and validating controlled data migrations
- Preparing change records with impact assessment and rollback
- Testing changes to data services and business systems for business meaning and downstream impact
- Applying data classification and handling rules
- Assessing data source credibility and fitness for a question
- Assessing data-service continuity and recoverability
- Assigning and operating data ownership and stewardship
- Building data protection by design into data products and pipelines
- Building decision-focused reports and dashboards
- Calculating and verifying KPIs against their specification
- Classifying AI uses against regulatory obligations
- Combining tables safely: cardinality, fan-out and conservation of totals
- Comparing periods consistently
- Coordinating accountable handoffs between teams
- Designing and appraising samples
- 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 role-based access entitlement models
- Designing semantic models for governed analytics
- Designing testable data controls
- Diagnosing data quality exceptions
- Diagnosing misleading data visualisations
- Diagnosing operational handoffs and flow
- Disclosing AI contribution to professional work
- Enforcing and auditing data access
- Escalating unresolved risks with evidence and clear ownership
- Establishing and declaring data grain
- Explaining control types, dependencies and compensating controls
- Explaining how business events flow into accounting records
- Explaining technical work to accountable non-specialists
- Facilitating evidence-led retrospectives and corrective actions
- 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
- Interpreting policy scope and delegated authority limits
- Investigating anomalies
- Investigating procurement spend leakage and duplicate commitments
- Judging the materiality of defects and deficiencies for the intended use
- Mapping proposed process changes and control impacts
- Mapping stakeholders' decisions, constraints and needs
- Monitoring and testing data control effectiveness
- Monitoring data quality and freshness in production
- Rating risks against appetite and choosing proportionate treatment
- Reading business metrics
- Reading data tables: rows, fields, types and units
- Recognising and containing suspected personal data breaches
- Recognising personal data and privacy duties
- Recognising statutory incident reporting duties and deadlines
- Reconciling conflicting reports
- Reconciling finance subledgers and close records
- Repairing data defects reversibly under owner authority
- Running incident command: severity, timeline and status updates
- Sampling and reviewing a team's work against standards
- Setting and reviewing reliability objectives and error budgets for data and AI services
- Specifying BI measure semantics: additivity, aggregation and time
- Specifying decision-useful reports
- Standardising and cleaning data under agreed rules
- Testing competing explanations with discriminating evidence
- Testing the completeness and accuracy of reports and data that controls rely on
- Tracing data lineage upstream and downstream
- Validating records by matching, recomputation and end-to-end tracing
- Verifying AI-assisted outputs against sources
- Verifying reports and dashboards before and after release
- Working through stakeholder conflict over evidence and responsibility
- Writing data quality rules
- Writing verifiable requirements and acceptance criteria
All tools
- Microsoft SQL Server (with SSMS)
- ServiceNow
- SAP S/4HANA
- Oracle Fusion ERP and E-Business Suite
- Microsoft Power BI
- Power Automate
- Power Query
- OneStream
- Oracle NetSuite
- Microsoft Excel
- Microsoft Dynamics 365 Finance and Operations
Paths to start
Coming soonData Product Reliability: Release Gates, Service Levels and IncidentsAnalytics Engineering: Tested, Version-controlled TransformationData Platform Architecture, Integration and Economics
About the role
Accountable for configuring, supporting and reporting from finance systems such as the ERP and planning and consolidation tools. Decides how system rules, mappings and reports are built within agreed design and change control. Data judgement sits in keeping finance data correct as it moves between systems, where an FP&A Analyst builds forecasts and a Management Accountant owns the actuals.
Also called Finance Systems Accountant, ERP Analyst (finance)