RQ09221 - Software Developer - Senior

2iSolutions Inc.; Ontario; Hybrid; CAD 85,000 - 110,000; Full time

Job summary

A leading company is seeking a Senior Software Developer to work on a hybrid basis, focusing on developing a Dynamics CE solution and modernizing legacy applications. The role involves designing data warehouses, developing ETL processes, and creating PowerBI reports. Candidates should have strong skills in Power BI, ETL, and Dynamics 365 CE. This is a 6-month assignment with a mix of onsite and remote work.

Qualifications

• Proficiency in Power BI, including data modeling and reports.
• Experience with ETL and Azure Synapse Analytics.
• Experience in Dynamics 365 CE report development.

Responsibilities

• Design data warehouse and develop ETL processes.
• Create PowerBI reports and dashboards.
• Comply with security and architecture standards.

Skills

Power BI

ETL

Dynamics 365 CE

SQL

Tools

Azure Synapse Analytics

Azure DevOps

Job description

Anyone interested with relevant skills can share their resume on the provided platform.

Job Details

Title : RQ09221 - Software Developer - Senior

Client : Ministry of Public and Business Service Delivery and Procurement

Period : Approx. 6 months

Start Date : 2025-06-02

End Date : 2025-11-27

Working Hours : 7.25 Hrs. / day

Location : 3 Days onsite / 2 days remote / 720 Bay Street, Toronto

Hybrid role - Candidate is required to work in the office 3 days a week and remotely 2 days.

Must Haves

• Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features.
• Experience with ETL / Microsoft Azure Synapse Analytics, including architecture, data storage, ingestion, and security.
• Experience in Dynamics 365 CE and/or F&O report development.

Nice to Have

• Dynamics 365 certifications

Description

Assignment Type Note : This position is listed as "Onsite" but will be "Hybrid" during the assignment, working 7.25 hours daily, between 8:00 AM and 5:00 PM, Monday to Friday. Conditions may change based on operational requirements. The candidate will work under the discretion of the Hiring Manager.

Scope

The project involves developing "PGTIMS", a Dynamics CE based solution to modernize legacy applications, migrating data to a new data warehouse/lakehouse, and creating new PowerBI reports. Responsibilities include designing data warehouse, developing ETL processes, creating data models, implementing security, developing reports and dashboards, optimizing performance, and other duties as assigned.

Responsibilities

• Complete work and milestones within deadlines.
• Notify project managers of issues or concerns.
• Submit deliverables for approval.
• Comply with security, architecture, confidentiality, and other standards and guidelines.
• Transfer knowledge to staff.

Experience and Skills Requirements

Mandatory

• Proficiency in Power BI, including data modeling, reports, dashboards, and advanced features.
• Experience with ETL / Azure Synapse Analytics, architecture, data storage, ingestion, security.
• Experience with Dynamics 365 CE and/or F&O report development.

Nice to Have

• Dynamics 365 certifications

Desired Skills

• Data warehousing principles, data modeling, ETL, data governance.
• Azure Synapse Analytics architecture, data storage, ingestion, security.
• Proficiency in Power BI, including DAX, Power Query, data gateways.
• SQL skills for complex queries, optimization, performance tuning.
• Experience with Dynamics 365 development and common data model.
• Report development for Dynamics 365 CE and F&O.
• Version control and collaboration tools like Azure DevOps.

Resumes Evaluation Criteria

PowerBI - 25 Points

• Experience with Power BI, reports, dashboards, data gateways, advanced features, SSIS, SSRS, Azure Data Factory.

Dynamics 365 - 25 Points

• Experience with PowerApps, Power Automate, Dynamics CE & F&O, report production.

SQL / Database - 15 Points

• Experience with T-SQL, PL/SQL, database performance, SQL Server, Oracle, Azure SQL, Azure DevOps.

Knowledge Transfer

• Document tasks and processes using project tools and approaches.

• Conduct meetings and maintain documentation throughout the project lifecycle.