Power BI Developer

Role Overview

• 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.

Requirements

• 2–5+ years of experience developing Power BI dashboards and semantic models.
• Strong experience with DAX, Power Query (M), and data modeling (star schema, relationships, aggregations).
• Experience working with evolving or imperfect datasets in a delivery-focused environment is an asset.
• Understanding of operational and financial reporting concepts (e.g., earned value, utilization, progress) preferred.
• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Engineering, Business Intelligence, or related field.
• Equivalent experience considered.

Benefits

• Overtime may be required to meet project deadlines
• International travel as required for the purpose of meeting with clients, stakeholders, or off-site personnel/ management.