Business Intelligence Support Analyst

Job Type: Full time   Exempt/Non Exempt: Salary Job Description: Location Details: Hybrid Position Schedule / Shift: Monday – Friday, 8am – 5pm Position Summary: Applicants for this position are required to be eligible to lawfully work in the U.S. immediately. Employer will not sponsor applicants for U.S. work authorization (example: H-1B visa) for this role. 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. Qualifications: Required 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 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 position works from a home office location. Depending on the role, some employees may be required to come into the office, at a minimum, for important departmental meetings or team building events. Compensation & Benefits Overview: ACG complies with all applicable state and local laws regarding required benefits (including PTO, paid sick leave, etc.). Compensation Business Intelligence Support Analyst will earn a competitive salary of $70,000 - $87,000 annually with annual bonus potential based on performance. Benefits At ACG, we offer a comprehensive and flexible benefits package designed to support your health, financial well-being, and professional growth. Health & Wellness Medical plans with multiple coverage options, including HSA eligibility Prescription drug coverage Dental and vision benefits Employee Assistance Program (confidential support services) Financial Protection & Insurance Company-paid basic life insurance Optional supplemental life insurance and dependent coverage Short-term and long-term disability coverage Critical illness, accident, and pet insurance options Retirement & Savings 401(k) plan to support long-term financial goals. 3% automatic deferral upon eligibility; may contribute 1% to 50% of eligible earnings, either pre or post tax. Company match of 50% paid on employee contributions up to 6% of pay, payable to employees following the end of the year; immediate vesting. Additional company contribution of 4% of pay each pay day into your account; 100% vested after three (3) years of service Health Savings Account (HSA) and Flexible Spending Accounts (FSA) options Time Off & Leave Paid Time Off (PTO): Accrual-based, increases with tenure, eligible at 90 days of employment. Full-time new employees will receive up to 12 PTO days annually; accrual based on start date and may include additional PTO based on role and/or state & local requirements. Part-time employee PTO hours are calculated based upon the standard weekly hours the employee is scheduled to work and will accrue at a minimum of 3 hours per month Paid Holidays: Full-time employees are eligible for 10 company-paid holidays annually, in addition to 1 mental health day, 2 floating holidays and 1 volunteer day. Holidays vary by business unit schedules. Part-time employees are eligible for 8 company-paid holidays annually, in addition to 1 mental health day and 2 floating holidays. Holidays vary by business unit schedules Paid leave programs, including parental, bereavement, jury duty, and military leave Career Growth & Education Tuition assistance (up to $5,250 annually; 80% covered by ACG) Professional certification support with 100% reimbursement for eligible programs Opportunities for career development and advancement Additional Perks Complimentary AAA membership with roadside assistance and travel discounts Adoption assistance program Job Posting Period: This position is expected to remain posted through July 31, 2026; however, it may close at any time once a qualified candidate pool is ident