Technical Business Analyst/Data

MANTU GROUP SA; Toronto; On-site; CAD 60,000 - 100,000; Full time

Job summary

An innovative consulting firm is looking for a skilled Technical Business Analyst to bridge the gap between business needs and technical solutions in data-centric projects within the insurance sector. This role is crucial for supporting data warehouse and integration initiatives, requiring strong analytical skills and hands-on data experience. You will lead workshops, document business requirements, and work closely with development teams to ensure successful project outcomes. If you're a clear communicator with a passion for data and problem-solving, this is the perfect opportunity to make a significant impact in a dynamic environment.

Qualifications

• 4-6 years of business analysis experience, especially in the insurance sector.
• Strong knowledge of relational data modeling and data warehouse architectures.
• Clear communicator with agile methodology experience.

Responsibilities

• Lead workshops to gather business requirements and document them.
• Define data mappings and maintain documentation for stakeholders.
• Support development teams with technical analysis and QA processes.

Skills

Business Analysis

Data Modeling

ETL Processes

PL/SQL

Data Profiling

Agile Methodologies

Stakeholder Communication

Tools

Azure Databases

Job description

Who are we?

Amaris Consulting is an independent technology consulting firm providing guidance and solutions to businesses. With more than 1,000 clients across the globe, we have been implementing solutions in major projects for over a decade. Our international team of 7,600 professionals spans 5 continents and over 60 countries. We focus on four Business Lines: Information System & Digital, Telecom, Life Sciences, and Engineering. We are committed to building a top talent community where team members can reach their full potential. Amaris is your stepping stone to navigate change, meet challenges, and successfully complete your projects.

Our recruitment process aims to provide the best experience for candidates. We get to know our candidates, challenge them, and provide prompt feedback. The process includes:

Brief Call: An initial virtual or phone conversation to learn about you, understand your motivations, and find the right role.

Interviews: Typically around 3 interviews with team members, including your potential line manager, to discuss your experience, skills, the role, and our company culture.

Case Study: Depending on the role, you may be asked to complete a test or scenario relevant to the position.

We recognize that each candidate and role is unique, and we adapt our process accordingly to ensure a positive experience. We look forward to meeting you!

Job Description

We are seeking a skilled Technical Business Analyst to bridge business needs and technical solutions in data-centric projects, especially within the insurance sector. The ideal candidate will have strong analytical skills, hands-on data experience, and excellent communication abilities to support data warehouse and integration initiatives.

Key Responsibilities:

Business Analysis and Requirements Gathering

• Organize and lead workshops to gather and document business requirements.
• Conduct impact assessments and effort estimations for prioritization.
• Collaborate with Product Owners to define product backlogs and write clear User Stories for development and QA teams.

Data Analysis and Solution Design

• Define data mappings across Data Warehouse layers.
• Document business rules to support KPIs and reporting needs.
• Create detailed source-to-target mappings for data integration.
• Maintain up-to-date documentation for stakeholders.

Technical Coordination and Support

• Support development teams with technical analysis.
• Assist in QA, acceptance testing, and validation processes.
• Coordinate test planning, execution, and result validation.

Stakeholder Communication and Collaboration

• Work closely with business experts, IT teams, and managers to align on integration needs.
• Lead workshops to document existing systems and identify optimization opportunities.
• Communicate project updates and manage stakeholder expectations.
• Act as an alternate point of contact within agile teams.

Profile Requirements:

Qualifications and Skills

Technical and Industry Expertise

• 4–6 years of business analysis experience.
• Strong knowledge of relational data modeling (Data Vault, 3NF, Dimensional).
• Deep understanding of data warehouse architectures and ETL processes.
• Proficient in Azure databases and advanced PL/SQL.
• Experience in data integration within the insurance industry.
• Skilled in writing technical requirements for data ingestion pipelines.
• Strong data profiling capabilities.

Professional Skills

• Clear communicator with the ability to simplify technical topics for non-technical audiences.
• Experience with agile methodologies (Scrum, Kanban).
• Highly organized, adaptable, and comfortable with ambiguity.
• Self-motivated leader with problem-solving skills.
• Team-oriented with strong relationship-building abilities.

Personal Attributes

• Innovative and forward-thinking.
• Analytical, detail-oriented, and curious.
• Able to balance big-picture thinking with operational details.