Commissions & Automation Specialist
Description:
The Opportunity
Firefly Agency — a fast-growing, tech-driven insurance network — is looking for a data-savvy problem solver to join our Operations team.
In this role, you’ll take ownership of one of Firefly’s most important promises: making sure our agents get paid accurately and on time. But we’re not just looking for someone to follow our process — we’re looking for someone who can make it better.
This is a technical, process-focused position, ideal for someone with a strong foundation in data, automation, or computer science — whether you’ve gained it through professional experience or a degree in Computer Science, Data Analytics, Database Management, Accounting, or a related field.
If you love improving workflows, automating tasks, and using tools like Excel, Power Automate, or SQL to make systems smarter, this is your opportunity to shape how Firefly operates.
You don’t need to come from the insurance industry — we’ll teach you that. What matters most is your technical expertise and your curiosity to modernize how work gets done.
You’ll learn directly from our current Commission Specialist, who has led this work for 20 years and will retire in 2026. During that time, you’ll master commission processing while also helping us streamline and advance the way we work.
This is a work-from-home position. Our team operates fully remote but stays connected through daily collaboration and quarterly in-person gatherings in Columbus, Ohio.
Because of those meetings, we’re seeking candidates who live in one of these states:
Ohio • Illinois • Indiana • Kentucky • Michigan • North Carolina • Pennsylvania • Tennessee • West Virginia
What You’ll Do
This role combines hands-on operational work with creative process improvement. You’ll
maintain the systems that make Firefly run — and help design the next generation of automation that will make them even better.
Commission Responsibilities (that you’ll learn, master, and modernize):
Collect monthly commission statements from insurance carriers and ensure accurate reconciliation in our Agency Management System (EZLynx).
Match commissions to the correct agents and generate payout reports.
Schedule ACH deposits to agents and answer questions about commission statements.
Match monthly agency costs (such as MVR charges) with our agent offices to ensure accurate cost pass-through.
Reconcile monthly carrier deposits with statement totals.
Oversee sweep payments — premiums collected by agents that must be electronically transferred to carriers.
Transfer funds between multiple accounts to ensure accuracy.
Innovation & Automation — Process Improvement Responsibilities:
Use your Excel and database expertise to improve accuracy, speed, and efficiency in monthly commission processing.
Automate and optimize recurring tasks with tools like Power Automate, Power Query, and Azure Data Factory.
Build, test, and document streamlined workflows that reduce manual effort and improve data visibility.
Help maintain and expand integrations between EZLynx, Power Platform, SQL, and other business systems.
Partner with teammates to identify data bottlenecks and design tech-based solutions that make our systems work smarter.
About Firefly
Firefly is an insurance agency network with more than 200 branches nationwide. We help independent agents grow their businesses by giving them access to top-rated carriers, advanced technology, and support systems that make their work easier and more rewarding.
We’re a process-driven organization that uses technology and automation-assisted workflows to deliver consistent, high-quality results for both our team and our agents. Power Automate has long been the backbone of our process automation, while cloud-based SQL databases serve as our primary source of truth. We’ve developed and maintain several Power BI dashboards to provide business intelligence across the company. These tools have been built through a mix of in-house and outsourced expertise — and we’re ready to expand our in-house technical team to take our automation and data systems even further.
Our culture is built on four values: Teamwork,
Transparency, Doing What’s Right, and Empathy. We live these values daily as we work with each other and with our agents. Firefly’s team is professional, fast-growing, and technology-driven — and also fun and people-focused.
Who We’re Looking For
We’re looking for someone who loves solving problems and finding better ways to get things done. You get energy from using technology to make complex work simpler, faster, and more consistent. You’re
a good fit if you’re
curious about how systems connect, eager to learn, and take pride in creating reliable, efficient solutions.
This is a great role if you want to take ownership of automation projects and see your ideas come to life — not get lost in a large organization where your work goes unnoticed. We value people who are organized, detail-oriented, and comfortable working with data to improve how things work.
Must Haves:
Background in computer science, database management, data operations,
or process automation.
Strong Excel skills, including complex formulas and Power Query.
Familiarity with SQL database management — able to understand, organize, and work with interrelated data tables, stored procedures, and queries.
Experience or interest in automation tools like Power Automate, Power Apps, or Azure Data Factory.
High comfort level with data and digital platforms, and the creativity to use them to solve real problems.
Organized, detail-oriented, and reliable with numbers.
Excellent communication skills for collaborating with both technical and non-technical teammates.
Nice to Have:
Familiarity with insurance industry — insurance company or insurance agency operations.
Basic understanding of financial reconciliation or accounting workflows.
At Firefly, you’ll apply your technical skills to real-world business operations in an environment where your ideas matter and your ideas will drive meaningful, visible improvements.
Why You’ll Love Working at Firefly
A stable, established company
that’s been growing for 20 years.
Opportunities to modernize and streamline key business processes.
A remote, tech-enabled environment with a supportive, collaborative culture.
Quarterly team gatherings in Columbus, Ohio for connection and planning.
Benefits:
15 days (120 hrs.) PTO available upon hire date
401(k) with Employer match up to 4%, available immediately
Health/Dental/Vision Insurance
Short-Term Disability, AD&D and Life Insurance
Paid Maternity leave
Paid Parental Leave
Learn more about Firefly on our website and on social media:
“About Us” on our website
“Less germs, more hugs” (Our team shares the perks of working from home.)