Senior Data Systems Analyst
Share
Job Location:
Monthly Salary:
Posted on:
14 hours ago
Vacancies:
1 Vacancy
Job Summary
Senior Data Systems Analyst
Support large-scale enterprise data initiatives within a fast-evolving insurance environment focused on analytics ETL SQL and modern data platforms. This hybrid role offers the opportunity to work on high-impact digital transformation projects collaborate with experienced technical and business teams and contribute to advanced data solutions driving business performance and innovation.
What is in it for you:
Salaried: $85-95 per hour.
Incorporated Business Rate: $100-110 per hour.
4-month contract.
Hybrid role requiring 3 days on-site in Markham subject to change.
Daytime schedule of 37.5 hours per week.
Flexibility to work additional hours as needed to support project deliverables.
Responsibilities:
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 and up-sell opportunities.
Collaborate with risk and compliance teams to monitor exposure and regulatory thresholds.
Prepare data extracts and reports for regulatory bodies.
Ensure data lineage and traceability for audit and compliance purposes.
Validate data accuracy and completeness for filings and disclosures.
Clean and transform raw data from diverse sources into analytics-ready formats.
Leverage lakehouse tools to manage versioned and time-travel datasets.
Collaborate with data engineers to support ETL and ELT processes.
Build dashboards and visualizations for underwriting claims finance and product teams.
Present insights using business intelligence and visualization tools.
Enable self-service analytics through reusable datasets and semantic layers.
Profile and validate data to ensure consistency across policy claims and financial domains.
Support metadata management data governance stewardship and master data initiatives.
Work closely with actuaries underwriters product managers and IT teams to understand business data needs.
Translate business requirements into analytical queries and data models.
Document business logic assumptions and data definitions.
Assist data scientists with feature engineering and exploratory data analysis.
Provide historical data extracts for model training and validation.
Interpret analytical model outputs and integrate findings into business reporting.
Lead data systems analysis activities supporting enterprise-scale data assets and analytics capabilities.
What you will need to succeed:
University degree in Computer Engineering or Computer Science.
5 years of experience leading Data Systems Analysis organizations with expertise in large-scale enterprise data assets.
8 years of experience as a Business Analyst on mid-to-large-scale projects involving enterprise data systems design development and implementation.
Strong data analysis skills with advanced SQL expertise.
Strong ETL and data engineering background.
Experience working in data warehouse and data lake environments.
Solid experience with data technologies and tools including Snowflake Hadoop PostgreSQL and Informatica.
Outstanding knowledge and hands-on experience with ETL processes using the Informatica product suite.
Experience establishing documentation standards and frameworks for data quality governance stewardship and metadata management.
Strong understanding of complex business processes supporting technical systems.
Strong leadership and influencing skills with senior management stakeholders.
Strong analytical critical thinking and problem-solving skills.
Strong stakeholder management skills.
Solid understanding of project and program management processes.
Excellent verbal and written communication skills.
Insurance industry knowledge is considered an asset.
Why Recruit Action
Recruit Action (agency permit: AP-2504511) provides recruitment services through quality support and a personalized approach. As part of the screening process some applications may be reviewed using artificial intelligence tools. Only candidates who meet the hiring criteria will be contacted.
Required Skills:
