Working within a project-based delivery model, this role transforms evolving and curated datasets into usable Power BI semantic models, dashboards, and reports. The role plays a key part in bridging business needs and data reality - helping define, refine, and operationalize KPIs while adapting to changing data availability and quality.
The Power BI Developer collaborates closely with Data Engineers and business stakeholders across Operations, Project Controls, Engineering, Finance and HSE to deliver incremental reporting value aligned with Connected Data priorities.
Build and maintain Power BI semantic models, datasets, and dataflows, including relationships, calculations, aggregations, and row-level security.
Develop dashboards and reports aligned to prioritized use cases (e.g., productivity, earned vs burned, equipment utilization).
Own specific datasets or reporting areas, continuously improving them based on feedback and evolving requirements.
Balance speed of delivery with consistency and reusability of models and measures.
Work with business stakeholders to define, validate, and refine KPIs and measures.
Challenge inconsistencies or ambiguities in business logic and contribute to establishing aligned definitions.
Collaborate with Data Engineers to ensure reporting models align with underlying data structures and pipeline capabilities.
Deliver reporting solutions in iterative cycles, incorporating stakeholder feedback and improving usability over time.
Support UAT, demos, and working sessions to validate outputs and ensure adoption.
Adapt reporting solutions as data quality, availability, and definitions evolve.
Ensure models align with Connected Data standards for naming, structure, and KPI definitions where practical.
Validate data accuracy and consistency, working with Data Engineers to resolve issues.
Maintain documentation of datasets, key measures, and assumptions.
Support business users in understanding and using reports and datasets.
Contribute to development of self-service reporting while maintaining alignment with shared definitions.
Maintain confidentiality with respect to Redpath business and vendor information
Support other members of the Corporate IT teams as required
The duties and responsibilities listed above are representative of the nature and level of work assigned and are not necessarily all inclusive
Power BI skills, including:
DAX
Power Query (M)
Data modeling (star schema, normalization/denormalization, incremental refresh, aggregations)
Row‑level / object‑level security
Experience with Microsoft Fabric, including working with Lakehouse/Warehouse datasets created by Data Engineers.
Strong SQL skills; familiarity with Python/Spark is an asset for collaborative work with Data Engineers.
Understanding of operational, financial, and project reporting concepts (earned value, progress, utilization, cycle times).
Ability to translate business requirements into reporting solutions with strong visual design foundations.
