Senior / Clinical Data and Coding Analyst
About The Position
Greater Baden Medical Services (GBMS), a Federally Qualified Health Center serving Southern Maryland, seeks a Senior / Clinical Data and Coding Analyst to lead the development, validation, and optimization of clinical data reporting and analytics. The role is a senior technical resource for SQL querying, clinical data extraction, data modeling, quality reporting, and business intelligence. The position is based in Brandywine, Maryland, with a hybrid schedule requiring three days onsite. The analyst develops and validates reports and analytics using clinical and operational data, including eClinicalWorks (eCW), eBO, Azara DRVS, SQL, and Microsoft Power BI. The role supports UDS and eCQM reporting, population health analyses, data quality and governance, and the development of sustainable reporting solutions. The analyst works independently to investigate data issues, develop complex queries, validate reporting, and communicate findings to technical and nontechnical stakeholders. Travel between GBMS locations is required as needed.
Requirements
- Bachelor’s degree in Health Informatics, Health Information Management, Computer Science, Data Analytics, Information Systems, Public Health, or a related field; equivalent relevant education and experience may be considered.
- At least five years of progressively responsible healthcare analytics, clinical reporting, business intelligence, or related technical experience.
- Demonstrated advanced SQL querying against relational databases.
- Hands-on Power BI dashboard development experience.
- Experience analyzing EHR-generated data, validating report accuracy, reconciling datasets, and troubleshooting discrepancies.
- Familiarity with healthcare clinical quality measures and regulatory reporting.
- Ability to travel between Greater Baden Medical Services locations as required.
Nice To Haves
- Direct experience with eClinicalWorks (eCW), particularly eBO reporting.
- Hands-on Azara DRVS experience.
- Experience with HRSA UDS, eCQMs, measure specifications, and FQHC or community health center reporting.
- Advanced Microsoft SQL Server/SSMS, Power BI DAX, Power Query, and Power BI Service experience.
- Experience developing reporting databases or ETL/ELT solutions.
- Knowledge of ICD-10, CPT, HCPCS, LOINC, SNOMED CT, HL7, FHIR, or QRDA.
- Population health or value-based care experience.
- Relevant master’s degree or Power BI certification.
Responsibilities
- 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, and automate recurring data processes.
- Partner with IT, vendors, and consultants to improve data accessibility, integrity, and reporting infrastructure.
- 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 and collaborate on improvements to structured data capture.
- 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, and support eCQM extraction and submission readiness.
- Collaborate with Quality and Clinical Operations on performance monitoring and patient- and provider-level analyses.
- 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.
- 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.
- 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, and handle protected health information in accordance with HIPAA and GBMS policy.
- 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.
- Travel between Greater Baden Medical Services locations as required.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
