Job Information
Dexterra Developer, Analytics & Reporting in Mississauga, Ontario
Company 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.
Job Description
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.