Business Analyst I - Financial Forecasting
Expansion Capital Group
Date: 13 hours ago
City: Sioux Falls, SD
Contract type: Full time
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
Qualifications
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.?
#hc214099
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
- 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.
- 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.
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.?
#hc214099
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Investment Accounting Policy Manager
Sammons Financial Group Companies,
Sioux Falls, SD
$82,654
-
$172,197
per year
1 week ago
What You Can Expect In This RoleMonitor new accounting guidance applicable to all types of investments. Research, identify and communicate potential impacts to the organization, and participate in any required implementation. Interpret, apply and document accounting guidance applicable to investment transactions.What You'll Do In This Role Perform technical accounting research and provide interpretation of ambiguous and complex accounting literature to...
Personal Financial Counselor, Sioux Falls, SD
Magellan Federal,
Sioux Falls, SD
$53,125
-
$84,995
per year
2 weeks ago
This position will provide personal financial services at assigned military installations. Primary responsibilities include the full breadth of personal financial counseling services to military service members and their families at military installations. Services include education and counseling addressing financial services that may include, but are not limited to, one-on-one counseling, consultation with a commander or with another provider or staff,...