Data System Analyst

HRC Global Services; Markham; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A progressive technology services firm in Markham is seeking a Data Systems Analyst to join their team. The ideal candidate will collaborate with multiple stakeholders and use advanced data analysis techniques and tools to provide insights. Strong experience in ETL processes, data governance, and business intelligence is essential. This position offers competitive compensation, a dynamic working environment, and hybrid work options.

Benefits

Collaborative and dynamic environment

Competitive compensation and benefits

Opportunity to work with cutting-edge technologies

Great work-life balance with hybrid work options

Qualifications

• 5+ years leading Data Systems Analysis in large-scale enterprise data projects.
• 8+ years as a Business Analyst with experience in data design, development, and implementation.
• Strong understanding of complex business processes driving technical systems.

Responsibilities

• Analyze structured and semi-structured data in claims, policies, and customer interactions.
• Support actuarial teams with data extracts and trend analysis.
• Build dashboards and visualizations for various teams using tools like Power BI and Tableau.

Skills

Data analysis

ETL processes

Data governance

Communication skills

Analytical thinking

Education

University degree in Computer Engineering or Computer Science

Tools

Snowflake

Hadoop

PostgreSQL

Informatica

Job description

Overview

Position: Data Systems Analyst

Location: Markham (3 days/week in-office, mandatory)

We’re looking for a Data Systems Analyst to join our Information Technology Data Delivery Group in a dynamic and fast-paced environment. In this role, you\'ll collaborate with a high-performing team to build a center of excellence for data ecosystem artifacts, including data creation, maintenance, and project requirements. Your expertise will be vital in areas such as requirements gathering, infrastructure management, and solution documentation.

What You’ll Do

• Claims & Policy Data Analysis: Analyze structured and semi-structured data in 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.
• 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.
• Collaborate with risk and compliance teams to monitor exposure and regulatory thresholds.
• Regulatory & Compliance Reporting: Prepare data extracts and reports for regulatory bodies (OSFI, FSRA, NAIC).
• Ensure data lineage and traceability for audit and compliance.
• Validate data accuracy and completeness for filings and disclosures.
• Data Wrangling & Preparation: Clean and transform raw data from sources like policy admin systems, CRM, and claims systems into analytics-ready formats.
• Leverage lakehouse tools (Delta Lake, Apache Iceberg) for versioned and time-travel datasets.
• Work with data engineers to ensure efficient ETL/ELT processes.
• 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.
• Data Quality & Governance: Profile and validate data to ensure consistency across policy, claims, and financial domains.
• Utilize metadata tools like Unity Catalog and Collibra to tag and catalog datasets.
• Support master data management and reference data initiatives.
• Collaboration & Stakeholder Engagement: Work with actuaries, underwriters, product managers, and IT teams to understand data needs.
• Translate business questions into analytical queries and data models.
• Document business logic, assumptions, and data definitions.
• Predictive & Advanced Analytics Support: Assist data scientists with feature engineering and exploratory data analysis.
• Provide historical data extracts for model training and validation.
• Interpret model outputs and integrate them into business reporting.

What You’ll Bring

• University degree in Computer Engineering or Computer Science.
• 5+ years leading Data Systems Analysis in large-scale enterprise data projects.
• 8+ years as a Business Analyst with experience in data design, development, and implementation of critical enterprise systems.
• Expertise with data technologies & tools such as Snowflake, Hadoop, PostgreSQL, Informatica.
• Extensive experience in ETL processes, particularly with Informatica.
• Proven ability in data governance, data stewardship, and metadata management.
• Strong understanding of complex business processes driving technical systems.
• Leadership and influencing skills at the senior management level.
• Strong analytical and critical thinking abilities.
• Excellent communication skills, both verbal and written.
• Insurance knowledge is a plus.

Why Join Us?

• Collaborative and dynamic environment
• Competitive compensation and benefits
• Opportunity to work with cutting-edge technologies
• Great work-life balance with hybrid work options

#DataSystemsAnalyst #DataAnalysis #ETL #Lakehouse #PowerBI #Tableau #Snowflake #Informatica #DataGovernance #DataScience #BusinessIntelligence #RiskManagement #DataWrangling #InsuranceTech #JobOpening #Hiring #MarkhamJobs