Consultant, Business Systems Analyst (Data Migration and SQL)

Project X; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A consulting firm in Toronto is seeking a Business Systems Analyst to develop and implement tailored data solutions. The ideal candidate has 3-5 years of experience, proficiency in SQL, and a strong understanding of Agile and Waterfall methodologies. Responsibilities include gathering requirements, testing, and collaborating with internal and external teams to ensure successful project delivery.

Qualifications

• Around 3-5 years’ experience, including 3 as a Business Systems Analyst.
• Working knowledge in Agile and Waterfall methodologies.
• Experience with ETLs, analytics, and reporting.

Responsibilities

• Deliver excellence and develop understanding of clients’ business issues.
• Ensure requirements are clear and complete.
• Create detailed functional documents and obtain sign-off.

Skills

Experience in SQL

Experience working with databases

Knowledge in SDLC methodologies

Critical thinking capabilities

Collaboration skills

Education

Bachelor's Degree in Software or Computer Science

Tools

MicroStrategy

Tableau

Teradata

Oracle

Job description

About Project X

About Project X

Project X Ltd. drives success by focusing on building teams of incredibly talented and client-focused people, who love to problem solve and work on tough data problems. We reward hard work and forward-thinking with recognition and a supportive culture that celebrates success and wants to see you grow.

Our team members are trusted advisors to our clients and offer innovative solutions that solve complex data problems. Collaboration, creativity, data knowledge and experience run deep in our veins. We are passionate about building long-term relationships with our clients and staying true to our values. When adding new members to our team, we also look for people that are aligned to our values.

We are also passionate about our people. Hiring and developing people that seek challenges, like to jump in and learn new things, and are happy to lend a helping hand to a peer is what makes us successful.

We understand that it’s our people that make us great.

Role Summary

The Consultant, Business Systems Analyst works with internal and external stakeholders including the technology and business teams to develop and implement data solutions tailored to a project’s requirements. The nature of the projects varies from Waterfall to Agile and technology varies from legacy to cutting edge. They are involved throughout the project lifecycle by capturing and documenting requirements, test strategy/plans, test cases, execution of testing, sign off and implementation into production. They are supported by team members and the Practice Manager.

This position does not have any direct reports.

Major areas of Responsibility

• Deliver excellence and develop a deep, multilayered understanding of the business issues and the data challenges of the clients’ organizations and their industries.

• Ensure requirements are clear and complete, eliminating uncertainties and ambiguities.

• Establish the quality of solutions through validation against the requirements.

• Demonstrate collegial teamwork internally and with clients, by communicating clearly with all project team members to identify and resolve issues for successful delivery.

• Escalate issues promptly when required.

• Participate in the development of project plans to establish appropriate workload expectations and schedules.

• Own the responsibility to meet deadlines and strive to complete work in accordance with project plans.

• Drive and own requirements by gathering all requirements that are a part of the overall project.

• Create detailed, functional, and non-functional requirements documents, review and obtain sign off from key stakeholders.

• Provide ongoing updates and review throughout the project lifecycle.

• Create and execute test strategy/plans and test cases.

• Own defect management and drive regression testing if required.

Required Knowledge, Skills, Abilities and Other

• Around 3-5 years’ experience on technical projects including 3 as a Business Systems Analyst

• Detailed, practical working knowledge in SDLC methodologies, specifically Agile and Waterfall

• Experience working with databases, data warehouses, ETLs, analytics and reporting

• Experience in SQL, Teradata, or Oracle

• General Knowledge in Analytics / Business Intelligence tools (MicroStrategy, Tableau, Cognos, Looker) and Cloud (AWS, GCP, Azure) or Big Data (Hadoop, Hive, Impala)

• Demonstrated skills in Documenting requirements e.g. BRD, SRS, Test Documents, MOP, Data Mapping, or Data Dictionaries

• Collaborating with internal teams (Project X ltd.), external teams (non-Project X 3rd parties), and client team members

• Critical thinking capabilities and a consultative mindset

• Bachelor's Degree, preferably in Software or Computer Science/Engineering fields or related industry experience or acumen

Nice to have:

• Prior experience as a Data Analyst is an asset but please ensure you have BA experience