Data Systems Analyst

LTM; Markham; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Comprehensive Medical Plan

Health Care Spending Account

Short/Long-Term Disability

Life Insurance

Annual vacation and leave

Maternity Leave Top Up Pay

Job summary

LTIMindtree Canada is seeking a Data Systems Analyst to lead data systems analysis and build enterprise data assets in a hybrid Markham-based role. You will design, implement and govern data pipelines for analytics across underwriting, claims, finance and product teams.

You should bring 8+ years of Business Analysis and data leadership, strong SQL, lakehouse/Delta Lake expertise, and experience with ETL using Informatica. Insurance domain knowledge is a plus.

Qualifications

• 8 years of experience as a Business Analyst or data leader on mid-to-large data projects.
• Proven track record building enterprise data assets and data systems.
• Strong SQL and data warehousing knowledge, especially lakehouse technologies.
• Insurance domain knowledge (billing, policy, claims) is an asset.
• Experience with ETL/ELT using Informatica and related data tools.

Responsibilities

• Lead data systems analysis with enterprise-scale data assets.
• Build dashboards for underwriting, claims, finance and product teams.
• Create reusable datasets and semantic layers for self-service analytics.
• Collaborate with data engineers on ETL/ELT processes.
• Tag/catalog datasets using metadata tools and support data governance.

Skills

SQL

Lakehouse

Informatica

ETL/ELT

PostgreSQL

Tableau

Power BI

Qlik

Unity Catalog

Delta Lake

Collibra

Tableau / BI tools

Data governance

MDM / reference data

Snowflake

Apache Iceberg

Hadoop

Leadership

Data quality

Tools

Informatica

Power BI

Qlik

Unity Catalog

Delta Lake

Tableau

Snowflake

Collibra

Apache Iceberg

Job description

Working model Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu Fri

Primary Skills

Minimum 5 years of experience successfully leading Data Systems Analysis organizations with expertise in building largescale enterprise data assets

8 years experience as a Business Analyst working on midlarge projects for data design development and implementation of businesscritical enterprise data

systems

Very strong SQL background

Strong knowledge on data warehousing especially on data lake house

Background on Insurance knowledge such as billing policy claims etc

Solid graspexperience with data technology tools like PostgreSQL Informatica

Outstanding knowledge and experience in ETL with Informatica product suite

Experience establishing documentation standards frameworks for data quality data governance stewardship and metadata management

Clean and transform raw data from diverse sources eg policy admin systems CRM claims systems into analyticsready formats

Leverage lakehouse tool Delta Lake to manage versioned and timetravel datasets

Collaborate with data engineers to ensure efficient ETLELT processes

Build dashboards and visualizations for underwriting claims finance and product teams

Use tools like Power BI or Qlik to present insights from lakehouse data

Enable selfservice analytics by creating reusable datasets and semantic layers

Profile and validate data to ensure consistency across policy claims and financial domains

Tag and catalog datasets using metadata tool Unity Catalog

Support master data management and reference data initiatives

Solid understanding of Project and Program Management processes

Insurance knowledge an asset

Secondary Skills

Ability to foundationally understand complex business process driving technical systems

Good graspexperience with data technology tools such as Snowflake Hadoop

Experience in leveraging lakehouse tool Apache Iceberg

Knowledge of Tagging and catalog datasets using metadata tool Collibra

Exposure of Tableau to present insights from lakehouse data

Strong leadership and influencing skills at the senior management level

Strong analytical critical thinking and problemsolving skills

Soft Skills

Excellent written and verbal communication skills

Strong ability to work with client stakeholders

Questions

Do you know the difference between data lake house and data warehouse YesNo

Do you have hands On ETL Experience on Informatica Enterprise ETL YesNo

Have you worked on different types of transformations for loading data from source systems into a target table YesNo

Have you worked on any of the insurance data domains like policy claims billing finance YesNo

Have you done reporting or analytics once data is available in a lake house YesNo

Vacancy Type: New Vacancy

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree Canada ("LTIMC"):>

Benefits and Perks:

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Health Care Spending Account
• Short Term and Long-Term Disability Coverage
• Life Insurance
• Annual vacation and other Paid Leaves
• Maternity Leave Top Up Pay

The range displayed on each job posting reflects the total compensation range for the position across all Canada locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Role description

Role Data Systems Analyst

Experience 8 Years

Location Canada Client location Markham Office

Working model Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu Fri

Primary Skills

Minimum 5 years of experience successfully leading Data Systems Analysis organizations with expertise in building largescale enterprise data assets

8 years experience as a Business Analyst working on midlarge projects for data design development and implementation of businesscritical enterprise data

systems

Very strong SQL background

Strong knowledge on data warehousing especially on data lake house

Background on Insurance knowledge such as billing policy claims etc

Solid graspexperience with data technology tools like PostgreSQL Informatica

Outstanding knowledge and experience in ETL with Informatica product suite

Experience establishing documentation standards frameworks for data quality data governance stewardship and metadata management

Clean and transform raw data from diverse sources eg policy admin systems CRM claims systems into analyticsready formats

Leverage lakehouse tool Delta Lake to manage versioned and timetravel datasets

Collaborate with data engineers to ensure efficient ETLELT processes

Build dashboards and visualizations for underwriting claims finance and product teams

Use tools like Power BI or Qlik to present insights from lakehouse data

Enable selfservice analytics by creating reusable datasets and semantic layers

Profile and validate data to ensure consistency across policy claims and financial domains

Tag and catalog datasets using metadata tool Unity Catalog

Support master data management and reference data initiatives

Solid understanding of Project and Program Management processes

Insurance knowledge an asset

Secondary Skills

Ability to foundationally understand complex business process driving technical systems

Good graspexperience with data technology tools such as Snowflake Hadoop

Experience in leveraging lakehouse tool Apache Iceberg

Knowledge of Tagging and catalog datasets using metadata tool Collibra

Exposure of Tableau to present insights from lakehouse data

Strong leadership and influencing skills at the senior management level

Strong analytical critical thinking and problemsolving skills

Soft Skills

Excellent written and verbal communication skills

Strong ability to work with client stakeholders

Questions

Do you know the difference between data lake house and data warehouse YesNo

Do you have hands On ETL Experience on Informatica Enterprise ETL YesNo

Have you worked on different types of transformations for loading data from source systems into a target table YesNo

Have you worked on any of the insurance data domains like policy claims billing finance YesNo

Have you done reporting or analytics once data is available in a lake house YesNo

Other details

Vacancy Type: New Vacancy

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree Canada ("LTIMC"):>

Benefits and Perks:

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Health Care Spending Account
• Short Term and Long-Term Disability Coverage
• Life Insurance
• Annual vacation and other Paid Leaves
• Maternity Leave Top Up Pay

The range displayed on each job posting reflects the total compensation range for the position across all Canada locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Accessibility and Reasonable Accommodation: LTIMindtree has an accommodation process in place and provides accommodations for applicants with disabilities. If you require a specific accommodation because of a disability or a medical need, please write to us at [e-mail] so that arrangements can be made for the appropriate accommodations to be in place.