Data & Analytics Intern

Reinvestment Fund•Philadelphia, PA

1d•$20•Remote

About The Position

The Lending Data & Analytics team has been working with IT to build the Enterprise Data Warehouse (EDW): the central system that houses all of Reinvestment Fund's lending data and drives the workflows and reporting behind loan origination, servicing, payments, and regulatory reporting across all of our lending portfolios. This internship offers hands-on experience across the full data stack, from writing SQL and building automated pipelines to designing Power BI dashboards that inform decision-making for portfolio managers, servicing staff, and senior leadership. We are offering an internship opportunity to work directly with lending data, build dashboards and reports, and contribute to projects that support real-world decision-making in a mission-driven organization. Projects are designed to be self-contained and completable within the summer, while contributing meaningfully to systems that remain in production long after. The intern will gain hands-on experience working across a uniquely complex data environment—one that integrates financial loan data with qualitative impact metrics to support the full breadth of RF's reporting needs, while developing a deeper understanding of what it means to work in a mission-driven CDFI environment.

Requirements

Undergraduate level studies in Computer Science, Data Science, or Statistics required
Ability to take initiative, as well as work independently when needed.
Demonstrate independent decision making and communication skills. The decisions of interns in these positions will directly contribute to the operation and success of the project or program.
Possess proficient research and problem-solving skills.
Experience with SQL, Azure Development Tools, and Power BI/Tableau is preferred
Students should be able to commit to a minimum of 20 hours per week.

Responsibilities

Assist with data visualization and reporting projects, which could include the following: Working on operational dashboards
Turn existing SQL infrastructure into a repeatable, committee-ready reports
Building a reusable repertoire of visualizations for quarterly lending reports
Assist with Database and Pipeline Development: Write and document new validation rules for the EDW lending data
Fill in the open sections of the Loan Administration Glossary and EDW Operations Manual
Reconcile the database object inventory and expand metadata to improve the EDW design and performance.
Other duties as assigned.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume