Data Solutions Engineer - Hybrid, Power BI & Data Automation

Dexterra Group; Mississauga; Hybrid; CAD 85,000 - 115,000; Full time

Benefits offered by this job

Onsite Hybrid

Employee Referral

Great Place to Work 2025-2026

Safety culture

Team growth

Job summary

Dexterra Group in Mississauga, ON is seeking a Data Solutions Engineer to turn complex data into practical business insights. You will design, build, and support data-centric solutions that connect business needs with technical delivery.

Collaborate with architects, stakeholders, project teams, and vendors to deliver reliable integrations, reporting, applications, and automations using Microsoft Power Platform and AI-assisted tools.

Qualifications

• Post-secondary education in information systems, computer science, data analytics, or related field, or equivalent practical experience.
• 3–5 years of experience in data integration, reporting, business systems, or solution development.
• Experience with data integration, ETL, APIs, Power BI reporting, data modelling, data mapping, and data analysis.
• Understanding of relational, cloud, and application data platforms such as Azure SQL, SQL Server, Dataverse, and Azure Storage.
• Familiarity with Microsoft Power Platform, Microsoft Fabric, Azure, or similar enterprise data platforms, with the ability to learn new technologies quickly.
• Understanding of software development, agile delivery, data security, privacy, access control, and responsible use of AI-assisted development tools.
• Strong communication, analytical, problem-solving, and requirements‑gathering skills, with the ability to explain technical concepts to non-technical stakeholders.
• Ability to take ownership, manage changing priorities, meet deadlines, and work effectively in a fast‑paced team environment.

Responsibilities

• Collaborate with stakeholders to understand requirements, improve processes, and translate business needs into effective solutions.
• Design, build, and support data integrations using APIs, flat files, automation tools, and enterprise platforms.
• Structure, validate, and reconcile data to support reporting, analytics, operational decisions, and reliable downstream processes.
• Design, build, and enhance Power BI reports, dashboards, and supporting data models.
• Develop and maintain solutions, applications, and automations using enterprise and low-code platforms such as Microsoft Power Platform.
• Test, deploy, troubleshoot, and manage solution changes using established version control, release, security, and delivery standards.
• Use AI-assisted tools responsibly to accelerate analysis, development, and documentation while validating and testing generated output.
• Document solutions and support procedures to enable ongoing support, continuous improvement, and knowledge transfer.

Skills

Strong communication

Analytical thinking

Requirements gathering

Ownership & prioritization

Education

Bachelor's degree in CS/IS or data analytics

Tools

Azure SQL

SQL Server

Dataverse

Azure Storage

Power BI

Power Platform

APIs

ETL

Data modeling

Data mapping

Job description

Dexterra Group in Mississauga, ON is seeking a Data Solutions Engineer to turn complex data into practical business insights. You will design, build, and support data-centric solutions that connect business needs with technical delivery.

Collaborate with architects, stakeholders, project teams, and vendors to deliver reliable integrations, reporting, applications, and automations using Microsoft Power Platform and AI-assisted tools.