Data Analyst at Somerville-Cambridge Elder Services
Somerville, MA — full-time
The Data Analyst translates operational, financial and program data into reliable insights that strengthen service delivery, organizational performance and person-centered outcomes at Somerville-Cambridge Elder Services. As the organization modernizes its technology and operations, transitions to a new brand and name, and launches its strategic planning process, the analyst connects data with the realities of delivering integrated, community-based services. The role requires understanding complex services; funding and reimbursement models; tracing workflows across teams and systems; investigating inconsistent information; and recommending practical improvements to workflows, controls, automation and outcomes. Reporting to the Chief Operating Officer and working closely with the fractional Chief Information Officer, CEO, Finance, Quality and Program leadership, the analyst develops reliable measures of access, service quality, compliance, productivity, revenue integrity and organizational performance. The role supports the 2030 strategic planning process, executive decision-making and Board oversight, particularly where systems do not readily integrate. The analyst provides analysis and recommendations, while designated operational, financial and technology leaders retain responsibility for decisions and implementation. Job Responsibilities and Performance Standards Program Evaluation and Strategic Analysis 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. Data Management, Visualization and Reporting Develop, maintain and validate accessible dashboards, scorecards and executive reports using Power BI or comparable tools, SQL and advanced Excel. Map end-to-end workflows and data lineage across operational, clinical, f