Data Warehouse Business Systems Analyst with Insurance Domain Expertise

1 month ago


Vaughan, Ontario, Canada CAA Club Group Full time
Position Details

This role is responsible for defining business and operations requirements and systems goals, and identifying and resolving systems issues. The successful candidate will lead design sessions in prototyping new systems for enhancing business processes, operations, and information process flow.

Key Responsibilities
  • Meet with decision makers, systems owners, and business users to define business and operations requirements and systems goals.
  • Lead design sessions in prototyping new systems for 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 and 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 successful candidate will lead the design, development, and implementation of data warehousing systems and business intelligence tools to support the organization's strategic objectives.Key ResponsibilitiesCollaborate with stakeholders to define business requirements and identify opportunities for process improvement.Develop and maintain...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    Job SummaryWe are seeking a highly skilled Senior Enterprise Data Analyst to join our team at CAA Club Group. As a key member of our analytics department, you will play a crucial role in driving business growth and improvement through data-driven insights.Key ResponsibilitiesData Analysis and Insights: Conduct thorough analysis of complex data sets to...


  • Vaughan, Ontario, Canada SEASIDE IMMIGRATION INC. Full time

    Job Title: Business Analyst with Expertise in Software Development and Data Analysis


  • Vaughan, Ontario, Canada Mircom Group of Companies Full time

    Job Title: Business Systems AnalystJob Summary: We are seeking a highly skilled Business Systems Analyst to join our team at Mircom Group of Companies. As a Business Systems Analyst, you will play a pivotal role in understanding and translating business needs into functional requirements for our Dynamics 365 systems.Key Responsibilities:Work with business...


  • Vaughan, Ontario, Canada Mircom Group of Companies Full time

    Job Title: Business Systems AnalystJob Summary:We are seeking a highly skilled Business Systems Analyst to join our team at Mircom Group of Companies. As a Business Systems Analyst, you will play a crucial role in understanding and translating business needs into functional requirements for our Dynamics 365 systems.Key Responsibilities:Work with business...


  • Vaughan, Ontario, Canada Mircom Group of Companies Full time

    Job Summary:The Mircom Group of Companies is seeking a highly skilled Business Systems Analyst to join our team. As a Business Systems Analyst, you will play a pivotal role in understanding and translating business needs into functional requirements for our Dynamics 365 systems. This role requires a strong analytical mindset, exceptional communication...


  • Vaughan, Ontario, Canada Canada Inc. Full time

    At Canada Inc., we are seeking a highly skilled Data Systems Strategist to join our team.About the RoleWe are looking for a talented individual to work as a Data Systems Strategist. The successful candidate will be responsible for designing, developing, and implementing information systems business solutions that meet the needs of our clients.The ideal...


  • Vaughan, Ontario, Canada Noranco Full time

    About the RoleWe are seeking a skilled Technical Data Analyst to join our team at Noranco.This is an exciting opportunity for a talented individual to contribute to the development of reports and data analysis solutions that support business needs.Key ResponsibilitiesCreate complex SQL queries and stored procedures for new SSRS based reportsDevelop...


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

    Job Title: Business Systems AnalystJob Summary: We are seeking a highly skilled Business Systems Analyst to join our team at Trinity Financial Services Inc. The ideal candidate will have a strong background in business systems analysis and a proven track record of delivering high-quality solutions.Key Responsibilities:Confer with clients to identify business...


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

    Job Title: Business Systems AnalystJob Summary: We are seeking a highly skilled Business Systems Analyst to join our team at Trinity Financial Services Inc. The ideal candidate will have a strong background in information systems and business analysis, with excellent communication and problem-solving skills.Key Responsibilities:Confer with clients to...


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

    Job Title: Business Systems AnalystJob Summary: We are seeking a highly skilled Business Systems Analyst to join our team at Trinity Financial Services Inc. The ideal candidate will have a strong background in business systems analysis and a proven track record of delivering high-quality solutions.Key Responsibilities:Confer with clients to identify business...


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

    Job Title: Business Systems AnalystJob Summary: We are seeking a highly skilled Business Systems Analyst to join our team at Trinity Financial Services Inc. The ideal candidate will have a strong background in business systems analysis and a proven track record of delivering high-quality solutions.Key Responsibilities:Confer with clients to identify business...


  • Vaughan, Ontario, Canada Customerization Full time

    Job Title: Business Systems AnalystJob Summary:We are seeking a highly skilled Business Systems Analyst to join our team at Customerization. As a Business Systems Analyst, you will be responsible for delivering Zoho solutions to our customers, working closely with the sales and marketing teams to ensure seamless project delivery.Key Responsibilities:Project...


  • Vaughan, Ontario, Canada CAA Club Group Full time

    Position OverviewThe Business Systems Analyst - Enterprise Data Warehousing Specialist will play a key role in the development and implementation of data warehousing solutions for the CAA Club Group.


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

    We are seeking a skilled Business Systems Analyst to join our team at Trinity Financial Services Inc. The ideal candidate will have a strong background in information systems and a proven track record of delivering business solutions.Key ResponsibilitiesConfer with clients to identify business requirements and document technical specifications.Design,...

  • Data Analyst

    4 weeks ago


    Vaughan, Ontario, Canada Canada Inc. Full time

    At Canada Inc., we are seeking a skilled Data Analyst to join our team. As a key member of our data management team, you will be responsible for developing and maintaining computer databases, documenting customers' requirements for projects, and setting up the IT infrastructure to allow applications to access databases.The ideal candidate will have a strong...


  • Vaughan, Ontario, Canada Viana Inc. Full time

    Data Warehouse SpecialistViana Inc. is seeking a skilled Data Warehouse Specialist to join our team. The ideal candidate will have experience in designing and developing databases, operating database management systems, and analyzing data.Key Responsibilities:Design and develop databases to meet business needsOperate database management systems to analyze...


  • Vaughan, Ontario, Canada Canada Inc. Full time

    We are seeking a highly skilled Data Systems Specialist to join our team at Canada Inc.The ideal candidate will have a Bachelor's degree and 3 years of experience in Information Technology, with expertise in Computer Systems Analysis/Analyst, Computer Science, and Computer Software Engineering.As a Data Systems Specialist, you will work closely with clients...


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

    At Trinity Financial Services Inc., we are seeking a skilled Business Systems Analyst to join our team. As a key member of our organization, you will be responsible for analyzing business needs and developing effective solutions to meet those needs.The ideal candidate will have a strong understanding of business operations and be able to communicate complex...


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

    We are seeking a highly skilled Business Systems Analyst to join our team at Trinity Financial Services Inc. The ideal candidate will have a strong background in financial services industry and experience in designing, developing, and implementing information systems business solutions.Key Responsibilities:Confer with clients to identify requirements and...