Expansion Capital Group
Sioux Falls, SD
Posted/Updated: Today
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.?