Senior Business Systems Analyst

California, MO, United States

Press Tab to Move to Skip to Content Link

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.

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.

#J-18808-Ljbffr