"Alerted.org

The primary duties of the Insurance Data Analyst are to:

• Establish data analytics processes, roles, quality criteria, and performance metrics to support Agency leadership in achieving performance objectives.

• Identify, develop, and implement scalable data strategy, self-service tools, and workflow automation.

• Analyze and report data associated with sales, service and operational effectiveness, member retention, and project/product performance.

• Identify and evaluate the business value of new and existing data sources and uncover significant trends that will affect the organization in optimizing business decisions.

• Ensure the quality and accuracy of data results and analytic methods through the establishment of testing and validation procedures and best practices.

• Prioritize, scope, and recommend enterprise integrations and key performance indicators (KPIs) for projects across multiple business lines.

• Participate in project plans, timelines, and deliverables, and manage Agency resources.

• Advocate for data analytics practices and technology to senior stakeholders.

• Select and implement (or oversee implementation) all data analytics tools and frameworks.

• Execute quality controls and testing for ensuring project deliverables meet user expectations.

• Working with Enterprise counterparts to assure the Agency complies with the data governance framework.

To the qualified candidate, we offer:

• The starting base compensation for this position is $68,000 to $90,000 annually. Actual pay will be adjusted based on experience, geographic location, and other job-related factors as permitted by law.

• This position is eligible to participate in our Annual Bonus Program with a target bonus percentage of 5%.

• Medical, Dental, and Vision plan options

• Up to 2 weeks Paid parental leave

• 401k plan with company match up to 7%

•3 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 (https://cluballiance.aaa.com/careers/benefits) for more information

Minimum Qualifications

• Bachelor's degree (BS/BA), with at least 1 year of experience working with SalesForce data in an analytics and reporting capacity.

• Proficient in analytics tools such as SQL, Excel, R, Tableau or PowerBI, Python, Adobe, or Google Analytics.

• Conduct in-depth analyses of data to identify trends, patterns, and relationships, and summarize findings clearly and concisely for both technical and non-technical audiences.

• Exceptional analytical, communication, critical thinking, and problem-solving capabilities

• Work with project teams to understand the business objectives of each project and ensure that data analytics is used to its fullest potential to achieve these goals

• Develop detailed reports and presentations to communicate results of data analysis to key stakeholders, providing recommendations for further action based on findings

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.

This position will work a hybrid schedule of Tuesday, Wednesday, and Thursday each week in an office. Preferred office location is Cincinnati, OH but we will also consider candidates in Columbus, OH. Relocation will not be offered.

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 (https://cluballiance.aaa.com/careers/benefits) 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