Financial Data Specialist Intern

About WebBank

WebBank (the “Bank”) is a Utah chartered Industrial Bank headquartered in Salt Lake City, Utah. As “The Bank Behind the Brand®”, WebBank is a national issuer of consumer and small business credit products through Strategic Partner (Brand) platforms, which include retailers, manufacturers, finance companies, software as a service (SaaS) and financial technology (FinTech) companies.  The Bank is a leading player in the digital lending space, driving innovation in financial products through embedded finance with Strategic Partner platforms.  WebBank engages in a full range of banking activities including consumer and commercial loan products, revolving lines of credit, credit cards, private-label card issuance, auto-refinancing and more. The Bank provides capital in the form of asset-backed lending and other credit facilities to Strategic Partner platforms, credit funds, and other lenders with a targeted focus on specialty finance assets. The Bank is also a leading provider of commercial insurance premium finance products through its wholly owned subsidiary National Partners and Security Premium Finance, a wholly owned subsidiary of National Partners.

Job Summary

In this intern position, you will play a pivotal role on the finance data team. Report writing, troubleshooting ETL job failures, query writing, and shaping the future of everyday operations through innovative solutions are only a few of the responsibilities of this role. You will gain valuable insight into the day-to-day financial operations of one of the nation’s best fintech employers (see Glassdoor). You should be willing to come with questions, accept a steep learning curve, and collaborate with other parts of WebBank’s finance team.

Primary Responsibilities

You Will:

•                     Write SQL views to aggregate data for treasury and accounting teams.

•                     Write SQL reconciliation scripts to verify data submitted to us by our partners.

•                     Generate ad-hoc reports per request.

•                     Assist in troubleshooting ETL process failures. And work requests by all levels of the finance team.

•                     Assist in testing of queries and scripts pre-production.

•                     Help to shape process workflow testing, validation, and deployment procedures.

Qualifications

You Have:

•                     One year or less until graduation in a bachelor’s program.

•                     Advanced Excel and SQL skills.

•                     MS Office software skills are required.

•                     Must be organized and can multi-task.

•                     Must be detail oriented.

•                     Strong interpersonal skills. Must be comfortable working within a team environment.

•                     Excellent communication and negotiation skills to communicate effectively across a broad base including internal customers, external customers, and executive management.

•                     An innovative mind, always looking for improvements and ways to further automation and reconciliation processes.

Even Better: 

•                     Any background or knowledge in tableau preferred.

•                     Python, VBA, and other coding knowledge is preferred.

Flexible work option – Flexible work-from-home opportunities and other hybrid workplace options are available.