Power BI Developer at Redpath, building and evolving reporting solutions for decision-making across regions. Collaborating with data engineers and stakeholders to define KPIs and reporting needs.
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.
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.
Senior BI Engineer building data models, semantic layers, and dashboards for Jobber’s small - business service platform. Driving governed self - service analytics and trusted business metrics.
Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.
Business intelligence consultant building Sage Intacct and Sage 300 CRE financial reports. Supporting accounting and operations teams with SQL - integrated, multi - entity reporting solutions.
Senior BI Developer designing SAP Datasphere data solutions for Aecon, an infrastructure construction company. Enabling SAP analytics, integration, governance, and secure enterprise data products.
Senior BI Analyst building Power BI dashboards and data solutions for TD, a global financial institution. Delivering actionable insights through SQL, Databricks, DAX, and Power Query.
Senior Data and BI Engineer building enterprise data lakes, pipelines, and real - time analytics platforms. Supporting utility software provider Systems & Software’s trusted customer insights and operations.
Data Analytics & BI Analyst building dashboards, models, and reporting for CoVet’s AI tools supporting veterinary professionals. Partnering across teams to improve business decisions and data quality.
Business Intelligence Analyst developing data products, dashboards and insights for the Government of Alberta. Supporting data strategy, governance and evidence - based decisions across departments.
Développeur BI chez BEEM, transformant les données d’entreprises en dashboards Power BI et solutions IA. Conception de semantic layers, SQL avancé et livraison de solutions data auprès des clients.