Data Warehouse Business Systems Analyst with Insurance Domain Expertise

3 days ago


Vaughan, Ontario, Canada CAA Club Group Full time

Position Overview

The ideal candidate will possess a strong background in data analysis and business systems, with a focus on the insurance industry. This role will involve working closely with stakeholders to identify business requirements and develop strategies for improving existing systems.

Key Responsibilities

  • Meet with decision makers, systems owners, and business users to define business and operations requirements and systems goals, and identify and resolve systems issues.
  • Lead design sessions in prototyping new systems for the purpose of enhancing business processes, operations, and information process flow.
  • Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
  • Identify and establish scope and parameters of systems analysis in order to define outcome criteria and measure-taking actions.
  • Design and implement short-term tactical plans for managing and maintaining corporate systems and software.
  • Ensure that proposed and existing systems architectures are aligned with organizational goals and objectives.
  • Ensure compatibility and interoperability of in-house computing systems.
  • Meet with business users to gather, analyze, produce, validate, and obtain approval of the Business Requirements Specification.
  • Model business and systems processes based on findings through use case scenarios, workflow diagrams, and data models.
  • Monitor the data warehouse environment for data quality issues involving daily/monthly loads.
  • Perform cross-validation between source applications and data warehouse and/or business intelligence tools to check for consistency and reliability between source and destination.
  • Participate with the business in preparation of the cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.
  • Create systems models, business requirement specifications, diagrams, and charts to provide direction to Application Developers.
  • Coordinate definition of test cases for Quality Assurance and UAT.
  • Provide orientation and training, including creation of training material, to business users for all modified and new systems.

Requirements

  • College diploma or university degree in the field of business administration, computer science, or management information systems.
  • 5+ years work experience in the Insurance industry & 5+ years work experience as a business analyst.
  • Guidewire experience is an asset.
  • 5 years of experience with hands-on business and data analysis in data warehousing and with leading enterprise data warehousing projects throughout the project life cycle.
  • Knowledge of data modeling techniques, database design, and concepts is mandatory.
  • Working technical knowledge of SQL programming languages including relational databases and an understanding of ETL processes and tools.
  • Proficient in writing SQL queries and to understand technical specifications to ensure proposed solutions meet business requirements.
  • Experience with design, development, and support of business intelligence tools such as Qlikview, Tableau, or Power BI for enterprise data warehouse.
  • Proven experience in overseeing the design, development, and implementation of software and hardware solutions, systems, or products.
  • Working knowledge of network and PC operating systems, including Windows platforms.
  • Working knowledge of current network hardware, protocols, and standards.
  • Extensive practical knowledge in importing data for use in report software, spreadsheets, graphs, and flow charts.
  • Extensive experience with core software applications, including Policy Management Systems, Microsoft Office Suite, Microsoft Visio, and Microsoft Project Professional.
  • Proven experience in the operation and analysis of database hardware, software, and standards, as well as data retrieval methodologies and mainframe applications.


  • Vaughan, Ontario, Canada CAA Club Group Full time

    Position OverviewThe ideal candidate will possess a strong background in business analysis, data warehousing, and insurance industry experience. As a Business Systems Analyst, you will be responsible for leading the design and implementation of data warehouse solutions that meet the business needs of CAA Club Group.Key ResponsibilitiesMeet with stakeholders...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    Position OverviewThe ideal candidate will possess a strong background in business analysis, data warehousing, and insurance industry experience. As a Business Systems Analyst, you will be responsible for leading the design and implementation of data warehouse solutions that meet the business needs of CAA Club Group.Key ResponsibilitiesMeet with stakeholders...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    About the Role As a Data Warehouse Business Systems Analyst with a focus on the Insurance industry, you will play a crucial role in shaping and optimizing our data-driven strategies. You'll collaborate closely with stakeholders across various departments to understand their needs, analyze existing systems, and design innovative solutions that enhance...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    Position OverviewThe ideal candidate will possess a strong background in business analysis, data warehousing, and insurance industry experience. As a Business Systems Analyst, you will be responsible for leading the design and implementation of business systems and software solutions that meet the needs of our organization.Key ResponsibilitiesMeet with...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    Position OverviewThe ideal candidate will possess a strong background in business analysis, data warehousing, and insurance industry experience. As a Business Systems Analyst, you will be responsible for leading the design and implementation of business systems and software solutions that meet the needs of our organization.Key ResponsibilitiesMeet with...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    Position OverviewThe ideal candidate will possess a strong background in business analysis, data warehousing, and insurance industry experience. As a Business Systems Analyst, you will be responsible for leading the design and implementation of business systems and software solutions that meet the needs of CAA Club Group.Key ResponsibilitiesMeet with...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    Position OverviewThe ideal candidate will possess a strong background in business analysis, data warehousing, and insurance industry experience. As a Business Systems Analyst, you will be responsible for leading the design and implementation of business systems and software solutions that meet the needs of CAA Club Group.Key ResponsibilitiesMeet with...


  • Vaughan, Ontario, Canada Trinity Financial Services Inc. Full time

    {"h2": "Business Systems Analyst Job Description", "ul": [{"li": "As a Business Systems Analyst at Trinity Financial Services Inc., you will be responsible for identifying business requirements and designing, developing, and implementing information systems business solutions that meet those needs."}, {"li": "You will work closely with clients to understand...


  • Vaughan, Ontario, Canada Trinity Financial Services Inc. Full time

    {"h2": "Business Systems Analyst Job Description", "ul": [{"li": "As a Business Systems Analyst at Trinity Financial Services Inc., you will be responsible for identifying business requirements and designing, developing, and implementing information systems business solutions that meet those needs."}, {"li": "You will work closely with clients to understand...


  • Vaughan, Ontario, Canada GFL Environmental Full time

    **Job Summary**As a Business Analyst at GFL Environmental, you will play a critical role in driving business growth and improvement by leveraging data-driven insights and analytical expertise. This position requires a unique blend of business acumen, technical skills, and interpersonal abilities to support business decision-making and process...


  • Vaughan, Ontario, Canada ADVERTEK INC. Full time

    Position OverviewAs a Business Systems Analyst at ADVERTEK INC., you will play a crucial role in enhancing our information systems to meet business needs. This is a permanent position requiring a commitment of 35 to 40 hours per week.QualificationsEducation: Bachelor's degreeExperience: 2 to 3 years in a relevant fieldWork EnvironmentHelp desk...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    CAA Club Group is seeking a highly motivated and experienced Business Systems Analyst to join our team. In this role, you will play a crucial part in identifying solutions to complex business challenges and ensuring the seamless operation of our enterprise systems. Your expertise will be instrumental in driving innovation and enhancing efficiency across...

  • HR Systems Analyst

    7 days ago


    Vaughan, Ontario, Canada Toromont Cat Full time

    Job Summary:Toromont Cat is seeking a highly skilled HR Systems Analyst to join our team. As a key member of our HR department, you will be responsible for the operational and system subject matter expertise for all HR systems and third-party applications.Key Responsibilities:Manage the configuration of HR systems, ensuring data integrity and accuracy.Build...

  • HR Systems Analyst

    1 week ago


    Vaughan, Ontario, Canada Toromont Cat Full time

    Job Summary:Toromont Cat is seeking a highly skilled HR Systems Analyst to join our team. As a key member of our HR department, you will be responsible for the operational and system subject matter expertise for all HR systems and third-party applications.Key Responsibilities:Manage the configuration of HR systems, ensuring data integrity and accuracy.Build...

  • HR Systems Analyst

    1 week ago


    Vaughan, Ontario, Canada Toromont Cat Full time

    Job Summary:Toromont Cat is seeking a highly skilled HR Systems Analyst to join our team. As a key member of our HR department, you will be responsible for the operational and system subject matter expertise for all HR systems and third-party applications.Key Responsibilities:Manage the configuration of HR systems, ensuring data integrity and accuracy.Build...

  • HR Systems Analyst

    7 days ago


    Vaughan, Ontario, Canada Toromont Cat Full time

    Job Summary:Toromont Cat is seeking a highly skilled HR Systems Analyst to join our team. As a key member of our HR department, you will be responsible for the operational and system subject matter expertise for all HR systems and third-party applications.Key Responsibilities:Manage the configuration of HR systems, ensuring data integrity and accuracy.Build...


  • Vaughan, Ontario, Canada Trinity Financial Services Inc. Full time

    About the RoleWe are seeking a highly skilled Business Systems Analyst to join our team at Trinity Financial Services Inc. as a key member of our financial services team.Key ResponsibilitiesConfer with clients to identify business requirements and develop solutions to meet their needs.Document technical requirements to ensure that products, processes, and...


  • Vaughan, Ontario, Canada Trinity Financial Services Inc. Full time

    About the RoleWe are seeking a highly skilled Business Systems Analyst to join our team at Trinity Financial Services Inc. as a key member of our financial services team.Key ResponsibilitiesConfer with clients to identify business requirements and develop solutions to meet their needs.Document technical requirements to ensure that products, processes, and...

  • Data Analyst

    2 days ago


    Vaughan, Ontario, Canada Cardinal Health Full time

    About Cardinal HealthCardinal Health is a leading healthcare company that provides essential products and services to healthcare facilities and medical professionals across Canada.Job SummaryWe are seeking a highly skilled Data Analyst to join our Data & Analytics Function. As a Data Analyst, you will play a critical role in identifying, analyzing, and...

  • Data Analyst

    2 days ago


    Vaughan, Ontario, Canada Cardinal Health Full time

    About Cardinal HealthCardinal Health is a leading healthcare company that provides essential products and services to healthcare facilities and medical professionals across Canada.Job SummaryWe are seeking a highly skilled Data Analyst to join our Data & Analytics Function. As a Data Analyst, you will play a critical role in identifying, analyzing, and...