Overview
Senior System Analyst , DW / BI (Contract Position)
Number of Positions : 1 | Duration : 6 months initial contract
Location : Markham, ON, CA
Must be eligible to work in Canada
Hybrid position, 3+d / w onsite in Markham mandatory, no exceptions
Top required skills
- 8+ years’ experience as a System Analyst working on mid-large projects for data design, development, and implementation of business-critical enterprise data systems.
- Solid grasp / experience with data technologies & tools (Snowflake, Hadoop, PostgreSQL, Informatica, etc.)
- Outstanding knowledge and experience in ETL with Informatica product suite.
Roles and responsibilities
- Claims & Policy Data Analysis
Analyze structured and semi-structured data related to claims, policies, underwriting, and customer interactions.
- Identify patterns in claims frequency, fraud indicators, and loss ratios using Lakehouse datasets.
Support actuarial teams with data extracts and trend analysis.
- Segment customers based on behavior, risk profiles, and product usage.
- Analyze customer lifetime value, churn risk, and cross-sell / up-sell opportunities.
- Collaborate with risk and compliance teams to monitor exposure and regulatory thresholds.
- Regulatory & Compliance Reporting
Prepare data extracts and reports for regulatory bodies (e.g., OSFI, FSRA, NAIC).
- Ensure data lineage and traceability for audit and compliance purposes.
- Validate data accuracy and completeness for filings and disclosures.
Must have skills / experience / qualifications
- University degree in Computer Engineering or Computer Science.
- Minimum 8 years of experience successfully leading Data Systems Analysis in organizations building large-scale enterprise data assets.
- 8+ years’ experience as a System Analyst working on mid-large projects for data design, development, and implementation of business-critical enterprise data systems.
- Solid grasp / experience with data technologies & tools (Snowflake, Hadoop, PostgreSQL, Informatica, etc.).
- Outstanding knowledge and experience in ETL with Informatica product suite.
- Experience establishing documentation standards frameworks for data quality, data governance, stewardship and metadata management.
- Ability to foundationally understand complex business process driving technical systems.
- Strong leadership and influencing skills at the senior management level.
- Strong analytical, critical thinking and problem-solving skills.
- Strong stakeholder management.
- Solid understanding of Project and Program Management processes.
- Excellent verbal and written communication skills.
- Insurance knowledge is an asset.
Senioriry level
Employment type
Job function
Industries
- Insurance, IT Services and IT Consulting, and Financial Services
J-18808-Ljbffr