Data Analyst and Innovation Specialist

Job Description

Job Description

Want to use your data skills to drive real impact?

ECS is hiring a Data Analyst & Innovation Specialist (Impact & BI Lead)—a role where you’ll go beyond dashboards to help shape how an entire organization thinks, learns, and improves.

You’ll work alongside program leaders, build powerful Power BI tools, and help turn complex data into clear, 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

—we’d love to meet you!

Job Summary: The Data Analyst & Innovation Specialist (Impact and BI Lead) at ECS is a pivotal role that drives the development of data analysis tools and processes to foster deep data learning and innovation. This position is responsible for managing data reporting and analysis for funder reporting and internal data learning, aimed at enhancing program improvements and impact. Additionally, this role oversees the development and management of 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 PowerBIand 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 PowerBI.
• 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 motivating work environment and encourages individual professional development. We provide 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. 

Please review the attached job description for a detailed review of this role. Duties, responsibilities and activities may change at any time with or without notice.