Business Intelligence Analyst

Familysecurityplan; Orange (CT); On-site; USD 90,000 - 120,000; Full time

Job summary

The Family Security Plan in Orange, CT (Hybrid) seeks a Business Strategy Analyst to partner with the leadership team to shape decisions that affect growth, customer experience, and long-term strategy. You will own meaningful analytical work from defining the business question through presenting recommendations to leadership.

Responsibilities include forecasting revenue, evaluating customer segments, measuring marketing effectiveness, and supporting market expansion.

Qualifications

• Bachelor's degree in quantitative or business-related discipline.
• Strong ownership of business analysis and analytical models that influence strategy or operations.
• Proficient in Microsoft Excel, data organization, trend identification, and explaining conclusions.
• Experience translating ambiguous business questions into practical recommendations.
• Strong critical thinking and curiosity, with data-driven challenge to assumptions.

Responsibilities

• Forecast revenue and identify drivers of business performance.
• Evaluate customer segments and measure marketing effectiveness.
• Analyze operational improvements and opportunities for growth.
• Help leadership evaluate new business opportunities and strategic options.
• Develop executive-level financial and operational analyses to support planning.

Skills

Advanced Excel

SQL

Python

R

Critical thinking

Education

Bachelor's degree in quantitative or business-related discipline

Tools

SQL

Python

R

Job description

Overview

The Family Security Plan is seeking a Business Strategy Analyst in Orange, CT (Hybrid). This role partners with the leadership team to shape decisions that affect company growth, customer experience, and long-term strategy. It involves owning meaningful analytical work from defining the business question through presenting recommendations to leadership.

Responsibilities

You will often work with incomplete information, develop reasonable assumptions, test your thinking, and refine recommendations as new information becomes available. You may work on a wide variety of business challenges, including forecasting revenue, identifying drivers of business performance, evaluating customer segments, measuring marketing effectiveness, analyzing operational improvements, and helping leadership evaluate new business opportunities.

Example Projects Youll Lead

• Developing customer segmentation models that identify opportunities for growth, marketing optimization, and improved business performance.
• Investigating the business drivers that influence customer behavior, lifetime value, and long-term business performance.
• Building long-term revenue forecasting models that help leadership evaluate growth strategies and business scenarios.
• Evaluating compensation plans, incentive programs, and commission structures to understand how they influence sales performance and business outcomes.
• Measuring wallet share and identifying opportunities to strengthen customer relationships and increase long-term value.
• Supporting market expansion and community growth initiatives by identifying opportunities and measuring business impact.
• Designing analytical models that improve field scheduling, territory planning, and operational efficiency.
• Partnering with Technology to validate major system implementations and ensure business processes continue to perform as expected.
• Developing executive-level financial and operational analyses that support strategic planning and organizational performance.

What Success Looks Like

Success in this role is measured by the quality of the business decisions your analysis helps leaders make.

Within your first year, you will be expected to:

• Become the person leaders seek out when they need to understand why business performance has changed and what should happen next.
• Take ownership of multiple analytical models that directly influence strategic business decisions.
• Independently investigate complex business questions, identify the key drivers behind performance, and communicate practical recommendations.
• Improve existing forecasting, customer segmentation, and business performance models by challenging assumptions and continuously refining their accuracy.

Requirements

Required Qualifications

• Bachelor's degree in quantitative or business-related discipline.
• Minimum of three years of professional experience in an analytical role with demonstrated ownership of business analysis, analytical models, or decision support that influenced business strategy or operational performance.
• Strong Microsoft Excel skills, including the ability to independently organize data, identify trends, build analytical models, and clearly explain conclusions.
• Experience investigating ambiguous business questions, developing reasonable assumptions, and translating analysis into practical business recommendations.
• Strong critical thinking, intellectual curiosity, and the confidence to challenge assumptions using data.

Preferred Qualifications

Experience in one or more of the following areas:

• Revenue forecasting
• Business strategy
• Customer segmentation
• Customer lifetime value (CLTV) analysis
• Pricing strategy
• Marketing analytics
• Profitability analysis
• Scenario planning
• Statistical modeling
• SQL
• Python or R

Why Join Us

Our mission is helping families achieve financial security and protection. Every analysis you perform has the potential to improve decisions that strengthen that mission.