Data Analyst – Accion The U S Network – New York, NY

About Accion:

The Accion U.S. Network is the largest nonprofit micro- and small-business lending network in the United States, with four members that collectively form a national footprint for lending and financial education. The Accion U.S. Network organization is responsible for developing capacity for its members by developing innovative tools and strategies to enhance customer acquisition, and to develop partnerships and new funding sources to ensure the long term sustainability of Accion’s work in the United States. The Accion U.S. Network is closely associated with Accion International, a global pioneer in microfinance providing loans in over 30 countries via its network of partners.

Position Summary:

The Data Analyst will take the lead on the maintenance and analysis of data related to lending outcomes, portfolio quality, and social performance for the Accion U.S. Network.

The maintenance of data includes the cleaning, compilation, analysis and pulling of reports as necessary to support communications, client acquisition, and the day-to-day operations of the organization.

This position will report to both the Marketing Analyst, and the Principal Manager of Development and Operations.

This is a part time, temporary position.

Essential duties and responsibilities:

Duties related to Client Acquisition

– Initial review of loan applications submitted by small business owners online for quality.

– Once quality has been assessed, assignment of loan applications to regional offices for processing.

– Management and analysis of reports from regional offices on the outcomes of the online loan applications that were assigned to them in Excel and Microsoft Access.

– Analysis of online loan application traffic

– Monitoring of the online loan application for traffic and for technical errors.

– Manipulate, condense and make-sense of large volumes of data to drive actionable business decisions.

Reporting and Analyses

– Assist in the aggregation, proofing and dissemination of quarterly reports on lending activity. These reports are primarily managed in Excel, Salesforce and PowerPoint. High level proficiency in Excel and familiarity with the generation of reports in Salesforce is essential.

– Pull data from quarterly reports as needed for U.S. Network Team

– Run high level analyses of data in quarterly reports, and create internal communication products to share findings.

– Keep that reports up to date and ensure they can be accessed as needed

– Support research on key data points in the field as necessary

Qualifications

– Strong Excel, MS Access, Visual Basic and SQL skills, including pivot tables, vlookups, conditional formatting, complex queries..etc.

– Understand and query disparate database sources, including relational structures, and dimensional data marts

– 5-7 years of experience in reporting and analytics involving both quick adhoc requests and longer-term analysis based on complex queries

– Moderate familiarity with Salesforce reporting systems

– Solid written and spoken communication skills

– Ability to work on a startup environment, and to manage many priorities at once

How to apply

Email cover letter and resume to usinfo@accion.org.

[yuzo_related]