Business Analyst

Arthur J. Gallagher•Falls Church, VA

14d•Remote

About The Position

At RPS, we don't just embrace bold ideas, we make them happen. We're a team of entrepreneurs, big-picture thinkers, and passionate experts who thrive on possibility. Every day, we collaborate across teams, challenge convention, and push boundaries to design innovative solutions for our clients. With access to top-rated carriers and a dynamic marketplace, we bring strategy and creativity together to deliver what others might call impossible. Here, every voice counts, every perspective matters, and every challenge is an opportunity to grow. You'll be supported by a culture that celebrates ownership, curiosity, and high performance, where you're trusted to do your best work and encouraged to keep learning along the way. How you'll make an impact As an Analyst for Program Strategy, you will execute quantitative analysis to drive actionable insights. Your insights should identify performance gaps and hypotheses for root cause, leading to specific action plans to capitalize on opportunities. In this role, you'll work closely with executive leaders and internal stakeholders across the organization to complete complex ad-hoc analyses under tight deadlines. The ideal candidate can juggle multiple, time-sensitive analyses, effectively communicate expectations to internal and external stakeholders and streamline analytics processes/reporting where possible.

Requirements

Bachelor's degree
Minimum of 3 years' professional experience with quantitative analysis
2 years of experience in financial services industry. Insurance preferred.
Less than 20% travel
Communication and stakeholder management skills
Data analysis
Problem solving
Statistical analysis
Basic programming knowledge
Data preparation/cleaning
Data visualization and presentation
Typically requires a University Degree and minimum 3 years of prior relevant experience, or equivalent experience.

Nice To Haves

Bachelor's degree in statistics, mathematics, computer science, finance, data science, chemistry, engineering, or economics
Expert in Microsoft products - Excel, Power Pivot, Power BI
Intermediate to expert level in SQL for reading and manipulating data
Ability to work independently with minimal guidance as needed
Clear, concise, and effective communicator
Excellent problem-solving skills as well as critical thinking and conceptual thinking abilities
4+ years of relevant professional experience in business intelligence, analytics, statistics, data science, or related field
Communication and stakeholder management skills
Data analysis
Problem solving
Statistical analysis
Basic programming knowledge
Data preparation/cleaning
Data visualization and presentation

Responsibilities

Communicate with stakeholders to determine analytical needs
Identify, manipulate, and extract data for analysis using SQL
Conduct root cause analysis to identify key drivers and actionable insights
Embed quality checks to ensure numerical accuracy and logical consistency
Consult with subject matter experts to deepen understanding of findings
Develop executive-ready presentations to communicate insights
Recommend program improvements based on analytical findings
Automate repetitive tasks to improve team efficiency
Mentor and coach junior team members, providing real-time feedback

Benefits

Medical/dental/vision plans, which start from day one!
Life and accident insurance
401(K) and Roth options
Tax-advantaged accounts (HSA, FSA)
Educational expense reimbursement
Paid parental leave
Digital mental health services (Talkspace)
Flexible work hours (availability varies by office and job function)
Training programs
Gallagher Thrive program - elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing
Charitable matching gift program