Data Analyst and Innovation Specialist

Episcopal Community Services; Philadelphia (Philadelphia County); Hybrid; USD 65,000 - 75,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Disability insurance

Life insurance

Tuition reimbursement

Flexible spending accounts

Professional development

Transportation subsidy

Cellphone subsidy

401(k) retirement plan

Paid holidays

Home purchase grants

Employee assistance programs

Winter break

Job summary

Episcopal Community Services in Philadelphia, PA, seeks a Data Analyst and Innovation Specialist to shape data-driven decision making. You will build Power BI dashboards, transform complex data into actionable insights, and support funder reporting and program learning.

This hybrid, full-time role partners with program leaders to advance evaluation, data literacy, and impact across Philadelphia.

Qualifications

• Advanced degree or equivalent significant work experience in evaluation and data reporting.
• Strong proficiency with Power BI and Excel; experience with Microsoft Office Suite.
• Experience with case management software such as CaseWorthy or ETO is preferred.
• Ability to convey complex data insights to non-technical stakeholders.

Responsibilities

• Oversee grant reporting calendar and data requests from funders and staff.
• Develop internal tools and questions to support deep data learning and program innovation.
• Present data analysis results clearly for program teams and leadership.
• Manage access and security for Power BI reports and dashboards.
• Lead staff training to improve data literacy and use of data in decision making.
• Provide mentorship to program leaders on evaluation questions and data-driven improvements.

Skills

Data analysis

Communication

Training staff

Project coordination

Education

Advanced degree

Tools

Power BI

Excel

CaseWorthy

ETO

Job description

Data Analyst and Innovation Specialist

Philadelphia, PA • Salary: $65,000.00 to $75,000.00 annually.

Data Analyst and Innovation Specialist (Impact & BI Lead) is a full‑time professional role at ECS that helps shape how an organization thinks, learns, and improves. You’ll work alongside program leaders, build powerful Power BI tools, and turn complex data into actionable insights that improve lives across Philadelphia.

If you’re energized by:

• Turning data into story and strategy
• Helping teams build confidence using data
• Working in a mission‑driven, collaborative environment

Job Summary:

The Data Analyst & Innovation Specialist (Impact and BI Lead) at ECS drives the development of data analysis tools and processes to foster deep data learning and innovation. This role manages data reporting and analysis for funder reporting and internal data learning, enhancing program improvements and impact, and oversees Power BI reporting within the Learning and Evaluation (L&E) department.

Essential Job Duties and Responsibilities:

• Grant Reporting Management: Oversee the grant reporting calendar and handle data requests from funders and the Advancement team.
• Tool Development: Lead the creation of new internal tools to enhance staff skills in deep data learning, including data analysis and the development of research questions to assess and innovate ECS’s mission strategies.
• Data Presentation and Visualization: Present data analysis results in a clear, insightful, and actionable manner for various applications, collaborating with the Data Impact Specialist as needed.
• Power BI Management: Manage access and user permissions for Power BI reporting, ensuring efficient and secure data handling.
• Report Ownership: Oversight over the development and updating of internal and program‑focused Power BI reports, including dashboards for specific programs and related output metric reports.
• Staff Training: Conduct periodic training sessions to improve data literacy among staff, helping them understand their role in data and perform deep dives into program‑specific data points.
• Program Support: Facilitate regular check‑ins with program directors to enhance their understanding and use of data reports.
• Consultation and Mentoring: Provide consultation, mentoring, and training to program leadership and staff on developing evaluation questions and adopting a data‑driven decision‑making approach.

Education and Experience

• Advanced degree or equivalent significant work experience (at least 4 years) in internal program evaluation, information management, database administration, and data analysis and reporting required. Experience working in social work, social services, and nonprofit sectors is highly desired.
• Advanced proficiency in analytical and statistical tools and software such as Power BI and Excel. Demonstrated competence in Microsoft Office Suite.
• Experience working with case management software (e.g. CaseWorthy, ETO, etc.) preferred.
• Experience in analytical and statistical tools and methods (e.g., CaseWorthy, ETO, Excel). Demonstrated competence in Microsoft Office Suite. Advanced proficiency in Power BI.
• Experience in outcomes management, logic model, and evaluation plan development.
• Ability to communicate with and train non‑evaluation staff in learning and evaluation tools and data analysis for decision‑making and quality improvement; experience teaching or training adults is a plus.
• Excellent written and oral communication skills, with the ability to translate complex technical concepts around program outcomes and impact in a way that is accessible to all audiences.
• Flexibility and ability to manage multiple assignments in a fast‑paced environment and prioritize work items.
• Excellent computer skills (including but not limited to Microsoft Office suite, Adobe products, CRM/database, and project management software).

Benefits and compensation:

ECS provides a comprehensive salary and benefits package that includes health, dental and vision insurance; short‑ and long‑term disability; life insurance; tuition reimbursement; flexible spending accounts; professional development training opportunities; transportation and cellphone subsidies; 401(k) retirement plan; generous vacation allowance; 11 paid holidays; home purchase grants; and two employee assistance programs. ECS currently observes a paid Winter break during the end of year holiday season.

Schedule: Monday – Friday with limited evenings and weekends; this hybrid position allows remote work with some structured in‑office hours required to attend meetings and training.

Duties, responsibilities and activities may change at any time with or without notice.