Data System Analyst

Job Description

<p><h3>Overview</h3><p>Position: Data Systems Analyst</p><p>Location: Markham (3 days/week in-office, mandatory)</p><p>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.</p><h3>What You’ll Do</h3><ul><li>Claims & Policy Data Analysis: Analyze structured and semi-structured data in claims, policies, underwriting, and customer interactions.</li><li>Identify patterns in claims frequency, fraud indicators, and loss ratios using lakehouse datasets.</li><li>Support actuarial teams with data extracts and trend analysis.</li><li>Customer & Risk Insights: Segment customers based on behavior, risk profiles, and product usage.</li><li>Analyze customer lifetime value, churn risk, and cross-sell/up-sell opportunities.</li><li>Collaborate with risk and compliance teams to monitor exposure and regulatory thresholds.</li><li>Regulatory & Compliance Reporting: Prepare data extracts and reports for regulatory bodies (OSFI, FSRA, NAIC).</li><li>Ensure data lineage and traceability for audit and compliance.</li><li>Validate data accuracy and completeness for filings and disclosures.</li><li>Data Wrangling & Preparation: Clean and transform raw data from sources like policy admin systems, CRM, and claims systems into analytics-ready formats.</li><li>Leverage lakehouse tools (Delta Lake, Apache Iceberg) for versioned and time-travel datasets.</li><li>Work with data engineers to ensure efficient ETL/ELT processes.</li><li>Business Intelligence & Visualization: Build dashboards and visualizations for underwriting, claims, finance, and product teams using tools like Power BI, Tableau, or Qlik.</li><li>Enable self-service analytics by creating reusable datasets and semantic layers.</li><li>Data Quality & Governance: Profile and validate data to ensure consistency across policy, claims, and financial domains.</li><li>Utilize metadata tools like Unity Catalog and Collibra to tag and catalog datasets.</li><li>Support master data management and reference data initiatives.</li><li>Collaboration & Stakeholder Engagement: Work with actuaries, underwriters, product managers, and IT teams to understand data needs.</li><li>Translate business questions into analytical queries and data models.</li><li>Document business logic, assumptions, and data definitions.</li><li>Predictive & Advanced Analytics Support: Assist data scientists with feature engineering and exploratory data analysis.</li><li>Provide historical data extracts for model training and validation.</li><li>Interpret model outputs and integrate them into business reporting.</li></ul><h3>What You’ll Bring</h3><ul><li>University degree in Computer Engineering or Computer Science.</li><li>5+ years leading Data Systems Analysis in large-scale enterprise data projects.</li><li>8+ years as a Business Analyst with experience in data design, development, and implementation of critical enterprise systems.</li><li>Expertise with data technologies & tools such as Snowflake, Hadoop, PostgreSQL, Informatica.</li><li>Extensive experience in ETL processes, particularly with Informatica.</li><li>Proven ability in data governance, data stewardship, and metadata management.</li><li>Strong understanding of complex business processes driving technical systems.</li><li>Leadership and influencing skills at the senior management level.</li><li>Strong analytical and critical thinking abilities.</li><li>Excellent communication skills, both verbal and written.</li><li>Insurance knowledge is a plus.</li></ul><h3>Why Join Us?</h3><ul><li>Collaborative and dynamic environment</li><li>Competitive compensation and benefits</li><li>Opportunity to work with cutting-edge technologies</li><li>Great work-life balance with hybrid work options</li></ul><p>#DataSystemsAnalyst #DataAnalysis #ETL #Lakehouse #PowerBI #Tableau #Snowflake #Informatica #DataGovernance #DataScience #BusinessIntelligence #RiskManagement #DataWrangling #InsuranceTech #JobOpening #Hiring #MarkhamJobs</p></p>
#J-18808-Ljbffr