Senior Business and Data Analyst

This is a fully remote position, open to applicants in Massachusetts.

📋 Description

• Write and execute SQL on a daily basis to analyze source data, validate assumptions, measure data quality, and design logic prototypes.

• Evaluate source data for field population, distributions, key integrity, duplicates, outliers, and gaps.

• Reconcile and validate results against source systems and client benchmarks, investigate discrepancies to identify root causes, and document findings.

• Define and document business metrics and KPIs, which include numerator, denominator, inclusion/exclusion logic, time basis, and granularity.

• Conduct exploratory and root-cause analysis, providing quantified recommendations.

• Generate data profiling reports, analysis presentations, and visualizations.

• Lead discovery and requirements-gathering sessions for various use cases.

• Convert use cases into clear, testable requirements and ensure traceability from business needs through to testing.

• Document source-to-target mappings, transformation logic, business rules, test conditions, and expected outcomes.

• Suggest dataset granularity and structure while evaluating downstream impacts.

• Identify dependencies and impacts across workstreams; escalate these to the Business Solution Manager.

• Recognize and cultivate reusable patterns across clients, states, and use cases.

• Present analysis outcomes, data quality findings, and recommendations to client stakeholders.

• Represent client intentions throughout the delivery process and act as the primary point of contact for assigned use cases.

• Facilitate communication between business and technical audiences.

• Connect clients and internal delivery teams concerning assigned workstreams.

• Serve as the subject matter expert in business and data analysis for Solution Architects, Product, QA, Account Management, and Program Management.

• Assist QA and UAT with validation queries, expected results, variance analysis, and defect triage.

• Remain aware of broader engagement impacts and flag any ripple effects.

⛳️ Requirements

• Bachelor's degree or equivalent relevant experience.

• 5+ years of experience in the US healthcare domain, specifically with healthcare data.

• Direct experience working with or for a US health plan (Medicare, Medicaid, or Commercial), either in-house or through healthcare consulting.

• Proficient understanding of core payer concepts such as membership/enrollment, provider, claims, and authorizations.

• Strong hands-on SQL skills, including joins across large multi-table datasets, window functions, CTEs, aggregations, and date/span logic.

• Proven analytical rigor, including data profiling, data quality assessment, root-cause analysis, and effective communication of quantified findings.

• Experience in defining metrics, mentoring junior analysts, and eliciting and drafting business requirements in complex, data-driven environments.

• Confident in client-facing communication with both technical and non-technical audiences.

• Ability to work effectively in ambiguous situations and re-prioritize tasks while managing multiple use cases.

• Experience in designing for reuse and scalability across states, clients, or use cases, while tracing impacts across a data ecosystem.

• Familiarity with Databricks or Snowflake is preferred.

• Must be authorized to work in the United States.

🏝️ Benefits

• Unlimited paid time off – recharge when you need it.

• Work from anywhere – flexibility to fit your lifestyle.

• Comprehensive health coverage – multiple plan options available.

• Equity for every employee – share in our success.

• Growth-focused environment – your development is important to us.

• Home office setup allowance – one-time support to help you get started.

• Monthly cell phone allowance – stay connected effortlessly.

• Eligibility for performance bonuses.

• Equity grants.