JOB DESCRIPTIONTitle: Senior / Clinical Data and Coding AnalystFLSA Category: ExemptReports To: Senior Director, Clinical Informatics & Health ITJOB SUMMARYGreater 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 & Responsibilities1. 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.
TravelMust be able to travel between Greater Baden Medical Services, Inc. locations as required.
