The Power BI Developer is a core member of the Connected Data team, responsible for building and evolving reporting solutions that enable consistent, trusted decision-making across regions.

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.

Duties and Responsibilities:

• 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

Education:

• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Engineering, Business Intelligence, or related field.
• Equivalent experience considered.

Experience:

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

Technical Skills:

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

Competencies:

• High attention to detail and quality.
• Strong analytical, communication, and stakeholder engagement skills.
• Comfortable working in ambiguous, evolving environments with shifting priorities.
• Strong ownership mindset and willingness to engage with both technical and business challenges.
• Ability to work in fast‑moving environments with multiple priorities.
• Commitment to health, safety, and continuous learning.

Additional Information:

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