Sql analyst Jobs in Mississauga, ON

We are seeking a delivery-focused, Mid-Level IT Business Analyst with specialized expertise in the Microsoft Dynamics 365 CRM/CE ecosystem to support an enterprise-level platform implementation. In this role, you will act as the vital bridge between frontline operational teams, regulatory stakeholders, and technical developers.

Your day-to-day focus will center on eliciting operational requirements, mapping future-state workflows, and converting complex regulatory frameworks into structured technical specifications. The ideal candidate pairs a solid understanding of the Power Platform with an analytical mindset, preferably bringing experience with D365 Field Service modules to optimize field operations and scheduling.

Location: Etobicoke, ON (Hybrid)

Contract Duration: 6-month contract

Advantages
High-Impact Domain: Take a key role in a major digital transformation that modernizes regulatory and public service delivery.

Strategic Growth: Deepen your technical footprint across modern D365 cloud ecosystems and Field Service automation frameworks.

Centrally Located: Work out of a professional, collaborative Etobicoke office space with standard hybrid flexibility.

Project Continuity: Enter an active project lifecycle with an initial 6-month contract and strong potential for ongoing phase extensions.

Responsibilities
1. Requirements Elicitation & Functional Design
Facilitate requirements-gathering sessions and workshops with business users, frontline administrative staff, and technical leads to define project scope.

Translate complex regulatory codes, licensing rules, and business needs into clean, logical functional requirements, user stories, and acceptance criteria.

Configure out-of-the-box D365 CRM features, forms, and views, and create comprehensive configuration workbooks for the development team.

2. Process Mapping & Data Analysis
Document current-state ("as-is") workflows and design optimized future-state ("to-be") operational processes using MS Visio or similar modeling tools.

Analyze legacy data structures using advanced Excel techniques to support data profiling, field-to-field mapping, and system migration validation.

Maintain rigorous requirements traceability matrices (RTM) using Azure DevOps or Jira from discovery through to QA testing.

3. Testing & Implementation Support
Partner with QA teams to develop testing scenarios, review test cases, and coordinate User Acceptance Testing (UAT) with business subject matter experts.

Serve as a proactive platform advocate, challenging unnecessary system customizations and suggesting out-of-the-box D365 capabilities.

Assist in developing end-user training documentation and providing post-implementation hypercare support.

Qualifications
Job Requirements & Qualifications
Core Experience: 3–5 years of progressive experience as an IT Business Analyst, with a proven track record of delivering enterprise software projects.

D365 CRM Expertise: Minimum of 2 years of hands-on experience specifying, configuring, or supporting implementations of Microsoft Dynamics 365 CRM/CE (Sales, Customer Service, or Power Pages/Portals).

Tooling Stack: High proficiency with MS Visio, Microsoft Excel (pivot tables, lookups, data validation), and Agile management trackers (Azure DevOps or Jira).

Soft Skills: Diplomatic and effective communication skills; exceptional capacity to digest complex rules and build strong collaborative relationships across matrixed teams.

Preferred Asset Qualifications (Nice-to-Haves)
Direct experience or familiarity with D365 Field Service components (e.g., Schedule Board, Work Orders, Asset Tracking, or inspector dispatch workflows).

Active Microsoft Certifications: MB-230 (Dynamics 365 Customer Service Functional Consultant) or PL-200 (Power Platform Functional Consultant).

Formal business analysis designations such as CBAP or PMI-PBA.

Prior experience working within a Canadian public sector agency, Crown corporation, or regulated industry framework.

Summary
If you are a mid-level Business Analyst who excels at transforming complex business requirements into elegant Dynamics 365 solutions, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.