ON - RQ07885 - Software Developer - Senior

We have received a new requirement from one of the ministries in Ontario. Please refer to the details provided below:
We are unable to submit a candidate without below mandatory documents.

To check the detailed description and matrix visit our website: 
APPLY ONLINE
We're excited to invite you to join our company's WhatsApp group dedicated to for new job postings. Your insights and contributions would be incredibly valuable. Please use the link below to join: [CLICK HERE] We look forward to your participation!" 
(NOTE: Share required documents to [email protected] by Friday, September 13, 11:30 AM EST.

Note:
This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be “Hybrid”, working 7.25 hours per calendar day, sometime between 8:00-5:00 PM (excluding lunch breaks) Monday to Friday inclusive for three (3) days onsite and two (2) days remote (offsite), unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager’s requirements for the assigned Project.
The VOR Master Service Agreement which expires on April 5, 2025, leaves some Contracts with funding unassigned for fiscal 2025-26. If the current statement of work expires on March 31, 2025, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2025, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2025, and be upon the same terms, conditions, and covenants contained in the SOW.
The start date is subject to change based on security clearances and contract signing timelines.
Experience and Skill Set Requirements

Nice to have:

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

Description
Scope:

• The OPGT is developing “PGTIMS”, a new Dynamics CE based solution that will modernize OPGT’s legacy applications and systems. This project requires migrating historical data from the legacy solutions to a new data warehouse/lakehouse, building all the new data assets in the lakehouse and creating new PowerBI reports.

Deliverables:

• As a member of the reporting team, you will be responsible deliver the MVP for reporting, build the new data warehouse/lakehouse and deliver the required reporting. A high-level list of deliverables for the data migration team follows:
• Data Warehouse Design: analyze business requirements and design an efficient data warehouse/lakehouse/golden layer on Microsoft Azure
• Data Integration and ETL: help develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the new data warehouse/lakehouse (bronze/silver/golden layers). Help integrate data from diverse sources into the new data warehouse.
• Data Modeling: create logical and physical data models that align with the project’s reporting and analytical needs.
• Data Security and Governance: implement appropriate security controls to protect sensitive data within the data warehouse and reports.
• Reporting and Visualization: develop reports, dashboards and visualizations as per reporting MVP. Ensure the quality, accuracy and integrity of reports.
• Performance Optimization: fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.
• Other duties as assigned.

Skills and knowledge:

• Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.
• Microsoft Azure Synapse: In-depth knowledge and experience with Azure Synapse Analytics, including its architecture, data storage options (e.g., SQL Data Warehouse, Data Lake Storage), data ingestion mechanisms (e.g., Azure Data Factory), and security features.
• Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.
• SQL and Query Optimization: Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues. Understanding of indexing, partitioning, and query execution plans.
• Development experience with Dynamics 365 and understanding of the Common Data Model for Dynamics. 
• Report development experience for Microsoft Dynamics 365 Customer Engagement (CE) and/or Finance and Operations (F&O)
• Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.