Junior Analyst – AI & Operational Reporting

ALKEME Insurance; Salt Lake City (UT); On-site; USD 50,000 - 70,000; Full time

Job summary

A leading insurance company is looking for a Junior Analyst – AI & Operational Reporting in Salt Lake City. The successful candidate will build and enhance operational reports, analyze datasets for insights, and collaborate with teams for informed decision-making. Candidates should have 0-3 years of experience in analytics, proficient in Excel, and familiarity with AI tools. This on-site role requires strong problem-solving skills and effective communication.

Qualifications

• 0–3 years of experience in analytics, reporting, or operations.
• Strong proficiency in Excel or Google Sheets.
• Basic understanding of data analysis concepts.
• Familiarity with AI tools like Cursor or ChatGPT.
• Strong problem-solving and critical thinking skills.

Responsibilities

• Build and enhance operational reports across various performance metrics.
• Analyze datasets to identify trends and gaps.
• Partner with teams to support decision-making.
• Assist in data cleaning and quality management.

Skills

Data analysis concepts

Excel or Google Sheets

Problem-solving skills

Communication skills

Curiosity about AI

Education

0–3 years of experience in analytics or related field

Tools

SQL

Python

Tableau

Power BI

Job description

Overview

Job Description: Junior Analyst – AI & Operational Reporting

Job Title: Junior Analyst – AI & Operational Reporting

Location: The Hive — Sandy, UT 84070 (must work on-site on Sandy, UT)

Reports to: Head of AI

Employment Type: Hourly, non-exempt (full-time)

Responsibilities

Operational Reporting & Analytics

• Build, maintain, and enhance operational reports across sales, service, and agency performance
• Analyze datasets to identify trends, gaps, and opportunities for improvement
• Work with stakeholders to define reporting needs and translate them into dashboards or outputs
• Leverage AI tools (e.g., Cursor, ChatGPT, or similar) to accelerate analysis, reporting, and workflow automation
• Assist in developing lightweight AI-driven workflows to improve reporting efficiency
• Continuously explore new tools and methods to enhance productivity and output quality

Data Management & Quality

• Assist in cleaning, structuring, and validating data from multiple internal sources
• Identify inconsistencies or duplication in reporting data and propose solutions
• Support ongoing improvements to data pipelines and reporting accuracy

Business Collaboration

• Partner with operations, sales leadership, and other teams to support decision-making
• Translate data findings into clear, actionable insights for non-technical stakeholders
• Develop a working understanding of insurance operations and key performance metrics

Qualifications

Education & Experience

• 0–3 years of experience in analytics, reporting, operations, or related field
• Strong proficiency in Excel or Google Sheets
• Basic understanding of data analysis concepts (aggregations, trends, KPIs)
• Familiarity with AI tools (e.g., Cursor, ChatGPT, or similar)
• Strong problem-solving and critical thinking skills
• Excellent communication skills with the ability to explain data simply
• Exposure to SQL, Python, or BI tools (Tableau, Power BI, etc.) is a plus
• Basic understanding of insurance or financial services is a plus

Knowledge, Skills, and Abilities

• Experience working with large datasets or operational reporting
• Curiosity about AI and automation in business workflows
• Ability to learn new tools and technologies quickly
• Strong attention to detail and ability to manage multiple priorities

Success Metrics

• Accuracy and timeliness of operational reporting
• Ability to identify insights that drive measurable operational improvements
• Effective use of AI tools to increase speed and efficiency
• Stakeholder satisfaction and trust in reporting outputs

Working Conditions

• This is an in-office-based role with prolonged periods of sitting and computer use.
• Must be able to pull or lift up to 15 pounds at times and may require extended hours during peak renewal periods.