Job ID: MS-102592 (90090411)
Onsite EHR (must) .Net Developer with C#, SQL Server, Azure, Python, Report Builder, Oracle, ActiveX, QA, API testing, Electronic Health Records experience
Location: Jackson MS (MSDH)
Duration: 6 months
Microsoft WindowsIntermediateRequired
Windows ServerIntermediateRequired
LinuxIntermediatePreferred
Programming Language/Development Tools
C#IntermediateRequired
SQL ServerIntermediateRequired
Microsoft Visual StudiosIntermediateRequired
AzureIntermediateRequired
PythonIntermediatePreferred
Database Systems/Database Tools
Microsoft SQL ServerIntermediateRequired
SQL Management StudioIntermediateRequired
Report BuilderIntermediateRequired
OracleIntermediatePreferred
Framework/SLD/Methodology
.NETIntermediateRequired
ActiveXIntermediatePreferred
QA/Testing – Approaches, Application
API TestingIntermediatePreferred
Dynamic approachIntermediateRequired
Required Skills/Experience
-familiar with various electronic health record systems
-familiar with healthcare reporting
-able to develop queries and SQL scripts based upon the R03.3 code algorithm
-customer service skills
Background:
The Mississippi Delta Health Collaborative (MDHC) and Heart Disease and Stroke Prevention Program (HDSPP) was charged with supporting healthcare systems with identifying patients with undiagnosed hypertension hiding in plain sight (HIPS). The Centers for Disease Control (CDC) recommends exploring and testing innovative ways to promote the adoption of evidence-based quality measurement at the provider level (e.g., use dashboard measures to monitor health outcomes among high burden subpopulations and implement related activities).
To support this strategy, the MDHC and HDSPP defined the high-burden sub-population as ‘patients at delta clinics aged 30-59 with intake BP >140/90; 2 or > missed physician visits, and 2 or more chronic disease diagnoses.’ Having defined this subpopulation, the next step was to determine how the sites can track, flag, and report this subgroup of patients. This process was complicated because there is not a unique ICD-10-CM code which encompasses all the criteria used to define this sub- population. Furthermore, clinics using Athena electronic health records were difficult because Athena does not allow direct access to query the database. Therefore, queries and SQL scripts based upon the R03.0 code algorithm were written to enable partnering clinics to identify and extract accurate data for this defined sub-population. Report templates were also developed to aggregate all data into a clean, manageable format.
Services Required:
Maintain current tools used to query and extract data
Develop queries and SQL scripts based upon the R03.3 code algorithm and assist in onboarding new reporting sites
If needed in urgent cases, conduct virtual Technical Assistance (TA), which includes developing reports, with the MDHC
and clinics for accurate extraction of program data and in response to dashboard glitches or challenges
Provide reports to the MDHC Health Information Manager when work is performed and document the following:
o Updates on progress of tasks.
o Log detailing contact with the MDHC partnering clinics.
o Key findings and results of the TA site visits.
Participate in bi-monthly meetings via conference call with the MDHC Health Information Manager and Office of Health
Information Technology, as needed. *Meeting frequency may occasionally vary
Develop reports upon request by the MDHC Health Information Manager.