Junior Data Analyst (Agency Reporting)
Role summary
We are seeking a detail-oriented Junior Data Analyst to join our independent agency. This role will focus on preparing, cleaning, and analyzing data to support internal teams and client reporting. You will utilize Microsoft Excel for data manipulation and analysis, assist in building recurring reports, identify trends, and support ad hoc analysis requests. The ideal candidate has a basic understanding of data analysis concepts, statistics, and a strong commitment to data accuracy. This is a great opportunity for an early-career professional to develop analytical and business intelligence skills in a fast-paced agency environment.
## Job Overview
We are an independent agency focused on delivering clear, data-driven insights that help our clients make smarter decisions. As we continue to grow, we're looking for a detail-oriented Junior Data Analyst to support our reporting and analytics efforts. The Junior Data Analyst will play a key role in preparing, cleaning, and analyzing data to support internal teams and client reporting. This is an excellent opportunity for someone early in their career who enjoys working with data and wants to build strong analytical and business intelligence skills in a fast-paced agency environment.
Salary Range: $18.00 - $22.00 per hour
## Benefits
Hourly Base Salary Based on Experience
Paid Time Off (PTO)
Dental Insurance
Vision Insurance
Mon-Fri Schedule
Hands on Training
Career Growth Opportunities
## Requirements
- Proficiency in Microsoft Excel, including data cleaning, manipulation, and analysis
- Strong attention to detail and commitment to data accuracy
- Basic understanding of data analysis concepts and best practices
- Ability to manage multiple tasks and meet deadlines
- Strong problem-solving and critical-thinking skills
- Effective written and verbal communication skills
- Basic knowledge of statistics or data modeling
- General computer proficiency and comfort troubleshooting basic technical issues; ability to assist with simple IT-related tasks is a plus
## Responsibilities
- Collect, clean, and organize data from multiple sources to ensure accuracy and consistency
- Use Excel to manipulate and analyze datasets (e.g., formulas, pivot tables, lookups)
- Assist in building and maintaining recurring reports for internal and client use
- Identify trends, patterns, and anomalies in data and communicate findings clearly
- Support ad hoc analysis requests from account and strategy teams
- Help improve reporting processes and data workflows for efficiency and scalability
## About Us
At ABT Insurance, we are dedicated to safeguarding what matters most to you. With a commitment to exceptional service and tailored solutions, we thrive in the insurance industry by putting our clients first. Our professional yet welcoming culture fosters collaboration and innovation, ensuring our team members grow alongside our clientele. Join us as we navigate the ever-evolving landscape of insurance, empowering individuals and businesses with the protection they deserve. Together, we build a safer future.