Data Warehouse Business Systems Analyst with Insurance Domain Experience

Date: May 16, 2024

Location: Thornhill, ON, CA, L3T 0A1

Company: CAA Club Group

About Us

CAA Club Group of companies is looking for a Senior Business Systems Analyst with ETL Data Warehousing experience to join our growing IT team.

Who we are

As Canada's largest automobile association, we are passionate about keeping our Members safe - whether they are on the road, at home, or travelling abroad. Meeting the diverse needs of our 2.5M+ Members requires high performing, forward thinking, and innovative people who work collaboratively to keep propelling our business forward.  Our diverse organization provides insurance, technology, retail, and travel solutions through its various subsidiaries. Get ready to drive your career forward. Life at CAA Club Group is fast paced, performance-driven and rewarding. We value our Associates' career growth and ongoing professional development - and we regularly recognize their achievements and outstanding results.  We are caring.  We are leaders.  We are innovators.  We are collaborative.  We work hard and play hard. We're about doing what's right and feeling good about it.

Position Details

What You Will Do

  • 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 enviro 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

Who You Are

  • 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

Our Commitment

We are an equal opportunity employer and are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). CCG will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.  As an organization we are focused on Member safety, which includes the safety and well-being of our Associates. Therefore, you must be and remain fully vaccinated as a condition of employment.