Question
0-2

Business Analyst I - Financial Forecasting

1/16/2026

The Analyst I will support cross-functional teams by delivering financial analytics and maintaining financial curves that illuminate customer lifecycle performance. This includes building reports, performing analyses, and collaborating with various departments to provide data-driven insights.

Working Hours

40 hours/week

Company Size

51-200 employees

Language

English

Visa Sponsorship

No

About The Company
Expansion Capital Group provides business owners working capital financing. Call us today to learn more: (877) 262-6236 or (605) 252-3635 American business owners have outstanding vision and perseverance. To build a great company, it takes ingenuity, determination, and dedication. From hiring good people to generating new customers we understand it is tough being a small business owner. That's why solid financial partnerships can be the difference between a growing small business, those that just tread water and those that don't make it. Expansion Capital Group is that valued partner for expansion capital solutions. We are entrepreneurs who have launched and created businesses. Like you, we sweat the small stuff. Our entrepreneurial background gives us great appreciation for what you have built, your determination to continued growing, and an understanding to how working capital can be critical to your success. We provide expert guidance with our team of experienced finance managers dedicated to your success. We strive to be your financial partners for the long haul.
About the Role

Description

Business Analyst I – Financial Forecasting


Reports to: Manager of Analytics

Classification: Full Time, Exempt


JOB DESCRIPTION

Summary/Objective 

The Analyst I will support cross-functional teams—particularly Accounting and Finance—by delivering financial analytics centered on building and maintaining financial curves that illuminate customer lifecycle performance. This role requires strong SQL skills and a high level of attention to detail to generate accurate loss curves, revenue curves, and cohort performance views used throughout the organization. The Analyst I will leverage these curves to enhance customer segmentation, performance monitoring, and reporting, while collaborating across departments to provide clear, data-driven insights that guide strategic and operational decisions.

Key Responsibilities

  • Attend stakeholder meetings to understand reporting needs and provide data-driven insights.
  • Build, update, and maintain recurring reports to monitor key business and financial performance metrics.
  • Perform ad-hoc analyses to answer operational, financial, and strategic questions, delivering clear and actionable findings.
  • Convert existing point estimates of loss and revenue into cumulative loss curves, revenue curves, and cohort performance views.
  • Maintain and enhance curve-generation logic to ensure consistency and accuracy across customer segments and portfolios.
  • Use curve outputs to support customer segmentation, variance analysis, and performance tracking.
  • Compare actual performance against expected curve values and identify drivers of deviations.
  • Collaborate with cross-functional teams—including Accounting, Finance, Risk, and Operations—to ensure alignment on metrics, assumptions, and reporting requirements.
  • Assist in data quality checks and validation to ensure accuracy of reporting and curve calculations.
  • Design and maintain dashboards that present key financial and performance indicators for management review.
  • Communicate analytical findings clearly to both technical and non-technical audiences to support informed decision-making.
  • Ensure timely delivery of all reporting, analytics, and curve updates.


 

Qualifications 

Required

  • Bachelor’s degree in a quantitative or analytical field (e.g., Statistics, Business/Economics, Mathematics, Data Science, Engineering).
  • Working knowledge of SQL with the ability to query and manipulate large datasets.
  • Proficiency with Excel, including formulas, lookups, and data analysis functions.
  • Strong attention to detail and a proactive, problem-solving mindset.
  • Ability to communicate analytical findings clearly to both technical and non-technical audiences.
  • Ability to work collaboratively across Accounting, Finance, Risk, and Operations.

Preferred

  • Experience in an analytics, reporting, or financial performance role.
  • Familiarity with a programming language such as Python or R for data manipulation.
  • Basic understanding of data visualization tools (e.g., Tableau, Power BI).
  • Exposure to financial services, lending, portfolio analysis, or customer segmentation.


Supervisory Responsibility

This position does not have any supervisory responsibility.


Work Environment

This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.


Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. This is largely a sedentary role; however, some filing is required. This would require the ability to lift files, open filing cabinets and bending or standing on a stool as necessary. 


Position Type/Expected Hours of Work 

This is a full-time position, and hours of work and days are Monday through Friday, 8:00 a.m. to 5:00 p.m. Occasional evening and weekend work may be required as job duties demand. 


Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. 


Key Skills
SQLExcelData AnalysisFinancial AnalyticsAttention to DetailProblem SolvingCollaborationReportingData ValidationDashboard DesignCustomer SegmentationPerformance MonitoringCohort AnalysisVariance AnalysisProgrammingData VisualizationFinancial Performance
Categories
Finance & AccountingData & AnalyticsConsultingManagement & Leadership
Apply Now

Please let Expansion Capital Group know you found this job on InterviewPal. This helps us grow!

Apply Now
Prepare for Your Interview

We scan and aggregate real interview questions reported by candidates across thousands of companies. This role already has a tailored question set waiting for you.

Elevate your application

Generate a resume, cover letter, or prepare with our AI mock interviewer tailored to this job's requirements.