Specialist - Data Engineering

Role Description Role Data Modeller Policy Claim Location Mississauga Ontario Onsite Primary Skill The IT Data Modeler is responsible for designing developing and maintaining enterprise data models that support insurance operations reporting analytics underwriting claims policy administration risk management and regulator reporting The role requires strong expertise in insurance data concepts relational database design data modelling methodologies and data governance practices Policy Administration Claims Management Underwriting Risk Exposure Premium Billing Coverage Endorsements Broker Customer Data Regulatory Reporting Experience in Years 5 years Must Have Skills Conceptual Logical Physical Data Modeling ER Modeling and Dimensional Modeling StarSnowflake Snowflake Database Design Normalization Denormalization Data Governance Metadata Management Data Quality ERStudio PowerDesigner Visio Secondary Nice To Have Skills NOT MANDATORY Policy Claims Billing Customer Broker Risk Coverage and Reinsurance domains Soft Skills Strong analytical thinking stakeholder management communication problem solving collaboration documentationand Agile delivery experience 3 Qualifying Questions 1Design conceptual logical and physical data models 2 Create models for Policy Claims Billing Customer Broker Risk Coverage and Reinsurance domains 3 Develop dimensional models for reporting and analytics 4 Maintain sourcetotarget mappings metadata and data dictionaries 5 Support database optimization data quality governance audit and compliance initiatives 6 Collaborate with Business Architecture Engineering and Analytics teams 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 [email protected] so that arrangements can be made for the appropriate accommodations to be in place.

The role involves designing, developing, and maintaining enterprise data models to support insurance operations, reporting, and analytics. Key tasks include creating dimensional models and maintaining source-to-target mappings and data dictionaries.

Candidates must have 5 years of experience in data modeling and expertise in relational database design and data governance. Proficiency in tools like ERStudio, PowerDesigner, and Snowflake is required.

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

• Stakeholder ManagementPreferred

Identified from the job description. Confirm important requirements above.

• Conceptual Data Modeling
• Logical Data Modeling
• Physical Data Modeling
• ER Modeling
• Dimensional Modeling
• Snowflake Database Design
• Normalization
• Denormalization
• Data Governance
• Metadata Management
• Data Quality
• ERStudio
• PowerDesigner
• Visio
• Agile Delivery
• Stakeholder Management

• Data & Analytics
• Technology
• Engineering
• Consulting
• Software

Minimum experience

5+ years

Apply by

Feb 27, 2027

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level