Senior Software Developer – CRM Dynamics 365 & Power BI

Required Skills:

Mandatory Requirements Candidates must demonstrate all three mandatory requirements below: 1. Microsoft Dynamics 365 CE / Enterprise Application Development 5 years of experience developing and supporting enterprise applications including Microsoft Dynamics 365 Customer Engagement (CE). Hands-on experience developing configuring customizing and supporting Dynamics 365 CE solutions in enterprise environments. 2. Power BI Proven proficiency with Microsoft Power BI including: Data modeling Interactive reports Interactive dashboards Advanced Power BI functionality 3. Dynamics 365 CE / F&O Reporting Proven experience producing reports using data from Microsoft Dynamics 365 Customer Engagement (CE) and Finance & Operations (F&O). Candidates who cannot demonstrate all three mandatory requirements should not be submitted. Key Responsibilities The Senior Software Developer will: Develop and support enterprise solutions within Microsoft Dynamics 365 Customer Engagement (CE). Configure customize and extend Dynamics 365 CE based on approved technical designs and user requirements. Translate technical system specifications and user stories into functional tested solution components. Troubleshoot and resolve technical issues related to Dynamics 365 CE and supporting systems. Develop Power BI reports dashboards and visualizations based on business and user requirements. Analyze and interpret complex data sets to identify business performance trends and insights. Ensure the quality accuracy integrity and reliability of reports and data. Produce reporting solutions using data from Dynamics 365 CE and F&O. Support system integration and user acceptance testing by resolving defects and validating data accuracy. Participate in deployment activities and provide technical support during post-go-live stabilization. Develop and support integrations involving Dynamics 365 and other enterprise data sources. Contribute to technical documentation and operational knowledge bases. Provide knowledge transfer to designated Ontario Government staff and team members. Work collaboratively with developers solution architects business analysts testers internal teams and external/vendor resources. Follow Ontario Government architecture security development technology and delivery standards. Complete assigned deliverables and milestones within established timelines. Identify and communicate technical issues risks and material concerns to the Project Manager. Support ongoing enhancements and refinements beyond the Minimum Viable Product (MVP). Technical Skills & Experience Dynamics 365 CE Development Strong hands-on experience with: Microsoft Dynamics 365 Customer Engagement (CE) Dynamics 365 configuration and customization Forms Views Dashboards Workflows Business rules Process automation Security roles Data access configurations Custom components Plug-ins/extensions C# / .NET JavaScript Microsoft Dataverse Entity structures and relationships Data validation and integrity Dynamics 365 platform extensibility Candidates should be able to translate approved technical designs and user stories into functional tested Dynamics 365 solution components while adhering to established architecture security and development standards. Power BI Strong Power BI experience including: Data modeling Interactive report development Dashboard development Data visualization Power Query DAX Data gateways Advanced Power BI functionality Connecting Power BI to enterprise data sources Developing reports from Dynamics 365 CE data Developing reports from Dynamics 365 F&O data Data accuracy and validation SQL & Data Strong experience with: SQL Complex SQL queries Query optimization Database performance troubleshooting Indexing Partitioning Query execution plans Data extraction Data transformation Data loading Data validation Logical and physical data modeling Relationships and hierarchies Efficient data storage and retrieval Data Integration & ETL Experience with various data integration techniques including: Extracting data from databases API-based data extraction Flat-file data extraction Data transformation Data loading ETL processes Data warehouse integration Azure-based data integration technologies Azure Synapse or similar ETL/data integration technologies Data Warehouse / Lakehouse Experience with: Developing reports using Data Warehouse / Lakehouse environments Data warehouse concepts Data modeling ETL processes Data integration Data governance Enterprise reporting Data quality and integrity Development DevOps & Collaboration Experience working within structured enterprise development environments including: Azure DevOps Azure Repos Version control CI/CD practices Build and release pipelines Automated deployment/testing processes Technical documentation Agile/iterative enhancement environments Cross-functional delivery teams Collaboration with developers architects BAs testers internal staff and vendors Working within established architecture coding security and technology standards Evaluation Criteria Candidates will be assessed across the following areas: 1. Dynamics 365 CE / F&O Development & Reporting 25 Points Demonstrated hands-on experience with: Dynamics 365 CE configuration and customization Forms views dashboards Workflows business rules and automation Security roles and data access C#/.NET and JavaScript Dataverse Entities and relationships Data handling and validation Dynamics 365 extensibility Translating technical designs/user stories into tested solutions Reporting from Dynamics 365 CE and F&O 2. Power BI 25 Points Demonstrated experience with: Power BI Data modeling Interactive reports Dashboards Data gateways DAX Power Query Advanced Power BI functionality 3. Data Integration & Extraction 20 Points Experience with: Data extraction from databases APIs and flat files Data transformation Data loading Data warehouse integration ETL technologies Azure Synapse Logical and physical data models Relationships and hierarchies Efficient data storage and retrieval 4. Development Practices Collaboration & Standards 15 Points Experience with: Enterprise development practices Architecture/coding/security standards CI/CD Build and release pipelines Version control Azure DevOps Automated deployment/testing Cross-functional teams Vendor/internal collaboration Iterative development and post-MVP enhancements Technical documentation Knowledge sharing and operational sustainability 5. Data Warehouse / Lakehouse 15 Points Experience with: Developing reports in Data Warehouse/Lakehouse environments Data warehouse principles Data modeling ETL Data integration Data governance Nice-to-Have Qualifications Azure certifications such as: Azure Fundamentals Azure Power BI Data Analyst Associate Microsoft Dynamics 365 certifications Additional experience supporting enterprise Dynamics 365 implementations. Knowledge Transfer The consultant will be expected to document tasks completed and in progress as part of the PGTIM Support and Data Migration team. Knowledge transfer will include: 1:1 meetings Team meetings Technical documentation DevOps Wiki DevOps boards Ongoing knowledge sharing throughout the project lifecycle Knowledge recipients: Project Manager and project/team members. Ideal Candidate Profile The ideal candidate is a Senior Dynamics 365 CE Developer with strong enterprise application development experience and a demonstrated ability to combine Dynamics 365 CE development Power BI reporting SQL data integration and data warehouse/lakehouse technologies. The candidate should be comfortable working in a structured Ontario Government environment collaborating with internal and vendor teams troubleshooting production/support issues implementing enhancements developing reports supporting testing and deployments and documenting solutions for long-term operational sustainability.

Required Education:

Bachelors Degree in Computer Science Information Technology Software Engineering Computer Engineering or a related Degree in Computer Science Information Technology Data Analytics or a related field is an Dynamics 365 / Power Platform certifications are an Azure certifications including Azure Fundamentals and Power BI Data Analyst Associate are an asset.