Junior Data Analyst (Agency Reporting)

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. THIS IS AN IN PERSON ROLE. DO NOT APPLY, IF YOU DON’T LIVE IN THIS AREA., * 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

• 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

Hourly Base Salary Based on Experience Paid Time Off (PTO) Dental Insurance Vision Insurance Mon-Fri Schedule Hands on Training Career Growth Opportunities

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.