Programs Data Analyst

All In Energy•Lawrence, MA

5d•Hybrid

About The Position

The Programs Data Analyst role is embedded within the Programs Department to analyze and interpret program data to strengthen program delivery, improve accountability, and support organizational learning. The role serves as the primary program-side steward of the Programs Department’s internal oversight tools, ensuring dashboards, trackers, and reporting views are accurate, accessible, and aligned with program needs. The Programs Data Analyst works as an integrated subject-matter partner across the Programs and Data & Product teams. The role stays closely connected to the Data & Product team to understand existing systems, definitions, and reporting logic, while working day-to-day with program teams to gain insights to understand the story behind the numbers and to support leadership to translate data into timely, actionable insights that support implementation decisions and operational learning. This role is focused on internal analysis to support program implementation, learning, and staff coaching. Priorities for the role are set in collaboration with the Senior Director of Programs to ensure focus and sustainability.

Requirements

Commitment to racial, economic, and environmental justice.
Demonstrated experience in data analysis, program evaluation, analytics, or a related field (professional or equivalent applied experience).
Intermediate proficiency in Excel and/or Google Sheets, including pivot tables, data validation, formulas, and working with structured datasets.
Demonstrated experience working with Salesforce or a comparable Customer Relationship Management (CRM) system, including understanding how data is structured and connected; creating and modifying report types; running, exporting, and interpreting reports; and translating CRM data into meaningful Key Performance Indicators (KPI) and program performance insights, or demonstrated ability to learn comparable CRM reporting environments.
Experience creating dashboards, visualizations, or structured reporting tools (e.g., Salesforce dashboards, Tableau, Looker Studio, or similar platforms).
Highly organized, with strong documentation habits and attention to detail.
Ability to work independently with guidance, including asking questions and seeking out support as needed.
Experience operating in a cross-functional environment, partnering with multiple teams to gather requirements, clarify priorities, deliver analytical support, and collaboratively resolve data issues.
Ability to translate data into clear, accessible insights for non-technical audiences, including supporting learning, reflection, or coaching conversations.
Clear, effective communication skills, including the ability to take requirements from non-technical stakeholders and translate them into analytical plans.
Ability to manage multiple data sources and prioritize competing requests effectively.
Ability to work effectively in a hybrid role, with approximately 20% in-person time in the Lawrence office.

Nice To Haves

Familiarity with technical concepts such as CRM automation, custom fields, or reporting logic (not required).
Experience supporting program evaluation, grant reporting, or internal learning initiatives.
Experience training or coaching staff on data tools, dashboards, or data-informed practices.
Experience working in nonprofit, housing, municipal, utility, or community-based program settings.
Experience contributing to strategic planning or supporting leadership in interpreting data for higher-level decisions.
Experience designing or stewarding internal oversight tools or operational reporting systems.
Proficiency in Spanish, Portuguese, Khmer, Vietnamese, or other languages commonly spoken in Environmental Justice Communities in Massachusetts.