Apply on Employer Site

CDW · 1 day ago

Senior Clinical Data Business Analyst

Rockville, MD

Full-time

Hybrid

Senior Level

$45/hr - $75/hr

5+ years exp

CDW is a technology solutions provider, and they are seeking a Senior Clinical Data Business Analyst to enhance data quality and operational processes in healthcare. The role involves mapping clinical operations, implementing data quality rules, and producing dashboards for leadership decision-making.

AnalyticsArtificial Intelligence (AI)Cyber SecurityGraphic DesignHardwareInformation TechnologySoftware

No H1B

Hiring Manager

Nick Williams

Responsibilities

Run stakeholder workshops and document current-state process maps by role (therapist, clinical admin, billing, scheduling, intake, managers)

Create data lineage and source-of-truth maps for key entities: sessions/appointments, attendance/hours provided, cancellations/reschedules, approved hours, authorizations, and claims/billing

Identify gaps and failure modes (where fields are blank/incorrect, delayed, or lost during integrations)

Define process gates (required fields, validation rules, approval steps, business rules, timestamps) to prevent dirty data entering downstream systems

Design and specify interface/ETL improvements (HiRasmus ? Lumary/Salesforce ? billing system / NetSuite / insurers). Document API/field mappings and transformation rules

Build pragmatic, prioritized quick wins: data quality queries, nightly reconciliation jobs, dashboards, alerts for exceptions and missing authorizations

Create and maintain a Data Dictionary and Data Quality rules (completeness, timeliness, uniqueness, accuracy)

Implement reconciliation and exception workflows (automated where possible) and tie them into ticketing/escalation (HelpScout/Jira)

Partner with IT / integration engineers to implement validation rules (Salesforce validation rules/flows, middleware transforms, Workday provisioning impacts)

Produce dashboards and reports for leadership showing operational KPIs and data-quality metrics

Provide training and change management to clinician and admin roles on the new data gates and workflows

Ensure solutions support HIPAA and PHI handling best practices and documentation

Qualification

SalesforceSQLETL toolsData analysisHealthcare billingData governanceBI & visualizationStakeholder facilitationHIPAA knowledgePythonTelehealth experienceDocumentation skills

Required

5–8+ years business systems / data analysis experience in healthcare or behavioral health environments

Hands-on experience with Salesforce (admin and/or analyst), preferably with Lumary, Salesforce Health Cloud, or care-management packages

Experience with HiRasmus (or similar clinical operations platforms) or implementing data flows to/from EHR/clinical platforms

Strong SQL skills for data discovery, reconciliation and reporting. Ability to write joins, aggregation, window functions

Experience with ETL / integration tooling (MuleSoft, Fivetran, Talend, Boomi, or custom API integration)

BI & visualization experience (Tableau, Power BI, Looker, or Salesforce Tableau CRM) and translating analysis into operational dashboards

Knowledge of healthcare billing and claims (payer authorizations, approved hours, billing through insurance), or experience working with revenue cycle teams

Familiarity with data governance, master data management concepts and data quality frameworks

Excellent stakeholder & workshop facilitation skills; able to map processes and drive consensus among clinicians, operations, and finance

Strong written documentation skills (process maps, data dictionaries, acceptance criteria)

Understanding of HIPAA/PHI requirements and secure handling of patient data