Data Analyst

Description

Job Title:
Data Analyst

Reports To:
Chief Operating Officer

Department:
Operations

FLSA Status:
Exempt Non-Union

Location:
On-Site/Hybrid – Minimum of three (3) days onsite

VISA:
No Visa Sponsorship

SALARY:
Range $90,500 - $110,000

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.

• 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.

• 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, financial and reporting systems; identify manual handoffs, duplicative entry, gaps in controls and opportunities for automation.
• Clean, reconcile and validate information from disparate or poorly integrated systems, including Well Sky and other agency platforms; document data definitions, assumptions, limitations and version history.
• Partner with the CIO on data dictionaries, integration requirements, reporting standards, migration readiness and sustainable reporting processes; escalating infrastructure and security decisions to the CIO.
• Support state system re-procurement, replacement or implementation initiatives by documenting operational reporting needs, validating data conversion and interfaces, testing outputs and identifying continuity risks.
• Create repeatable data quality checks and exception reports, investigate anomalies before distribution and coordinate correction with designated source-system owners.
• Identify opportunities to streamline workflows, improve process controls and reduce manual reporting; evaluate whether changes deliver measurable benefits.

• Partner with Finance, Operations and the CIO to trace data across service authorizations, encounters, vendor…