Salesforce Data Analyst, Nonprofit

Description

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 adding capacity to its technology and data team.

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, all primarily in Salesforce. The Data Analyst is responsible for providing reports to internal and external stakeholders as needed. The Data Analyst reports directly to the Director of Technology & Data Systems.

This position has geographic flexibility and will be performed remotely. The Last Mile team is fully remote and geographically dispersed 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, recommendations, impact reporting, and external communications.
• Reporting & Documentation. Build reports, dashboards, and other ad-hoc reports as needed using tools including 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 Salesforce database. Manage and maintain relevant third-party integrations. Maintain and update the database to ensure compliance with applicable 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

• High School diploma equivalency with 3 years of cumulative experience OR Associate’s degree/Bachelor’s degree with 2 years of cumulative experience OR 7 years of applicable cumulative job-specific experience required
• 3-5 years in a deeply technical role supporting analytics and data visualization for core Salesforce, NPSP, and Experience Cloud required
• Salesforce Administrator Certification or Salesforce Associate Certification (preferred)
• Proficient in Microsoft Office products (Excel, Word).
• Deep data visualization and executive presentation experience (Tableau, Power BI, Salesforce, Excel, etc.)

Knowledge, Skills, and Abilities

• Strong problem-solving skills and cross-functional partnership
• Understanding of relational databases
• Strong quantitative skills, including statistical analysis, and attention to detail
• Strong written and verbal communication skills
• Ability to diagram workflow requirements with non-technical staff
• Ability to manage multiple projects and prioritize tasks simultaneously
• Ability to explain technical information to a broad audience
• Highly organized with the ability to manage competing priorities, advocate for and deliver an analytic roadmap for Salesforce efforts
• 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 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 insurance 100% employer paid
• 401k retirement plan with up to a 6% employer match
• 4 weeks of paid vacation leave
• 18 paid holidays
• And more!!

Last Mile does not discriminate on the basis of race, ethnicity, national origin, religion, gender, age, disability, citizenship, marital status, creed, sexual orientation, gender expression or identity, or any other characteristic protected by federal, state, or local laws in the delivery of services or employment practices.