Business Analyst I - Financial Forecasting at Expansion Capital Group

Sioux Falls, South Dakota, United States -

Full Time

Start Date

Immediate

Expiry Date

17 Apr, 26

Salary

0.0

Posted On

17 Jan, 26

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Excel, Data Analysis, Financial Analytics, Attention to Detail, Problem Solving, Collaboration, Reporting, Data Validation, Dashboard Design, Customer Segmentation, Performance Monitoring, Cohort Analysis, Variance Analysis, Programming, Data Visualization, Financial Performance

Industry

Financial Services

Description

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.

Responsibilities

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.