Senior DSA - Data Systems Analyst

A leading, forward-thinking Canadian insurance organization is embarking on an ambitious Digital Transformation initiative to modernize and build its next-generation data platform. We are seeking a collaborative, resourceful, and high-performing Senior Data Systems Analyst (DSA) to join our Information Technology Data Delivery Group.

In this role, you will lead the data systems analysis team, helping to scale our data and analytics capabilities while acting as a vital liaison between various business units and technical data teams. You will apply your deep expertise to requirements, documentation, data analysis, and solution architecture, establishing a center of excellence for our data ecosystem artifacts. This is a unique opportunity to help shape the data mindset that enables direct-to-consumer business, advanced data science capabilities, and an expanded digital footprint.

Advantages
Impactful Work: Contribute directly to a high-visibility, next-generation data platform modernization project.

Professional Growth: Collaborate alongside experienced leaders and cross-functional teams driving meaningful corporate change.

Innovative Culture: Work within an environment that actively challenges the status quo and values efficient, simplified processes and workflows.

Collaborative Environment: Join a high-performing, supportive team dedicated to excellence and community.

Responsibilities
1. 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.

2. Customer & Risk Insights
Segment customers based on behavior, risk profiles, and product usage.

Analyze customer lifetime value, churn risk, and cross-sell/up-sell opportunities.

Collaborator with risk and compliance teams to monitor exposure and regulatory thresholds.

3. 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.

4. Data Wrangling & Preparation
Clean and transform raw data from diverse sources (e.g., policy admin systems, CRM, claims systems) into analytics-ready formats.

Leverage lakehouse tools (e.g., Delta Lake, Apache Iceberg) to manage versioned and time-travel datasets.

Collaborate with data engineers to ensure efficient ETL/ELT processes.

5. Business Intelligence & Visualization
Build dashboards and visualizations for underwriting, claims, finance, and product teams using tools like Power BI, Tableau, or Qlik.

Enable self-service analytics by creating reusable datasets and semantic layers.

6. Data Quality & Governance
Profile and validate data to ensure consistency across policy, claims, and financial domains.

Tag and catalog datasets using metadata tools (e.g., Unity Catalog, Collibra).

Support master data management and reference data initiatives.

7. Collaboration & Stakeholder Engagement
Work with actuaries, underwriters, product managers, and IT teams to translate business questions into analytical queries and data models.

Document business logic, assumptions, and data definitions clearly.

8. Predictive & Advanced Analytics Support
Assist data scientists with feature engineering, exploratory data analysis, and historical data extracts for model training.

Interpret model outputs and integrate them into business reporting.

Qualifications
Education: University degree in Computer Engineering, Computer Science, or a related field.

Leadership Experience: Minimum 5 years of experience successfully leading Data Systems Analysis organizations with expertise in building large-scale enterprise data assets.

BA Experience: 8+ years of experience as a Business Analyst working on mid-to-large projects for data design, development, and implementation of business-critical enterprise data systems.

Technical Skills: * Strong data analysis skills with a very strong SQL background.

Deep background in ETL/Data engineering and outstanding knowledge/experience with the Informatica product suite.

Solid grasp and experience with data technologies and environments (Snowflake, Hadoop, PostgreSQL, Data Warehouses, and Data Lakes/Lakehouses).

Governance Standards: Experience establishing documentation standards frameworks for data quality, data governance, stewardship, and metadata management.

Soft Skills: Strong analytical, critical thinking, problem-solving, stakeholder management, and leadership/influencing skills at the senior management level. Excellent verbal and written communication skills.

Domain Knowledge: Insurance industry knowledge is considered a strong asset.

Project Methodology: Solid understanding of Project and Program Management processes.

Summary
Role Title: Senior Data Systems Analyst (Senior DSA)

Location: Markham, ON (Hybrid — Minimum of 3 days per week on-site)

Hours: Standard work week, with flexibility required for occasional extended hours to support critical project milestones and deliverables.

Core Mandate: Act as the technical bridge between business and data delivery teams to modernize a next-generation enterprise data platform.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.