Data Analyst

Somerville-Cambridge Elder Services Incorporated•Somerville, MA

2d•$90,500 - $110,000•Hybrid

About The Position

The Data Analyst translates operational, financial and program data into reliable insights to strengthen service delivery, organizational performance and person-centered outcomes at Somerville-Cambridge Elder Services. The role connects data with the realities of integrated, community-based services while the organization modernizes technology and operations, transitions to a new brand and name, and undertakes strategic planning. It requires understanding complex services, funding and reimbursement models, workflows across teams and systems, inconsistent information, and 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 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, including where systems are not readily integrated. The analyst provides analysis and recommendations; designated operational, financial and technology leaders retain responsibility for decisions and implementation. The position develops and validates dashboards, scorecards and reports; analyzes program performance, workflows, revenue integrity, compliance and outcomes; and prepares decision-ready findings for leaders and the Board. It also supports technology modernization, data quality, reporting standards and organizational capacity to use performance measures. Initial priorities include inventorying systems and workflows, establishing baseline reporting for approved priorities, and implementing an initial monthly enterprise performance scorecard within the first 90–180 days. The role reports to the Chief Operating Officer and is based on-site/hybrid, with a minimum of three days onsite. Salary range: $90,500–$110,000. No visa sponsorship.

Requirements

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.
Proficiency in SQL, advanced Excel and Power BI or a comparable visualization platform; demonstrated ability to build, validate and maintain dashboards and reports.
Working knowledge of relational databases, data models, data mining and segmentation techniques.
Experience reconciling information across systems and documenting data definitions and quality controls.
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, including experience presenting findings to executive-level audiences.
Ability to manage multiple projects and prioritize deliverables in a fast-paced environment.
Must meet both CORI/SORI and public health screening requirements.

Nice To Haves

Master’s degree.
Five or more years of experience in data analytics, evaluation or applied research in nonprofit, government or healthcare settings.
Experience with additional reporting packages such as Business Objects, programming tools such as R or Python, or ETL processes.
Familiarity with accreditation and compliance data requirements such as NCQA, CMS and EOHHS.
Familiarity with Massachusetts aging services, MassHealth/Medicaid and community-based care is strongly preferred.

Responsibilities

Support the design and implementation of evaluation frameworks assessing program efficiency, effectiveness, equity, service quality and person-centered outcomes.
Partner with executive and program leaders to establish KPIs, baselines, targets and accountability measures aligned with the 2030 strategic plan.
Conduct longitudinal, cross-program and comparative analyses of demand, access, utilization, outcomes and organizational performance, and translate findings into recommendations.
Develop program scorecards for services including State Home Care, Community Choices, ECOP, SCO/One Care, Nutrition, AFC, Protective Services and housing, sequenced through the approved analytics workplan.
Analyze referral-to-assessment-to-enrollment conversion, cycle times, withdrawals, service starts and census trends; distinguish 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.
Develop, maintain and validate 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, control gaps and automation opportunities.
Clean, reconcile and validate information from disparate systems, including WellSky; 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; escalate infrastructure and security decisions to the CIO.
Support state system re-procurement, replacement or implementation by documenting 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 source-system owners.
Identify opportunities to streamline workflows, improve controls and reduce manual reporting; evaluate whether changes produce measurable benefits.
Partner with Finance, Operations and the CIO to trace data across authorizations, encounters, vendor submissions, claims, denials, payments and operational reports; identify mismatches and broken handoffs.
Validate source-to-report consistency; develop exception analyses for missing, duplicate, rejected or inconsistent records; help isolate root causes and prioritize corrections.
Design payer-, program- and service-level reporting on denials, unbilled activity, aging and recurring errors, identifying data limitations and responsible owners.
Recommend system validation rules, workflow redesign, automation and preventive controls; measure the effectiveness of implemented changes.
Support cost-per-unit, utilization and program performance analysis with Finance using approved financial data, without taking responsibility for accounting, billing or collections.
Support regulatory review and accreditation readiness with reliable datasets, evidence-based reports, compliance indicators and risk analysis for AGE, MassHealth, NCQA and other applicable bodies.
Analyze required visits, assessments, documentation timeliness, record-review findings, incidents and corrective-action trends, distinguishing confirmed findings from preliminary signals.
Partner with Quality and program leaders to identify systemic issues, track remediation milestones and assess corrective-action effectiveness.
Support development and maintenance of consumer experience, responsiveness and person-centered outcome measures, explaining available-data limitations.
Prepare concise, decision-ready performance briefs for the CEO, COO, CIO, executive leadership and Board, explaining trends, implications, root causes, recommended actions and follow-up owners.
Collaborate across Operations, Finance, Clinical Integration, Quality and IT to translate business processes into practical data requirements and improvements.
Coach managers in interpreting performance measures, spotting exceptions and using data to improve service delivery; promote common definitions and consistent reporting.
Maintain an analytics request and prioritization process aligned with the COO/CIO-approved workplan; proactively communicate progress, capacity constraints, dependencies and risks.
Perform other or related duties as assigned.
During the first 30 days, inventory priority systems, reports, workflows, data owners and recurring discrepancies, and propose a COO/CIO-approved analytics workplan.
By 60–90 days, establish baseline reporting for prioritized programs and measures, document definitions and limitations, validate source data, and identify initial trends, workflow gaps and improvement opportunities.
By 90–180 days, implement an initial monthly enterprise performance scorecard for agreed priority measures, with documented KPI definitions, repeatable validation controls and issue/remediation tracking; identify expansion dependencies and contribute data requirements and testing plans for technology modernization.
Check accuracy before publishing, meet deadlines, escalate material risks and close the loop with stakeholders.
Build trust across technical and nontechnical teams, explain findings clearly, and respect operational ownership and decision rights.
Demonstrate commitment to inclusive, person-centered community care, confidentiality and responsible use of sensitive information; further the organization’s mission and commitment to an inclusive environment.