Job Description

WHO ARE WE?

We've been serving Canadian clients for over 75 years. The companies that began independently and now form Dexterra Group have an outstanding record of supporting the infrastructure and built assets that play a vital role in our society and helping our clients achieve higher performance and productivity. Powered by passionate people, we bring the right teams with the right skills together – offering both experience and regional expertise so companies can operate their day to day, confidently and successfully.

WHAT'S THE JOB?

Reporting to the Manager, Solutions Innovation, the Developer, Analytics & Reporting plays a central role in advancing data-driven decision‑making across the organization. This position is responsible for developing high‑quality Power BI dashboards, building Python-based data preparation and automation workflows, and supporting the creation of reliable, scalable reporting assets used by operational teams and business leaders. This role will also support Field System Management: cleaning, preparing, updating workflows, and uploading bulk operational data for new contracts and ensuring field‑system data feeds flow correctly into reporting pipelines.

Working within the Solutions Innovation function, you will collaborate closely with business units, operational teams, and iLab team members to understand reporting needs, translate them into actionable technical solutions, and ensure analytics products are accurate, timely, and easy to use. You will help streamline the flow of data from external sources, improve the visibility of operational performance, and contribute to the organization’s focus on efficiency, transparency, and continuous improvement.

This role requires strong analytical thinking, attention to detail, and the ability to work both independently and collaboratively. You will play an important part in building repeatable reporting capabilities, supporting strategic initiatives, and enhancing the overall impact of the Solutions Innovation team.

Build and Maintain Power BI Dashboards

• Develop high-quality, user‑friendly dashboards and reports that support operational and strategic decision‑making
• Translate raw external data feeds into structured, governed Power BI datasets
• Optimize data models, DAX measures, and Power Query transformations for performance and accuracy
• Implement Row-Level Security and follow internal governance practices for secure data sharing

Develop Python-Based Data Pipelines & Automation

• Create Python scripts to ingest, clean, and transform data from varied external systems (APIs, SaaS tools, flat files, SFTP, partner feeds)
• Automate recurring data refreshes and validation processes
• Build lightweight utility scripts to support teams (e.g., preprocessing, reconciliation, data quality checks)

Field System Management

• Clean, standardize, and bulk‑upload operational data (e.g., asset lists, PM schedules) during new contract onboarding
• Manage recurring data flows from field systems into reporting environments
• Perform validation, formatting checks, and reconciliations to ensure data completeness and accuracy
• Troubleshoot data‑level issues that impact reporting

Strengthen Data Quality and Reliability

• Perform validation, anomaly detection, and reconciliation for incoming datasets
• Document data sources, assumptions, business rules, and refresh schedules
• Establish repeatable processes that reduce manual intervention and improve data trust

Collaborate with Stakeholders Across the Business

• Work with operational leaders, analysts, and managers to understand their reporting needs
• Translate business requirements into structured technical solutions
• Gather feedback from users and iterate dashboards or datasets to enhance clarity and usability
• Provide light training and support for business users adopting new dashboards

Support Solutions Innovation Initiatives

• Contribute to data and analytics components of iLab initiatives and innovation pilots
• Assist in evaluating external data sources, third‑party tools, and new reporting opportunities
• Help modernize existing reporting processes or replace inefficient legacy approaches

Maintain Standards, Documentation, and Version Control

• Use Git-based workflows to track changes to Python scripts and reusable analytics assets
• Maintain documentation for dashboards, pipelines, and supporting scripts
• Follow organizational best practices for security, consistency, and maintainability

Deliver Measurable Improvements in Reporting

• Reduce manual reporting effort across teams through automation and reusable datasets
• Improve data refresh reliability and decrease dashboard load times
• Enhance overall data visibility for leaders through standardized reporting assets

They will support operations with changes to workflows also to provide our contracts with necessary delivery information within the systems database.

Do you want to mention using the enterprise tools available.

Qualifications

WHO ARE WE LOOKING FOR?

Technical Skills

• 3+ years of hands‑on experience with Power BI
• Proficiency in Python
• Strong SQL skills
• Experience working with external data sources:
  • SaaS platforms, REST APIs, flat files, SFTP, partner data feeds, or vendor systems
• Familiarity with Smartsheet
• Familiarity with SharePoint
• Strong understanding of data quality, validation, and reconciliation practices
• Experience with version control

Analytical & Business Skills

• Ability to translate business questions into structured data requirements and reporting solutions
• Strong problem‑solving skills with a detail-oriented approach to data accuracy
• Ability to present insights in a clear and meaningful way to non‑technical audiences
• Track record of working collaboratively with business stakeholders

Soft Skills

• Excellent communication skills - written, verbal, and visual
• Ability to work independently, manage priorities, and meet deadlines
• Curiosity and willingness to explore new tools, methodologies, and data sources

Nice-to-Have Qualifications

Technical Extras

• Exposure to Microsoft Azure
• Familiarity with Microsoft Fabric
• Experience building lightweight internal tools using Streamlit, Flask, or equivalent
• Familiarity with the M365/Graph API ecosystem
• Experience with CI/CD for analytics assets (Power BI pipelines, GitHub Actions, or Azure DevOps)

Domain & Tools

• Experience working with operational or facilities‑related data
• Prior work within an innovation, analytics, or continuous‑improvement‑focused team

Additional Information

WHAT’S IN IT FOR YOU?

• Be part of an industry that's more important than ever!
• Employee Referral Program!
• Career advancement opportunities.
• Whereas other companies are downsizing, we are growing!
• Be #1 on day 1 by joining an industry leader.

Dexterra Group is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans’ status, Indigenous status, or any other legally protected factors. Disability-related accommodations during the hiring selection process are available upon request.