Remote Sql Developer Data Analyst Jobs in Pennsylvania

Description

ABOUT REINVESTMENT FUND:

At Reinvestment Fund, we are dedicated to making a tangible difference in the lives of underserved individuals and communities. Our mission is to create opportunity for underserved people and places through partnerships. We marshal the capital, analytics, and expertise necessary to build strong, healthy, and more equitable communities.

As a federally certified community development financial institution (CDFI), our job is to make finance an agent of positive change and equitable growth. We provide loans, grants and technical assistance to businesses and nonprofits. Our borrowers and grantees educate students, support local economies, and create jobs. They build affordable housing and provide community goods and services that include access to nutritious food, hunger relief, physical and mental health care, and other social services.

ABOUT THE POSITION:
Reinvestment Fund seeks a Civic Data Director to serve as departmental lead on production of interactive mapping tools and static graphics for clients.

RESPONSIBILITIES:

• Serve as departmental lead on production of interactive mapping tools and static graphics for clients. 
• Lead quantitative and geographic analysis components for selected external research projects with complex data needs and interactive deliverables. 
• Develop and advise staff on design guidelines. 
• Delegate data processing tasks to junior staff and ensure quality and accuracy of results. 
• Acquire and integrate essential and novel datasets into database. 
• Monitor data releases and updates. 
• Lead timely data imports and integrate into existing databases.
• Research new and substitute data sources as necessary. 
• Present new databases and data tools to internal users. 
• Refine and oversee use of department resources hub that stores a wide range of team's intellectual properties, including research methodologies, code templates, mapping and graphics standards. 
• Provide support to guide proper and full utilization of available resources. 
• Work with managers and project teams to identify gaps based on changing needs. 
• Design and implement database improvements by continually analyzing infrastructure of civic databases (including geodatabase) and processes. 
• Plan and oversee improvements to workflow, QA/QC, processing and retrieval speeds, and automation. 
• Remain up-to-date on best practices and technological solutions most suitable to unique databases needs for the department. 
• Monitor and respond to emerging department data needs. 
• Implement transformational projects and manage phasing to ensure operational continuity. 
• Lead technical training by developing, updating, and overseeing use of technical training materials. 
• Orient new staff to data environment. 
• Lead weekly code reviews for analysts to execute collaborative problem-solving, innovative practices, and cross-training. 
• Solicit targeted team feedback to keep training relevant and practical to day-to-day tasks. 
• Serve as departmental lead on all collaboration with IT, PolicyMap, Lending/Programs Department Data & Analytics group, and external tech support teams (e.g., ESRI) to address any issues related to database design and management, SQL, and other technology tools. 
• Represent Policy Solutions as subject matter expert on civic data management and use. 

Requirements

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• U.S. Master's degree (or foreign degree equivalent) in City and Regional Planning, or related urban planning field.
• 3 years of experience in the job offered or related occupation.
• Advanced experience designing and executing geographic and statistical analysis within an SQL programming environment.
• Experience identifying data infrastructure needs and implementing solutions within an SQL programming environment.
• Experience bridging the needs and skills of technical, program, and business operations staff. 
• Advanced knowledge in applied research across multiple dimensions of community development such as housing markets, early childhood education, food access, and cultural institutions.

WORK LOCATION:

Philadelphia, PA. May work remotely for 3 days/week but must live within normal commuting distance to the Philadelphia office.

COMPENSATION AND BENEFITS:

Reinvestment Fund offers a competitive salary based on experience and skills, as well as an excellent benefits package including employer-paid health, disability, and life insurance, 401(k) savings plan with employer match, flexible spending accounts (medical, dependent care and transportation), tuition reimbursement, paid time off, and EAP program.

If hired, employee will be in an "at-will position" and the Company reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, Company or individual department/team performance, and market factors.

Reinvestment Fund is an Equal Opportunity Employer. We do not discriminate in hiring or employment practices based on race, color, religion, gender, age, sexual orientation, marital or familial status, national origin, non-job-related disability, or status as a veteran.  Reinvestment Fund is committed to belonging, culture and engagement throughout our organization and in our external investment practices.