ERP Data Analyst designing Excel and SQL reporting solutions for Velixo’s ERP software customers. Demonstrating product capabilities, developing reports, and training clients, partners, and colleagues.
About the role
- Data Analyst building AWS data platforms and pipelines for Sun Life, a financial services and insurance company. Delivering governed analytics, reporting, and insights across business functions.
Responsibilities
- Design, develop, maintain, and optimize enterprise-grade ETL/ELT pipelines
- Ingest, transform, and integrate data from multiple internal and external sources
- Build and manage scalable, reliable, and secure data platforms, databases, and data warehouses
- Develop data modeling, transformation frameworks, and semantic layers for analytics, reporting, and operational applications
- Own data integration processes, including quality monitoring, validation, reconciliation, lineage tracking, and error handling
- Translate data requirements into scalable data solutions with business and technical stakeholders
- Drive best practices in architecture, governance, and performance optimization
- Design and maintain database schemas, indexing strategies, partitioning approaches, and query optimization techniques
- Implement and support cloud-based data solutions using AWS services
- Improve the enterprise data ecosystem through automation, CI/CD, infrastructure-as-code, and operational monitoring
Requirements
- 3–5 years of Data Engineering experience developing and supporting enterprise ETL/ELT pipelines, data integration processes, and automated workflows
- Degree in Computer Science, Mathematics, Statistics, or Engineering
- Strong SQL and database expertise, including relational and non-relational database design, schema development, query optimization, indexing, and performance tuning
- Advanced data modeling skills, including semantic, dimensional, and transformation models
- Hands-on AWS and modern data warehouse experience such as Snowflake, Redshift, or similar platforms
- Python and data integration experience across internal and external sources
- Ability to ensure data quality, governance, and reliability
- Expertise in mutual funds and market-based insurance products
- Strong problem-solving skills and ability to communicate complex methodologies to non-technical audiences
- Experience with Financial Services, Mutual Funds, ETFs, Segregated Funds, or Investment Operations preferred
- Experience with Airflow, AWS Glue, Step Functions, or similar orchestration and automation tools preferred
- Experience with Salesforce or other CRM platforms preferred
- Experience supporting CI/CD and DevOps practices for data platforms preferred
- Some travel may be required
- Extra hours may be required during quarter-end reporting periods and periods with high mutual fund trading volumes
- Reliability Status Clearance required
- Must account for activities if lived or travelled outside Canada for 6 consecutive months during the last 5 years as part of the Government of Canada clearance process
Benefits
- Hybrid work environment
- A friendly, collaborative, and inclusive culture
- 15 vacation days per year
- Flexible Benefits from the day you join to meet the needs of you and your family
- Pension, stock and savings programs to help build and enhance your future financial security
- The opportunity to move along a variety of career paths with amazing networking potential
- Access to our Global Learning Centre, available 24/7 for your learning needs
- Wellness programs that support the three pillars of your health – mental, physical and financial
- Incentive plans for eligible employees, subject to individual and company performance
- Accommodation in the application process for persons with disabilities
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
LP
Analyst, Data & Analytics
LinkedIn Recruiter Post
Canada Life seeks an Analyst, Data & Analytics to transform data into insights, build dashboards, and support business decisions in a hybrid Toronto or London, Ontario role.
LP
FinOps Data Analyst
LinkedIn Recruiter Post
Hiring FinOps Data Analyst for 1 - year contract in Toronto. Requires SQL, Excel, cloud cost analytics, and experience with AWS/Azure/GCP.
LP
Data Analyst
LinkedIn Recruiter Post
Hiring a Data Analyst for a hybrid contract role in Toronto. Requires 5+ years in data migration, strong SQL and Power BI, and experience with data quality and governance.
People Analytics Data Analyst helping Dropbox improve hiring through Talent Acquisition metrics and workforce insights. Partnering with People teams and leaders to analyze complex data, improve efficiency, quality, and equity.
LP
Fraud Data Analyst
LinkedIn Recruiter Post
Hiring a Fraud Data Analyst for a 12 - month contract in Toronto, ON. Requires 5+ years in data/analytics with fraud, AML, and threat detection experience.
LP
Data Entry Specialist
LinkedIn Recruiter Post
Hiring Data Entry Specialists for a 3 - month contract in GTA. Onsite, $19.45/hour, with paid training and no customer calls.
Senior Data Analyst building financial models and Looker dashboards for Jane’s healthcare practice management platform. Supporting Finance and Payments with trusted revenue, billing, and transaction insights.
Senior Data Analyst building AI - enabled Tableau analytics for Sun Life, a global financial services company. Developing trusted metrics, data models, dashboards, and sales insights.
Marketing data advisor analyzing and valorizing member/client data for Desjardins, North America's largest cooperative financial group. Developing dashboards, self - service reports and recommendations for marketing decisions.