Analyzes data management requirements for ETL/ELT pipelines, integrations, and data warehouse models without developing pipelines. Defines business rules and data exchange contracts, facilitates workshops, models processes, performs impact analysis, supports Agile/SAFe backlogs, develops test strategies, and leads UAT. Insurance domain experience is preferred, particularly in individual insurance, savings, or retirement products.
Mandate Overview:
- The client is looking for a business analyst who has worked
close to data flows: ETL/ELT pipelines, integration of various sources, data
warehouse modelling. She does not build the pipelines: she defines what they
must deliver and writes the business rules the delivery team turns into code.
It remains a full analysis role, with workshop facilitation, process modelling
(BPMN, UML), impact analysis, backlog input, test strategy and UAT. Data
management comes first: it is the skill that separates candidates. Knowledge of
the individual insurance domain completes the profile. The delivery framework
is SAFe/Agile, with a Lean approach.
- Candidate sought: a business analyst with at least 5
years of experience, including recent engagements on a data warehouse or data
platform, who has written business rules and data exchange contracts and led
UAT. Experience in individual insurance, savings or retirement puts the
candidate at the top of the list.
Requirements
Required:
- Experience in data management
- Experience designing, managing and optimizing ETL/ELT
pipelines and integrating data across various sources
- Good understanding of data warehousing concepts (Data Vault,
Kimball, star schemas, OLAP, tabular)
- Excellent understanding of test management and validation
processes (UAT)
- Good knowledge of the individual insurance domain
Preferred:
- Knowledge of SAFe/Agile and Lean
- Knowledge of business process analysis methods (BPMN, UML,
etc.)
Asset:
- Knowledge of insurance products, administrative systems and
business processes (major asset)
- Prior experience in the insurance sector
- SAFe, PMI or LOMA certification
- Knowledge of DevOps, Leankit, Hopex, Power BI
Profiles to Exclude:
- Data developer or engineer resume showing no analysis
activity (requirements gathering, workshops, business rules writing).
- Business analyst with no engagement involving a data
warehouse, an integration or data pipelines.
- Data experience limited to reporting or dashboards, with no
work on data flows or models.
- No participation in user acceptance testing (UAT) mentioned
in the resume.
- Less than 5 years of relevant experience.
Similar Jobs
Cloud • Security • Software • Cybersecurity • Automation
Lead the SSCS Add-On engineering team to develop security capabilities, managing delivery, team growth, and quality in a collaborative environment.
Top Skills:
Ci/CdDevsecopsSigstoreSlsa
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Manage end-to-end deployment and adoption of Samsara’s IoT solutions for mid-market customers. Create launch plans, track implementation progress and account health, deliver training and product demonstrations, define business outcomes and KPIs, and resolve challenges while coordinating with Sales, Support, Sales Engineering, Product, executives, and end users.
Top Skills:
Ai ToolsAutomationCloud SoftwareControl SystemsIotNetworkingPythonRestful ApisTelematics
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Owns US engagement and growth strategy for Afterpay, Cash App commerce, and lending products. Leads lifecycle marketing, cross-sell, incentives, experimentation, product launches, and AI-enabled automation. Partners cross-functionally with Product, Analytics, Martech, Creative, Brand, and business leadership; sizes opportunities, builds impact models, sets multi-quarter roadmaps, and optimizes for active customers and gross profit.
Top Skills:
BrazeClaude CodeGooseHightouchIterableSalesforce Marketing CloudSQL
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal



