3. KEY RESPONSIBILITY |
- Engage stakeholders to translate business questions into measurable KPIs, metrics, and user stories document acceptance criteria and define standard aggregations per the KPI master standard.
- Design intuitive, role-based report experiences aligned to DP World visualization standards and accessibility best practices.
- Build clean, performant star-schema models and semantic layers develop measures with DAX and transformations with Power Query (M) or dataflows apply data types, formats, and hierarchies consistently
- Implement incremental refresh, composite models, and DirectQuery/Import strategies optimize with aggregations where needed.
- Develop interactive reports and dashboards in Power BI Desktop following storytelling and visual design best practices use field parameters, bookmarks, and tooltips for guided analysis.
- Standardize KPI cards, visuals, themes, and nomenclature for cross-report consistency.
- Implement Row-Level Security (RLS) and Object-Level Security (OLS) manage workspaces, datasets, and lineage in Power BI Service.
- Adhere to naming conventions, documentation standards, and data governance policies validate logic against golden sources.
- Establish data validation checks and reconcile to source-of-truth remediate data quality issues with source teams.
- Use Power BI Deployment Pipelines (Dev/Test/Prod) and ALM Toolkit for schema diff/merges integrate with version control (e.g., Git) where applicable.
- Monitor refresh reliability, model size, and performance (DAX Studio/Performance Analyzer) maintain SLAs and optimize load times.
- Create release notes, data dictionaries, and how-to guides conduct enablement sessions for business users and WeOne reporting champions.
- Track usage metrics, drive adoption, and iterate based on feedback and telemetry.
- Work with Transformation, Finance, Operations, Commercial, and IT Data Platform to prioritize backlog and deliver value in sprints.
- Identify automation opportunities (dataflows, parameters, templates) and reusable patterns to accelerate delivery.
|
| | | |
4. TECHNICAL COMPETENCIES |
Reporting & Modeling (Power Platform - Reporting) - Power BI Desktop & Service: datasets, dataflows, semantic models, RLS/OLS, deployment pipelines, workspace mgmt.
- DAX / Power Query (M): advanced measures, calculation logic, query folding, transformations.
- Data Modeling: star schema, slowly changing dimensions, hierarchies, aggregations, incremental refresh, composite models.
- Performance Tuning: DAX optimization, model size reduction, summarization tables, Performance Analyzer, DAX Studio.
- Visualization Standards: storytelling, accessibility, design patterns, corporate themes.
Data & Platform - SQL (Azure SQL/Synapse), files in Data Lake Gen2, optional: Fabric/OneLake if in scope.
- Tools: Tabular Editor, ALM Toolkit, DAX Studio optional: Power BI REST API basic Python/Excel for ad hoc.
Delivery & Governance - Agile delivery: backlog, sprint planning, user stories, acceptance criteria.
- Documentation & Data Governance: lineage, glossary, data dictionary, usage metrics.
IT Project Management - Plan and prioritize tasks to achieve milestones manage dependencies with data platform teams.
IT Innovation - Prototype new visuals, parameters, and templates evaluate Fabric features to improve performance and maintainability.
|
| | | |
| | | |
| | | |
5. FUNCTIONAL RELATIONSHIPS |
Transformation Office (WeOne), Finance, Operations, Commercial, HSE, HR Analytics, Corporate Strategy/PMO, IT Data Platform/Security, Internal Audit (as needed), and external partners/vendors. |
