Data Management Business Analyst
Maarut Montreal, Quebec, Canada
Software Development · 11-50 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
The business analyst will define data delivery requirements and write business rules for ETL/ELT pipelines and data warehouse modeling. Responsibilities include workshop facilitation, process modeling, impact analysis, backlog management, and leading user acceptance testing.
What they look for
Requirements
Candidates must have at least 5 years of experience in data management, specifically with data platforms, ETL/ELT pipelines, and data warehousing. A strong understanding of the individual insurance domain and experience with SAFe/Agile methodologies are highly preferred.
Full description
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 roles
-
Senior Technical Business Analyst (Customer Identity & Access Management)
NCS Australia Sydney, New South Wales, Australia
-
Business Analyst
DHL Customer Support (Costa Rica) S.A. La Asunción, Belén, Costa Rica
-
Senior Data Business Analyst
VBP City of Cebu, Cebu, Philippines
-
Senior Business Analyst - Presales
Simform - Product Engineering Company Ahmedabad, Gujarat, India
-
Senior Business Analyst
Auxiant Cedar Rapids, Iowa, United States
-
Business Analyst - Debit & Payments
FIS Global Milwaukee, Wisconsin, United States