Business Intelligence Support Analyst

AAA-The Auto Club Group is seeking a Business Intelligence Support Analyst to support management and senior staff in the research, analysis, and development of BI solutions. The role involves improving data quality, providing training to end users, and assisting in the development of proposals and business cases.

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

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)
• 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
• 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
• Associate degree in Business Administration, Information Systems, Statistics, Insurance or related field
• Documenting business processes
• Insurance (e.g. Actuarial, Claims, Underwriting, etc.) processes and procedures
• P&C insurance products, trends and practices