Senior / Clinical Data and Coding Analyst

Job description

JOB DESCRIPTION
Title: Senior / Clinical Data and Coding Analyst
FLSA Category: Exempt
Reports To: Senior Director, Clinical Informatics & Health IT
Greater Baden Medical Services (GBMS) is a Federally Qualified Health Center (FQHC) dedicated to providing high-quality healthcare across Southern Maryland. With 9 clinical sites across Prince George's, Charles, and St. Mary's counties, we serve over 18,000 patients each year. We provide fully integrated care that includes primary care, pediatrics, women's health, Title X family planning, dental care, behavioral health, WIC, pharmacy services, and the Ryan White HIV/AIDS program. Our patient population is primarily made up of Medicaid and uninsured individuals. We are deeply proud to deliver these vital services to everyone in our community, regardless of their ability to pay, making Greater Baden an incredibly rewarding place to grow your career while making a tangible, life-changing impact every day.
JOB SUMMARY
Greater Baden Medical Services (GBMS), a Federally Qualified Health Center (FQHC), seeks a Senior/ Clinical Data and Coding Analyst to lead the development, validation, and optimization of clinical data reporting and analytics. The analyst will serve as a senior technical resource for SQL querying, clinical data extraction, data modeling, quality reporting, and business intelligence. The ideal candidate brings hands-on experience with eClinicalWorks (eCW), eBO reporting, SQL, Azara DRVS, Microsoft Power BI, and clinical quality measures, including Uniform Data System (UDS) and electronic Clinical Quality Measures (eCQMs). This is a hands-on role requiring independent investigation of data issues, complex query development, reporting validation, and sustainable analytics solutions. Position located in Brandywine, Maryland (Hybrid – 3 days onsite)
Essential Duties & Responsibilities
1. Clinical Data Management & SQL Analytics
• Develop, maintain, and optimize complex SQL queries to extract, transform, and analyze EHR and operational data.
• Analyze relational database structures, joins, filters, and calculations; support reporting databases, reusable views, and data models.
• Document data definitions, source-to-target mappings, technical specifications, and report logic; automate recurring data processes.
• Partner with IT, vendors, and consultants to improve data accessibility, integrity, and reporting infrastructure.

2. eClinicalWorks & eBO Reporting
• Develop, modify, and validate reports using eCW and eBO reporting tools.
• Investigate discrepancies between source EHR data and downstream reporting systems.
• Assess how documentation, data fields, and clinical workflows affect reporting accuracy; collaborate on structured data capture improvements.

3. UDS, eCQM & Clinical Quality Reporting
• Support preparation, validation, and reconciliation of UDS data in accordance with applicable HRSA requirements.
• Validate measure specifications, patient eligibility, denominators, numerators, exclusions, and exceptions.
• Investigate missing documentation, mapping issues, and reporting discrepancies; support eCQM extraction and submission readiness.
• Collaborate with Quality and Clinical Operations on performance monitoring and patient/provider-level analyses.

4. Azara DRVS & Population Health
• Validate and reconcile measures and patient populations across eCW, eBO, Azara DRVS, and other reporting sources.
• Investigate differences in encounters, registries, clinical quality measures, and other metrics.
• Develop care-gap analyses and actionable population health reports.

5. Business Intelligence & Visualization
• Build and maintain interactive Power BI dashboards, data relationships, semantic models, DAX calculations, and Power Query transformations.
• Integrate clinical, operational, and quality data; improve dashboard accuracy, performance, refresh reliability, and access controls.
• Support self-service reporting for organizational leaders and clinical teams.

6. Data Quality, Integrity & Governance
• Design repeatable checks for missing, duplicate, inconsistent, or anomalous clinical data.
• Perform root-cause analysis across documentation, extraction, transformation, and reporting logic.
• Maintain validation records and data dictionaries; handle protected health information in accordance with HIPAA and GBMS policy.

7. Collaboration & Technical Leadership
• Translate clinical, operational, and regulatory requirements into technical reporting solutions.
• Partner with Clinical Informatics, Quality, Operations, Finance, IT, and external vendors.
• Independently manage analytical deliverables and explain findings to technical and nontechnical stakeholders.

Minimum Qualifications
• Bachelor’s degree in Health Informatics, Health Information Management, Computer Science, Data Analytics, Information Systems, Public Health, or related field; equivalent relevant education and experience may be considered.
• At least five years of progressively responsible healthcare analytics, clinical reporting, BI, or related technical experience.
• Demonstrated advanced SQL querying against relational databases and hands-on Power BI dashboard development.
• Experience analyzing EHR-generated data, validating report accuracy, reconciling datasets, and troubleshooting discrepancies.
• Familiarity with healthcare clinical quality measures and regulatory reporting.

Preferred Qualifications
• Direct experience with eClinicalWorks (eCW), particularly eBO reporting; hands-on Azara DRVS experience.
• Experience with HRSA UDS, eCQMs, measure specifications, and FQHC/community health center reporting.
• Advanced Microsoft SQL Server/SSMS, Power BI DAX/Power Query/Service, and reporting database or ETL/ELT development.
• Knowledge of ICD-10, CPT, HCPCS, LOINC, SNOMED CT, HL7, FHIR, or QRDA.
• Population health/value-based care experience; relevant master’s degree or Power BI certification.

Travel
Must be able to travel between Greater Baden Medical Services, Inc. locations as required.