Business Intelligence Support Analyst

Title: Business Intelligence Support Analyst

Location: MI-Admin Office Building (AOB)

Full time

Hybrid

Business Intelligence Support Analyst– The Auto Club Group

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.

Excellent and comprehensive benefits packages are just another reason to work for the Auto Club Group. Benefits include:

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

We’re looking for candidates who:

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 analytic 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.