Software Developer 9221-2012

Foilcon; Toronto; Hybrid; CAD 60,000 - 75,000; Full time

Job summary

Join a leading company as a Software Developer, focusing on modernizing legacy applications through data warehousing and reporting. This hybrid contract role requires collaboration on developing a new Dynamics CE-based solution, ensuring data accuracy, and optimizing system performance.

Qualifications

• Proficiency in Power BI and Azure Synapse Analytics required.
• Experience with Dynamics 365 CE/F&O reporting essential.

Responsibilities

• Design and develop the data warehouse on Microsoft Azure.
• Create reports, dashboards, and ensure report accuracy.

Skills

Power BI

ETL

SQL

Data Governance

Azure Synapse Analytics

Tools

Azure DevOps

Azure Repos

Job description

Join to apply for the Software Developer 9221-2012 role at Foilcon

HM Note: This hybrid contract role requires three (3) days in the office. Candidates must include their first and last name in their resume.

Description

Scope

• The OPGT is developing ‘PGTIMS’, a new Dynamics CE-based solution to modernize legacy applications. This involves migrating historical data to a new data warehouse/Lakehouse, creating new data assets, and developing PowerBI reports.

Assignment Deliverables

As a reporting team member, you will deliver the MVP for reporting, build the data warehouse/lakehouse, and ensure report accuracy. Key tasks include:

• Designing the data warehouse on Microsoft Azure.
• Developing and automating ETL processes from Dynamics 365 CE and F&O.
• Creating logical and physical data models.
• Implementing data security and governance.
• Developing reports, dashboards, and visualizations.
• Optimizing system performance.
• Other duties as assigned.

The Consultant Will Also Be Required To

• Meet deadlines and milestones.
• Report issues promptly.
• Submit deliverables for approval.
• Follow security, architecture, and confidentiality standards.
• Transfer knowledge to staff.
• Adhere to relevant policies and procedures.

Skills and Experience

Mandatory Requirements

• Proficiency in Power BI (data modeling, reports, dashboards, advanced features).
• Experience with ETL and Microsoft Azure Synapse Analytics.
• Experience with Dynamics 365 CE and/or F&O reporting.

Nice to Have

• Azure cloud certifications (e.g., Azure fundamentals, Power BI Data Analyst).
• Dynamics 365 certifications.

Desired Skills and Experience

• Knowledge of data warehousing principles and data governance.
• Deep experience with Azure Synapse and data storage options.
• Advanced Power BI skills, including DAX and Power Query.
• Strong SQL skills and query optimization.
• Development experience with Dynamics 365 and understanding of the Common Data Model.
• Experience with version control and collaboration tools like Azure Repos and Azure DevOps.

Resumes Evaluation Criteria

• Power BI skills and experience (25 points).
• ETL and Azure platform experience (25 points).
• Dynamics 365 development experience (25 points).
• SQL and database skills (15 points).
• Azure DevOps experience (10 points).

Knowledge Transfer

• Document tasks and processes using project tools.
• Coordinate with project manager and team members.
• Maintain documentation throughout the project lifecycle.

Must Have

• Power BI proficiency.
• Azure Synapse Analytics experience.
• Dynamics 365 report development experience.

Nice to Have

• Azure cloud certifications.
• Dynamics 365 certifications.

Seniority level

• Entry level

Employment type

• Contract

Job function

• Engineering and Information Technology

Industries

• IT Services and IT Consulting