Sql analyst Jobs in Scarborough, ON

We are seeking a highly accomplished Technical Analyst for an enterprise-level contract opportunity based in Scarborough. In this role, you will take on a premier technical evaluation and strategy capacity, specializing in assessing legacy application portfolios, evaluating modern low-code frameworks, and defining cloud migration roadmaps.

As a principal technical analyst, you will bridge the gap between legacy database-driven applications and modern enterprise cloud platforms. Operating within a hybrid work model, you will lead comprehensive current-state assessments of Oracle APEX environments, perform total cost of ownership (TCO) analyses, facilitate stakeholder discovery workshops, and formulate future-state transition roadmaps centered around Microsoft Power Platform and enterprise management systems. This position demands a seasoned consultant who can rigorously analyze application architectures, evaluate licensing models, and author executive-level business cases for digital modernization.

Location: Scarborough, ON

Assignment Type: Hybrid (3 days per week onsite)

Contract Duration: 3-month contract (with a 3-month optional extension)

Advantages
Strategic Modernization Leadership: Drive high-visibility application portfolio assessments and define target-state cloud architectures.

Dual Technology Exposure: Apply deep technical expertise across Oracle APEX database environments and modern Microsoft Power Platform ecosystems.

Executive Impact: Author comprehensive business cases, total cost of ownership models, and present migration strategies directly to leadership.

Flexible Work Model: Work within a collaborative hybrid arrangement combining onsite teamwork with remote flexibility.

Responsibilities
Assess current-state Oracle APEX application portfolios, technical architectures, hosting environments, database dependencies, integrations, and operational support models.

Document business purpose, technical complexity, user bases, data sensitivity, and integration requirements for legacy applications.

Conduct fit-gap analyses to determine optimal future-state options, including Microsoft Power Platform adoption, enterprise Client/Work Management systems, consolidation, retirement, or redevelopment.

Perform total cost of ownership (TCO) and cost-benefit analyses across licensing models, infrastructure, Dataverse requirements, connectors, and ongoing maintenance.

Evaluate business processes, risks, constraints, dependencies, performance benchmarks, and scalability opportunities for application consolidation or automation.

Facilitate discovery workshops, interviews, project review meetings, and executive stakeholder presentations across business and technical teams.

Develop future-state architecture recommendations, transition roadmaps, implementation phases, resource estimates, and governance strategies.

Establish Power Platform environment strategies, security frameworks, Dataverse models, solution deployment standards, and administrative guidelines.

Author executive briefings, technical documentation, business case materials, scoring matrices, and conduct knowledge-transfer sessions for internal staff.

Qualifications
Core Technical & Analytical Capabilities
Education: University degree or diploma in Computer Science, Computer Programming, or an equivalent combination of education and professional experience.

Oracle APEX Environment Depth: Extensive experience analyzing, designing, supporting, and evaluating Oracle APEX application portfolios, database dependencies, hosting models, and migration strategies.

Microsoft Power Platform Mastery: Extensive experience with Microsoft Power Platform components (Power Apps, Power Automate, Power BI, Dataverse, connectors, environments, licensing, governance, and administration).

Financial & Business Case Modeling: Demonstrated experience developing business cases, options analyses, total cost of ownership (TCO) models, and cost-benefit evaluations for technology modernization.

Business Analysis & Requirements Gathering: Strong business analysis skills, including stakeholder engagement, process mapping, fit-gap analysis, risk assessment, and technical documentation.

Soft Skills & Facilitation
Consultative Communication: Exceptional written, verbal, and presentation skills with the confidence to communicate complex technical choices to executive stakeholders.

Workshop Facilitation: Proven ability to lead discovery sessions, drive consensus, and gather requirements across multi-disciplinary teams.

Summary
If you're interested in the "Technical Analyst" role based in Scarborough, 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.