Junior/intermediate Business Analyst

Nexus Systems Group Inc.; Mississauga; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A technology consulting firm in Mississauga is seeking a Senior Analyst for a financial risk project. The role involves data analytics and collaboration on a Microsoft tech stack. Ideal candidates will have over four years of experience and a background in SQL and Azure. Strong communication and problem-solving skills are essential for success. This position allows for hybrid work patterns and requires attending the office three times a week.

Qualifications

• 4+ years experience as a junior analyst.
• Familiarity with Microsoft Technologies like SQL and Azure.
• Experience in building OLAP and OLTP-based data systems.
• Ability to gather requirements and document them (BRD).

Responsibilities

• Interact with end users to understand their data needs.
• Work with a Microsoft technology stack.
• Collaborate with internal IT stakeholders and fulfill best practices.
• Provide necessary information to project architects.
• Assist junior resources and guide solution execution.

Skills

Strong Communication

Stakeholder Management

Time Management

Adaptability

Problem Solving

Education

Bachelor's degree in Computer Science or Engineering

Master’s degree (preferred)

Tools

SQL

Microsoft Azure

Power BI

Power Apps

Power Automate

Job description

Position Details

• Location: Toronto (required to attend 3 times a week on Tuesdays, Wednesdays, and Thursdays)
• Contract Duration: Start ASAP, end date: 12/26/2025
• Possibility of Extension & Conversion to FTE
• Number of Positions: 1
• Schedule Hours: 9am-5pm, Monday-Friday (standard 37.5 hrs/week)
• Reason: New Project

Overview / Business Context

Story Behind the Need

• Business Group: Corporate Functions Technology – supporting marketing, HR, finance, and risk. The Risk Technology organization within this group primarily serves operational risk stakeholders.
• Project: Focused on the financial risk domain, involving data analytics, reporting, regulatory reporting, and advanced analytics. This role requires technical expertise, with exposure to the financial domain being a plus.
• Domain Knowledge: Banking, Insurance, Risk, Financial Risk Management, Retention Management

Responsibilities

• Typical Day in Role
  • Interacting with end users to understand their data and reporting needs.
  • Working with a technology stack centered on Microsoft. Understanding current requirements.
  • Collaborating with internal IT stakeholders, including architects, the data office, and the AML team. Ensuring collaboration with other project stakeholders and fulfilling their requests and best practices around delivery areas.
  • Providing all necessary information to architects to complete the project.
  • In a senior role, assisting offshore junior resources with their questions and being involved in the execution of solutions (Azure, SQL Server, Power BI, Power Apps platform required).

Soft Skills

• Strong Communication
• Stakeholder Management
• Time Management
• Adaptability
• Problem Solving

Qualifications

• Must-Have Skills
  • 1. 4+ years experience as junior anaylst
  • 2. Familiarity with Microsoft Technologies like SQL, Microsoft Azure
  • 3. Prior experience in building OLAP and OLTP-based data analytics and business intelligence systems.
  • 4. Requirement Gathering, Business Requirement Documentation (BRD), Power BI, Power Apps and Power Automate

• Nice-to-Have Skills
  • 1. Familiarity with the financial risk domain

Education

Bachelor's degree in a technical field such as computer science or computer engineering. A mathematical background is also acceptable. A Master’s degree is preferred.

Candidate Evaluation

• Best vs. Average Candidate

  The ideal candidate will possess strong soft skills and a can-do attitude. Meeting 80% of the technical skills and 20% of the domain knowledge would be ideal. Experience in solution delivery related to the financial risk domain is a strong plus.

Candidate Review & Selection

• Step Process: 2 rounds
• First round – mostly technical (45 minutes)
• Second round – discussion on personality and soft skills (30 minutes)