Strategic Data Analyst – Hybrid, Performance Insights

Cambridge Nonprofit Coalition; Somerville (MA); Hybrid; USD 91,000 - 110,000; Full time

Job summary

Somerville-Cambridge Elder Services is seeking a Data Analyst to translate operational, financial and program data into reliable insights that strengthen service delivery and organizational performance. The role requires understanding complex funding and workflows, with focus on dashboards and data quality using Power BI, SQL and Excel.

Reporting to the COO and collaborating with CIO and leadership, the analyst supports the 2030 strategic plan, performance measurement and executive

Qualifications

• Bachelor’s degree in data science, public policy, public health, statistics, computer science or a related field.
• At least three years of experience in data analytics, evaluation or applied research in nonprofit, government or healthcare settings; five or more years preferred.
• Proficiency in SQL, advanced Excel and Power BI or a comparable visualization platform, such as Tableau; demonstrated ability to build, validate and maintain dashboards and reports.
• Working knowledge of relational databases, data models, data mining and segmentation techniques, with experience reconciling information across systems and documenting data definitions and quality controls.
• Experience with additional reporting packages, such as Business Objects, programming tools such as R or Python, or ETL processes is preferred.
• Knowledge of applied statistics and experience using Excel or statistical tools to analyze datasets, explain trends and communicate analytical limitations.
• Experience with performance measurement frameworks, outcomes evaluation, and regulatory reporting.
• Strong written and verbal communication skills, with experience presenting findings to executive-level audiences.
• Ability to manage multiple projects and prioritize deliverables in a fast-paced environment.
• Familiarity with accreditation and compliance data requirements (e.g., NCQA, CMS, EOHHS) is a plus.
• Familiarity with Massachusetts aging services, MassHealth/Medicaid and community-based care is strongly preferred.

Responsibilities

• Support the design and implementation of evaluation frameworks to assess program efficiency, effectiveness, equity, service quality and person-centered outcomes.
• Partner with executive and program leaders to establish consistent key performance indicators (KPIs), baselines, targets and accountability measures aligned with the 2030 strategic plan.
• Conduct longitudinal, cross-program and comparative analyses to identify changes in demand, access, utilization, outcomes and organizational performance; translate findings into recommendations.
• Develop program scorecards for State Home Care, Community Choices, ECOP, SCO/One Care, Nutrition, AFC, Protective Services, housing and other services, sequencing delivery through the approved analytics workplan.
• Analyze referral-to-assessment-to-enrollment conversion, cycle times, withdrawals, service starts and census trends; distinguish service demand from process bottlenecks and data-quality problems.
• Evaluate caseload distribution, staffing capacity, visit completion, productivity and workflow constraints with the COO and program managers; recommend and measure improvements.
• Support environmental scanning, scenario analysis, growth planning and program redesign by connecting financial and operational trends to service delivery realities.

Skills

SQL

Excel

Power BI

Tableau

Data visualization

Education

Bachelor’s degree in data science, public policy, public health, statistics, computer science or a related field

Tools

Power BI

Tableau

SQL

ETL

Job description

Somerville-Cambridge Elder Services is seeking a Data Analyst to translate operational, financial and program data into reliable insights that strengthen service delivery and organizational performance. The role requires understanding complex funding and workflows, with focus on dashboards and data quality using Power BI, SQL and Excel.

Reporting to the COO and collaborating with CIO and leadership, the analyst supports the 2030 strategic plan, performance measurement and executive