Business Intelligence Support Analyst

AAA-The Auto Club Group; Dearborn (MI); Hybrid; USD 70,000 - 87,000; Full time

Benefits offered by this job

Health, dental, vision, and Rx

401(k) plan with company match

Health Savings Account and Flexible Re

Paid time off and holidays

Tuition assistance and professional 1

Job summary

AAA-The Auto Club Group is seeking a BI Analyst to support management and senior staff in the research, analysis and development of BI solutions. The role focuses on data quality, end-user training, and documentation for the IBI data warehouse.

You will analyze changes to procedures, develop QA standards, and participate in root cause analysis. The position is hybrid with normal business hours and competitive compensation.

Qualifications

• College-level coursework in Business Administration, Information Systems, Statistics, Insurance or a related field.
• Experience programming using SAS, Easytrieve, SQL, HTML and JavaScript.
• Auditing, balancing, and reconciling data.
• Analyzing procedures to identify and correct errors.
• Preparing reports, correspondence and project plans.
• Acceptance testing and development of test scenarios and data.
• Proficiency with MS Office, Excel, Access, SAS or other statistical software.
• Experience with JCL.

Responsibilities

• Support management and senior staff in BI solution development.
• Identify and resolve data quality problems.
• Provide user training and support.
• Assist with business case development.
• Develop documentation and communication plans.
• Analyze impact of procedural changes on data and reporting.
• Develop data QA standards and processes.
• Participate in root cause analysis and problem solving.
• Maintain Competency Center documents.

Skills

SQL

Data Studio

SAS

JavaScript

HTML

Excel

Communication

Education

Bachelor's degree in Business Administration, Information Systems, Statistics, Insurance or related

Associate degree (preferred)

Tools

MS Office

ERWIN

Visio

Oracle BI

JCL

Job description

Position Summary

Applicants for this position must be eligible to work in the United States immediately and the employer will not sponsor U.S. work authorization.

Employment Information

Job Type: Full time (Exempt) – Salary based.

Location: Hybrid (home office with occasional office attendance for meetings and team events).

Schedule: Monday – Friday, 8:00 a.m. – 5:00 p.m.

Salary: $70,000 – $87,000 annually with annual bonus potential based on performance.

Job Description

Support management and senior staff in the research, analysis and development of Business Intelligence (BI) solutions. Identify areas for data quality improvement and provide support in resolving data quality problems. Provide training and support to end users regarding BI solutions and the IBI data warehouse. Assist with the development of proposals and business cases. Develop end‑user documentation and communication plans. Analyze the impact of changes to Actuarial, Underwriting, Sales, Processing and Claims procedures/systems on data and reporting. Assist in developing data management quality assurance standards and processes. Participate in root cause analysis and problem‑solving activities. Maintain Competency Center documents.

Responsibilities

• Support management and senior staff in BI solution development.
• Identify and resolve data quality problems.
• Provide user training and support.
• Assist with business case development.
• Develop documentation and communication plans.
• Analyze impact of procedural changes.
• Develop data QA standards and processes.
• Participate in root cause analysis and problem solving.
• Maintain Competency Center documents.

Qualifications

Required

Education

• College‑level coursework in Business Administration, Information Systems, Statistics, Insurance or a related field.

Experience

• Programming experience using SAS, Easytrieve, SQL, HTML and JavaScript.
• Experience creating web pages.
• Auditing, balancing, and reconciling data.
• Analyzing procedures to identify and correct errors.
• Preparing reports, correspondence and project plans.
• Acceptance testing, including development of test scenarios and test data.
• Proficiency with PC software applications such as MS Office, Excel, Access, SAS or other statistical software.
• Experience with control languages such as JCL.

Knowledge and Skills

• Technology project lifecycle and analytical and project management tools.
• PC software applications such as Visio, ERWIN, and process‑mapping tools.
• Data management quality assurance standards and processes.

Ability To

• Communicate effectively in a work environment and publicly.
• Analyze information and business process flows.
• Use business intelligence tools such as SQL, Data Studio, SAS and Oracle BI.
• Explore alternative approaches to existing processes and project objectives.
• Identify coding issues and recommend improvements to systems.
• Understand technology as it relates to business functions.

Preferred

Education

• Associate degree in Business Administration, Information Systems, Statistics, Insurance or a related field.

Experience In/With

• Documenting business processes.
• Insurance processes and procedures such as actuarial, claims, underwriting.
• P&C insurance products, trends and practices.

Work Environment

This position works from a home office with occasional office attendance for meetings and team building events.

Compensation and Benefits

• Competitive salary of $70,000 – $87,000 annually with annual bonus potential.
• Health, dental, vision, and prescription drug coverage.
• Life insurance, supplemental life, disability, critical illness, accident, and pet insurance options.
• 401(k) plan with a company match and additional company contributions.
• Health Savings Account (HSA) and Flexible Spending Accounts (FSA).
• Paid time off: PTO, paid holidays, a mental health day, floating holidays, volunteer day, parental leave, bereavement, jury duty, and military leave.
• Tuition assistance and professional certification support.
• Additional perks: Complimentary AAA membership and adoption assistance program.

EEO Statement

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability or protected veteran status. Reasonable accommodations will be made for otherwise qualified applicants as needed to fulfill job requirements.

Posting Information

Position remains posted through July 31, 2026; however it may close at any time once a qualified candidate pool is identified.