Data & Compliance Analyst

Description

 About Locus:

At Locus, we know communities thrive when they have equitable access to capital. We collaborate with stakeholders across the community development ecosystem to invest in communities with strong aspirations, while addressing challenges like a shortage of affordable housing, limited access to fresh food, a lack of quality jobs, and clean energy innovation. We believe a capital system that centers community input and impact is essential to ensure that everyone, no matter their background, location, or economic status, can live in healthy, thriving places. 

Locus is the parent organization for a family of community development enterprises, which includes a nonprofit CDFI loan fund, a CDFI bank, a fund management practice, and a national guarantee program. With offices in Christiansburg and Richmond, Virginia, Locus offers innovative and flexible financing tools and strategic consulting services to individuals and organizations in underestimated and excluded communities, most of which are low-to-moderate income. Alongside our many partners, Locus has generated over $2 billion dollars in total impact. 

Locus is a nonprofit holding company regulated by the Federal Reserve. Locus Bank is an FDIC-insured, certified bank and B Corp offering products tailored to socially conscious investors. Locus Bank is a majority-owned subsidiary of Locus. Member FDIC. Equal Housing Lender. Learn more at www.locusimpact.org. 

Position Overview:

Locus’ Impact Investment Services (IIS) team supports foundations and community development investors in their pursuit of impact goals by helping them to design, develop and manage guarantee programs and other investment funds.

As a key member of the Impact Investment Services team, the Data & Compliance Analyst will work collaboratively with Locus colleagues to automate data analysis and create and manage reporting for guarantee and investment funds managed by Locus. This position will play an important role in the rollout of a new database including implementing data feeds and automated reporting. This will require proficient knowledge of the business area supported, well-developed data and analysis skills, along with expert knowledge of and experience with several of the most widely-used management information tools for data reporting, visualization, and analysis.

Requirements

Essential Duties and Responsibilities:

• Work collaboratively to lead data analytics and compliance for the IIS team.
• Partner with the IIS team to translate data into tools, metrics, and dashboards for insights and data visualization.
• Create reports for internal team members, external clients, and a variety of stakeholders including Locus board members.
• Interface with internal and external parties to create reports (recurring and ad hoc) that reflect fund objectives and other business needs. Work with team members to identify report objectives and then identify, collect, analyze, and visualize data with graphs, infographics, and other methods. Edit and modify said reports as required.
• Automate monthly, quarterly, and annual reports from a variety of data sources.
• Manage and standardize data input files; teach users to adopt data management best practices re: formatting, consistency and completeness of data.
• Ensure external data from third parties is complete, organized, and delivered on time.
• Identify, research, and resolve data anomalies to ensure data quality; work with internal and external stakeholders to maintain quality data input.
• Maintain and update compliance frameworks ensuring alignment with organization standards and contractual agreements regarding data and reporting on various funds.
• Identify opportunities to streamline and enhance compliance processes through technology or procedural improvements; collaborate with cross-functional teams to implement these solutions.
• Seek to understand business needs to ensure that analytics and reporting are meaningful and aligned to business objectives.
• Leverage Azure and other data sources to automate reporting and analysis.
• Display complex qualitative and quantitative data in a simple, intuitive format and to present findings in a clear and concise manner.
• Utilize knowledge of process and systems to advise cross-functional teams on data capture and analysis.
• Model and document data management best practices for organization wide adoption.

Qualifications:

Experience, Education/Certifications

• Five years of progressive experience in financial services and/or data analytics, including experience with data sourcing/extraction/validation, database design and/or maintenance, and extensive front end report development experience.
• Advanced knowledge of Power BI, Excel Power Query, and SQL; Creator/Power User expertise for Power BI strongly preferred.
• Advanced experience with modern relational databases including MS Azure SQL; Expert knowledge of databases and the norms for data-management practices strongly preferred.
• Knowledge of financial data including loans, interest rates, guarantees, and other finance tools preferred
• Experience with Salesforce or other CRM tools is a plus.
• Bachelor's degree preferred, ideally in a quantitative field such as Data Analytics, Statistics, Mathematics, Economics, or Finance.

Computer/Technology:

• Excellent Word, Excel, and Windows file management skills mandatory
• Strong technical experience with Salesforce or other CRM tools
• Demonstrated web research skills
• Familiarity with Outlook or similar network-based email and calendar software
• Extensive computer usage and Microsoft Teams communication
• Must be able to work independently in a stable remote environment

Communication:

• Ability to communicate verbally across all levels of the organization in a clear, concise and confident manner.
• Ability to write accurate, clear and organized communications, incorporating a range of information and analysis. Ability to document workflow and procedures.

Mission/Vision/Organizational Values:

• Live and represent the values and mission of the organization – keeping diverse, equitable, and inclusive impact at the center of all efforts and execution
• Strong analytical and interpersonal skills with a demonstrated ability to establish and maintain effective working relationship with others and successfully interact with people at all management and support levels, as well as people of diverse socio-economic backgrounds
• Ability to organize and prioritize work activities to meet deadlines and ensure high quality work products
• High level of adaptability and flexibility required
• Ability to travel as required
• Alignment with the organizational goals:
• Sensitivity to racial, gender, sexual orientation and cultural differences and treat everyone with dignity and respect
• Effective, respectful, and timely communications with internal and external stakeholders
• Analytic, thoughtful and strategic thinking and thoroughly aware of organizational goals and strategic direction. Must have the ability to switch roles and procedures easily to facilitate change in line with organizational priorities.
• Consider the mission, objectives, and goals of Locus and demonstrate an understanding of the impact of their decisions and behavior on the organization
• Access to high-speed internet bandwidth and reasonable proximity to a Locus office or a major metropolitan airport.

 Compensation and Benefits:

• $120,000 - $135,000 annually, depending on skills and experience
• Annual bonus opportunity
• 17 days of PTO per year 
• 13 paid holidays per year
• Medical, dental, vision, short- and long-term disability insurance
• Life Insurance
• Paid Family Leave options
• 401k savings plan with employer match
• Hybrid Remote (for candidates within driving distance of Locus offices in Richmond or Christiansburg, Va.) 

Locus prefers applicants in states where business relationships have already been established, they include Virginia, New York, New Jersey, Nebraska, North Carolina, Massachusetts, Kansas, Tennessee, West Virginia, California, Georgia, Pennsylvania, Missouri, and DC.   All applicants must be authorized to work for ANY employer in the United States.  Locus does not provide sponsorship or take over sponsorship of any employment Visa.  

EEO Statement

Locus is an Equal Opportunity Employer. Locus does not discriminate in hiring or employment practices on the basis of race, color, religion, gender, age, sexual orientation, marital or family status, national origin, non-job-related disability, or status as a veteran.  

Salary : $120,000 - $135,000