Senior Analyst, Insurance Business Intelligence

LE001 AAA Club Alliance Inc.; Cincinnati (OH); Hybrid; USD 69,000 - 106,000; Full time

Benefits offered by this job

Competitive salary

Bonus eligibility

Hybrid schedule

Health benefits

Paid time off & holidays

401(k) with company match 7%

Tuition reimbursement

Volunteer time off

AAA Membership

Wellness program

Life and disability insurance

Job summary

AAA Club Alliance in Cincinnati, OH seeks an experienced Senior Analyst, Insurance Business Intelligence to develop scalable reporting solutions, analyze performance, and deliver insights to stakeholders. The role works independently on complex tasks and collaborates cross-functionally to support strategic initiatives.

This full-time position offers a competitive base salary, annual bonus eligibility, hybrid work schedule (3 days on-site weekly), comprehensive health benefits, PTO and holidays,

Qualifications

• Bachelor's degree or equivalent in a related field
• Minimum of 2 years of data analytics experience in insurance or financial services
• Proficiency in SQL, Power BI and Excel; familiarity with Tableau, Python or R preferred
• Experience reverse-engineering legacy reports and understanding ETL processes

Responsibilities

• Design, develop, and maintain interactive dashboards and reports for Sales, Service, and Member Retention
• Perform in-depth data analysis to identify trends and opportunities for improvement
• Gather requirements, define KPIs, and translate business needs into technical solutions
• Measure outcomes of implemented changes to guide management decisions
• Collaborate with data engineering and IT to troubleshoot data issues and improve accessibility
• Document business requirements, data definitions, and reporting logic
• Apply statistical techniques and data visualization best practices
• Monitor performance metrics and report trends to stakeholders
• Stay current with BI trends and recommend improvements
• Attend to ad hoc analyses for strategic initiatives
• Present findings clearly to stakeholders and influence decisions

Skills

SQL

Power BI

Excel

Data analysis

Problem solving

Education

Bachelor's degree in Business Analytics, Computer Science, Statistics, Economics, or related field

Tools

Tableau

Python

R

Job description

AAA Club Alliance is seeking an experienced Senior Analyst, Insurance Business Intelligence to join our team!

This position plays a critical role in developing scalable reporting solutions, analyzing performance metrics, and delivering actionable insights to business stakeholders. Works independently on complex tasks and collaborates cross-functionally to support strategic and operational initiatives.

What We Offer You:

• Competitive annual salary;
• The starting base compensation for this position is: $69,370 - $106,000*
• Annual Bonus Eligibility
• Hybrid schedule (3 days on-site weekly)
• Comprehensive health benefits package
• Generous accrued paid time off + 8 paid holidays
• 401(K) plan with company match up to 7%
• Professional development opportunities and tuition reimbursement
• Paid time off to volunteer & company-sponsored volunteer events throughout the year
• Other benefits include a complimentary AAA Membership, Health & Wellness Program, Health Concierge Service, Life Insurance and Short Term/Long Term Disability * The base pay range shown is a guideline for compensation and ultimate salary offered will be based on factors such as applicant experience and geographic location.

Primary duties of the Senior Analyst, Insurance Business Intelligence are to:

• Design, develop, and maintain interactive dashboards and reports that support decision-making across Sales, Service, and Member Retention teams.
• Conduct in-depth data analysis to identify trends, patterns, and opportunities for process improvement.
• Collaborate with business partners to gather requirements, define KPIs, and translate business needs into technical solutions.
• Measure successes of implemented changes in business processes to determine correct next steps for management.
• Collaborate with data engineering and IT teams to troubleshoot data issues and improve data accessibility.
• Assist in documenting business requirements, data definitions, and reporting logic to support transparency and knowledge sharing.
• Apply statistical techniques and data visualization best practices to uncover actionable insights.
• Monitor performance metrics and provide regular updates to stakeholders on trends and anomalies.
• Engage in continuous learning to enhance technical skills in tools such as SQL, Power BI, Tableau, or Python.
• Contribute to the development and optimization of data pipelines and reporting workflows.
• Evaluate and integrate new data sources to enhance reporting capabilities and data accuracy.
• Develop reporting which supports management in implementing strategies to achieve departmental and business line operational efficiencies and cost reductions.
• Perform ad hoc analysis to support strategic initiatives and answer business questions.
• Present analytical findings to stakeholders in a clear, concise, and actionable manner.
• Assist with the creation of presentations designed to influence key stakeholders and drive strategic business decisions.
• Stay current with Business Intelligence trends and technologies, recommending improvements as appropriate.
• Other duties as assigned.

Minimum Qualifications:

• Bachelor’s degree in Business Analytics, Computer Science, Statistics, Economics, or a related field. A combination of education and experience may be considered in lieu of a degree.
• Minimum of 2 years of experience in data analytics, preferably within the insurance or financial services industry required.
• Proficiency in SQL, Power BI, and Excel required; familiarity with additional tools such as Tableau, Python, or R is preferred.
• Experience reverse-engineering legacy reports and understanding ETL processes required.

Knowledge Skills and Abilities:

• Proficiency in SQL, Power BI, and Excel.
• Strong problem-solving skills and the ability to work independently on complex tasks.
• Proficiency with process mapping or diagramming tools (e.g., Lucidchart, Visio) and the design of project plans.
• Excellent communication skills, with the ability to convey technical concepts to non-technical audiences.

Full time Associates are offered a comprehensive benefits package that includes:

• Medical, Dental, and Vision plan options
• Up to 2 weeks Paid parental leave
• 401k plan with company match up to 7%
• 2+ weeks of PTO within your first year
• Paid company holidays
• Company provided volunteer opportunities + 1 volunteer day per year
• Free AAA Membership
• Continual learning reimbursement up to $5,250 per year
• And MORE! Check out our Benefits Page for more information

ACA is an equal opportunity employer and complies with all applicable federal, state, and local employment practices laws. At ACA, we are committed to cultivating a welcoming and inclusive workplace of team members with diverse backgrounds and experiences to enable us to meet our goals and support our values while serving our Members and customers. We strive to attract and retain candidates with a passion for their work and we encourage all qualified individuals to apply. It is ACA’s policy to employ the best qualified individuals available for all positions.

Hiring decisions are based upon ACA’s operating needs, and applicant qualifications including, but not limited to, experience, skills, ability, availability, cooperation, and job performance.

Job Category: Information Technology

Work from home or remote positions primary residence must reside within the footprint that AAA Club Alliance Inc. operates. Our club is located in Washington DC and 13 states including Connecticut, Delaware, Indiana, Kansas, Kentucky, Maryland, New Jersey, Ohio, Oklahoma, Pennsylvania, South Dakota, Virginia, and West Virginia. AAA Club Alliance is the result of AAA Mid-Atlantic, AAA Allied Group, AAA Oklahoma/South Dakota, and AAA Ohio Automobile Club joining, now representing nearly 7.4 million members in 13 states including Washington, D.C.

We’ve created an environment where you can look forward to coming to work and interacting with compassionate people who enjoy what they do and love supporting their team. We’re dedicated to keeping our Associates fulfilled and helping them feel secure. With such a diversity of products and services, our Associates have the opportunity to fulfill customer needs while growing their own career. So that leaves one question, are you ready to make a difference? We recognize that you don’t stop being a parent, caretaker, pet owner, or student because you’re at work. We give our Associates the option to customize their experience in order to suit their individual needs and interests. We offer a wide array of benefits that give our Associates piece of mind– even after retirement. You can learn more about our benefit offerings here.

AAA Club Alliance complies with federal, state and local disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please direct your inquiries to [e-mail].