• Responsible for assessing customer analytic needs and providing guidance on best possible course of action • Familiar with end-users workflows and align the customers business requirement with the analytic solutions • Develop custom metrics & RW SQL reports as well as operational dashboards using Radar. • Partner with the NGHS Technical Training team to develop and Implement training and documentation solutions • Establishing and enforcing best practices, mentoring junior analyst team members

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.

• Serve as the primary analytics partner to your assigned product team. • Attending sprint reviews, PI planning, and discovery sessions as a full participant, not a data supplier • Own the measurement plan for your assigned product portfolio. • Defining KPIs, funnels, and success metrics before they ship • Be the first touchpoint for product leader data needs, responsible for identifying solutions both home-grown and in partnership with other data and analytic teams, including our own data science team. • Evaluate the effectiveness of the digital product strategy and recommend adjustments when needed to drive outcomes. • Build and maintain product performance dashboards in PowerBI that drive active product decisions • Analyze member behavior across the digital experience, funnel drop-off, feature adoption, session depth, and engagement patterns • Work with Data Science teams to design and analyze A/B tests and experiments, communicate results clearly without overstating significance • Write and maintain SQL and Python to support analysis and automate recurring data pulls • Translate complex findings into clear, opinionated recommendations for product managers and senior leadership

• Process, reconcile and prepare investor reports for complex portfolios • Reconciles investor remittances up to $40,000,000 • Maintain and enhance procedures and controls for reporting activity • Assist in the preparation of audits • Point of contact for investors regarding outstanding checks and remittance differences • Provide support to resolve compliance or regulatory issues • Monitor, research and resolve unapplied funds and outstanding receivables • Ensure remittances are completed accurately and on time