Business Intelligence Support Analyst

Dormont Manufacturing Co; United States; On-site; USD 70,000 - 87,000; Full time

Benefits offered by this job

401k Match

Medical

Dental

Vision

PTO

Paid Holidays

Tuition Reimbursement

Job summary

The Auto Club Group is seeking a Business Intelligence Support Analyst to enhance Business Intelligence solutions and improve data quality. The role offers a competitive salary of $70,000 - $87,000 annually, along with a comprehensive benefits package including 401k match, medical, dental, and more.

This position follows a hybrid work model allowing flexibility in office and remote work. Ideal candidates will have programming experience, a background in business administration or related fields, and strong analytical skills.

Qualifications

• College level coursework in Business Administration, Information Systems, Statistics, or related field.
• Programming experience in various languages (SAS, SQL, HTML, Javascript).
• Experience in data auditing, balancing, and reconciling.

Responsibilities

• Support management in the development of Business Intelligence solutions.
• Identify data quality improvements and assist in resolutions.
• Train end users on BI solutions and provide documentation.

Skills

SAS

SQL

HTML

Javascript

Data analysis

Education

Associate degree in Business Administration or related field

Tools

MS Office

SAS or other statistical software

Job description

Business Intelligence Support Analyst – The Auto Club Group

Job Type: Full time

Exempt/Non Exempt: Salary

What you will do

• 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 the resolution of data quality problems.
• Provide training and support to end users regarding BI solutions and the IBI data warehouse.
• Assist management and senior staff with the development of proposals and business cases.
• Develop end user documentation and communication plans.
• Analyze and assess the impact of changes to Actuarial, Underwriting, Sales, Processing and Claims procedures/systems including rate revision changes on data and reporting requirements.
• Assist in the development of data management quality assurance standards and processes.
• Participate in root cause analysis and problem‑solving activities as needed.
• Maintain Competency Center documents including procedures and communications.

Supervisory Responsibilities

None

How you will benefit

Business Intelligence Support Analyst will earn a competitive salary of $70,000 - $87,000 annually with annual bonus potential based on performance.

Benefits include:

• 401k Match
• Medical
• Dental
• Vision
• PTO
• Paid Holidays
• Tuition Reimbursement

Required Qualifications

Education

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

Experience

• Programming experience using SAS, Easytrieve, SQL, HTML and Javascript
• Creating web pages
• Auditing, balancing and reconciling data
• Analyzing procedures to identify and correct errors
• Preparing reports, correspondence and project plans
• Acceptance testing including assisting in the development of test scenarios and test data
• PC software applications (e.g. MS Office, Excel, Access, SAS or other statistical software)
• Control languages (e.g., JCL)

Knowledge and Skills

• Technology project lifecycle and various analytical and project management tools
• PC software applications (e.g. Visio, ERWIN, Process Mapping tools, etc.)
• Data management quality assurance standards and processes

Ability to

• Communicate effectively with others in a work environment and public
• Analyze information and business process flows
• Utilize business intelligence tools (i.e., SQL, Data Studio, SAS, Oracle BI)
• Explore alternative approaches to existing process and project objectives
• Identify coding issues and recommend improvements to the system
• Understand technology as it relates to business

Preferred Qualifications

Education

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

Experience in/with

• Documenting business processes
• Insurance (e.g. Actuarial, Claims, Underwriting, etc.) processes and procedures
• P&C insurance products, trends and practices

Work Environment

This is a hybrid work arrangement (time spent in office and remote). Depending on the employee’s role and leadership’s assessment, some employees will come in to an ACG facility on a weekly basis, a monthly basis, or on an “as needed” basis for key meetings and collaborative activities. Most employees will be required to come into the office, at a minimum, for important departmental meetings or team building events.

Important Note

ACG’s Compensation philosophy is to provide a market-competitive structure of fair, equitable and performance-based pay to attract and retain excellent talent that will enable ACG to meet its short and long-term goals. ACG utilizes a geographic pay differential as part of the base salary compensation program. Pay ranges outlined in this posting are based on the various ranges within the geographic areas which ACG operates. Salary at time of offer is determined based on these and other factors as associated with the job and job level.

The above statements describe the principal and essential functions, but not all functions that may be inherent in the job. This job requires the ability to perform duties contained in the job description for this position, including, but not limited to, the above requirements. Reasonable accommodations will be made for otherwise qualified applicants, as needed, to enable them to fulfill these requirements.

Equal Opportunity Employer

The Auto Club Group, and all its affiliated companies, is an equal opportunity employer. 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.

Attendance and Safety

Regular and reliable attendance is essential for the function of this job.

AAA The Auto Club Group is committed to providing a safe workplace. Every applicant offered employment within The Auto Club Group will be required to consent to a background and drug screen based on the requirements of the position.