Business Intelligence Support Analyst

AAA-The Auto Club Group

6d•Hybrid

About The Position

The Auto Club Group is seeking a Business Intelligence Support Analyst to join their team. This role involves supporting management and senior staff in the research, analysis, and development of Business Intelligence (BI) solutions. The analyst will identify and resolve data quality issues, provide training and support to end-users on BI solutions and the IBI data warehouse, and assist with proposal and business case development. Additionally, the role includes developing end-user documentation, analyzing the impact of system and procedural changes on data and reporting, and assisting in the development of data management quality assurance standards. The analyst will also participate in root cause analysis and problem-solving activities, and maintain Competency Center documents.

Requirements

College level coursework in Business Administration, Information Systems, Statistics, Insurance or related field
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 of technology project lifecycle and various analytic and project management tools
Knowledge of PC software applications (e.g. Visio, ERWIN, Process Mapping tools, etc.)
Knowledge of data management quality assurance standards and processes
Ability to communicate effectively with others in a work environment and public
Ability to analyze information and business process flows
Ability to utilize business intelligence tools (i.e., SQL, Data Studio, SAS, Oracle BI)
Ability to explore alternative approaches to existing process and project objectives
Ability to identify coding issues and recommend improvements to the system
Ability to understand technology as it relates to business

Nice To Haves

Associate degree in Business Administration, Information Systems, Statistics, Insurance or related field
Experience in documenting business processes
Experience in Insurance (e.g. Actuarial, Claims, Underwriting, etc.) processes and procedures
Experience with P&C insurance products, trends and practices

Responsibilities

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.