It consultant Jobs in North York, ON

We are seeking a Senior Specialized IT Consultant with deep expertise in Business Intelligence (BI) and Quality Assurance to drive the testing and optimization of complex data systems. In this role, you will act as a subject matter expert, advising clients on IT strategies to improve organizational efficiency. You will lead the analysis and profiling of diverse data sets while ensuring the integrity of ETL programs and BI products. This position requires a technical leader who can bridge the gap between complex data warehousing and high-level business objectives

Pay Rate: $445.44- $482.88



Advantages
- Strategic Role: Move beyond basic execution to provide planning advice on data usage and advanced analytics capacity building.

- Leadership Opportunity: Take a formal role in mentoring junior team members and leading JAD sessions.

- Modern Tooling: Work across a diverse environment featuring Azure DevOps, Informatica, and high-end automation suites.

Responsibilities
- Strategic Advisory: Provide guidance on Information Management, IT infrastructure, and the enablement of major business processes through technical enhancements.

- End-to-End BI Testing: Lead the testing of the entire BI stack, including the database, data warehouse, ETL layer (Informatica), and presentation layer (Cognos/Power BI).

- Technical Leadership: Lead data analysis and profiling tasks; mentor junior QA analysts on test frameworks and execution.

- ETL Validation: Analyze and test Extract, Transform, and Load (ETL) process flows to ensure accurate data transformations from source to target.

- Test Management: Create comprehensive test strategies, plans, and scripts. Execute functional, regression, and performance testing using tools like HP-ALM and Azure DevOps.

- Accessibility Compliance: Conduct testing for WCAG AA and AODA compliance using tools such as JAWS screen readers and Compliance Sheriff.

- Documentation & Design: Participate in JAD sessions, code walkthroughs, and update technical documentation including source-to-target mapping and operations manuals.

- Collaboration: Partner with Business Analysts and IT specialists to identify risks, develop mitigation strategies, and facilitate defect resolution.

Qualifications
- BI Testing Mastery: 10+ years of experience testing BI solutions, including data warehouses, data marts, and reporting layers.

- SDLC Expert: Proven track record of executing testing through all phases of the Software Development Life Cycle (SDLC) and STLC.

- SQL Proficiency: Demonstrated experience creating complex SQL scripts for deep data analysis, profiling, and performance optimization.

- Automation Tools: Hands-on experience with Quick Test Pro (UFT), HP Quality Center (ALM), and LoadRunner.

- Technical Stack: Proficiency in testing solutions built with Oracle (11g, 12c), Informatica, IBM Cognos, and Microsoft BI (Power BI/SSRS).

- Data Concepts: Strong understanding of Slowly Changing Dimensions (SCD) and profiling data across XML, JSON, and Excel formats.

- Methodologies: Significant experience working in both Agile and Waterfall environments with a focus on SIT, SAT, and UAT cycles.

Summary
If you're interested in the Specialized IT Consultant role based in Toronto, 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.