Data Analyst, Nonprofit

Join the Last Mile Education Fund team to help students in tech finish their degrees!

Overview of Last Mile Education Fund

The Last Mile Education Fund invests in the next generation of technology talent. We offer a disruptive approach to increasing diversity in tech and engineering fields by addressing critical gaps in financial support for college students facing obstacles to graduation. We disrupt the traditional scholarship model by investing in students based on our four pillars: Agility, Abundance, Investment Mindset, and Creating a Virtuous Circle. Last Mile is a rapidly scaling organization that is building our marketing and communications function.

Position Overview

The Data Analyst is responsible for data management, database technical support to internal and external stakeholders, and proper configuration and performance of the database. The Data Analyst is responsible for providing reports to both internal and external stakeholders as needed. The Data Analyst reports directly to the Director of Technology & Data Systems.

This position has geographic flexibility and is performed remotely. The Last Mile team is fully remote and geographically dispersed currently between Colorado, Georgia, Maryland, Michigan, Texas, and Washington. Travel is required quarterly to participate in team-wide convenings and operational meetings.

Role and Responsibilities

• Data Analytics. Leverage data and analytics to inform decision-making and recommendations, impact reporting and external communications.
• Reporting & Documentation. Build reports, dashboards, and other ad-hoc reports as needed using tools such as Salesforce, Excel, and Power BI. Document and update current and future data management processes. Develop user guides, workflow documentation, and system manuals.
• Database & Records Management. Develop new processes to improve data integrity. Clean, upload, and update existing records; eliminate duplicates. Collaborate with other departments to ensure that data is accurate and timely. Work closely with Finance to ensure the database and integrated financial applications run effectively and efficiently.

• Salesforce Administration. Maintain and ensure proper configuration and performance of the database. Manage and maintain relevant third-party integrations. Maintain and update the database to ensure compliance with relevant regulations and best practices. Manage all aspects of database user management, including new user setup/deactivation, roles, profiles, and permissions. Keep informed of new Salesforce features to provide recommendations for system improvements.
• Training & Technical Support. Train staff on data collection and management procedures and provide ongoing technical support. Provide technical support for database requests from end-users and assist with troubleshooting.

Requirements

Education and Experience Requirements

• Bachelor’s degree preferred. High school diploma with four years of job-related experience will be considered.
• Salesforce Administrator Certification or Salesforce Associate Certification (preferred)
• Proficient in Microsoft Office products (Excel, Word).

Knowledge, Skills, and Abilities

• 2+ years of experience in Salesforce administration, data analysis, and data mining

• Strong analytical skills and experience using data visualization tools including Excel and Power BI
• Strong problem-solving skills and cross-functional partnership
• Understanding of relational databases
• Strong written and verbal communication skills
• Ability to manage multiple projects and prioritize tasks simultaneously

• Ability to explain technical information to a broad audience
• Highly organized and detail oriented
• Must align with the Last Mile mission and its values of equity, ethics, human-centric, belonging, abundance, agility, and a radical approach.

Benefits

Compensation & Benefits

The Data Analyst's salary ranges from $55,000 to $65,000 commensurate with experience and education. As a member of our team, you will receive a competitive salary and an outstanding benefits package including:

• Gold health plan, dental & vision insurance (100% employer paid for employees and 90% paid for dependents!!)
• Health savings account with an employer contribution

• Short-term, long-term, and life insuran