| Remote Position : Health Data Analyst at Remote, Remote, USA |
| Email: [email protected] |
| From: Sachin, Sspearhead Inc. [email protected] Reply to: [email protected] Job Details: Remote Position : Health Data Analyst Assignment Start Date: Immediate start Duration of Contract: 6 months Interview Type Requested: In person, WebEx or Skype Work Location: SanMateo, CA (This is an REMOTE position.) Remote/Telework Details Must reside & work within US borders Must work Pacific Time Zone business hours Must have distraction free, private workspace Must have reliable high speed internet connection Must be able to pick up laptop from South San Francisco, CA or arrange for secure transport This position is limited to 40 hours per week, and cannot work during County holidays SCOPE OF SERVICES The successful candidate will develop Ad Hoc and Automated/Scheduled reports for San Mateo County Health (SMCH). SMCH is comprised of nine service providing divisions (San Mateo Medical Center & Medical Clinics, Behavioral Health and Recovery Clinics, Aging and Adult Services, Public Health, Environmental Health, Family Health, EMS, Correctional Health, and Healthcare Coverage) and five support divisions (Admin, Communications, Finance, Health IT, and LEAP Institute). This position will work on reports for all San Mateo County Health divisions, with a heavy focus on Hospital financial and operational reporting. Reports are primarily written in TSQL and are scheduled using Mirth Connect. The report inputs are primarily MS SQL databases and csv datasets from multiple eHR applications. The reports are primarily output into Excel Pivot Tables, csv data sets, or PowerBI dashboards. The position will monitor automated jobs for success and respond as necessary. This position could also be working with Health IT staff to automate data engineering ELT (Extract-Load-Transform) tasks, document current data processes, and other duties as assigned. Performance will be judged on 1) report/dashboard accuracy 2) report/dashboard usability 3) end user assessment of communications 4) peer assessment of communications 5) timeliness of deliverables. Examples of Duties Programming in SQL Gathering requirements Designing reports Troubleshooting errors Scheduling jobs Verification and validation of reports De-identifying data Creating graphs Requirements REQUIRED EXPERIENCE -- Producing health operations reports -- Producing health finance reports -- Producing complex reports -- Creating/supporting SQL procedures and job scheduling scripts -- Knowledge of health, and health finance, terminology -- Knowledge of health privacy regulations (HIPAA, 42CFR Part II, etc.) PREFERRED EXPERIENCE -- Working with eClinical Works (eCW) Data Structures -- Working with Cerner/Soarian/DSS Data Structures & Tools -- Working with Envision financial, revenue, and reconciliation reporting -- Working with State and Federal reporting programs, including: GPP, UDS, QIP, & FQHC -- Producing Audit and Compliance reports -- Optimizing SQL queries and databases BONUS EXPERIENCE -- Programming in C#, R, or Python -- Working with EPIC Data Structures & Tools -- Managing a Master Patient Index (MPI) -- Managing a Health Information Exchange (HIE) -- Interfacing systems using HL7 v2, v3, & FHIR -- Producing Crystal Reports -- Performing Statistical Analytics -- Working with Medicare, Medi-Cal, Health Plan of San Mateo (HPSM) -- Working with state & federal system data structures (CAIR2, CalREDDIE, ARIES, etc.) Qualifications REQUIRED -- MS-SQL Server tool set (SSIS/SSMS) -- MS-SQL language/T-SQL -- Advance Excel (Pivot Tables, etc.) -- Power BI -- Scripting Languages (PowerShell, VB, JavaScript, etc.) -- SFTP -- O365 Office Suite -- SharePoint -- MS Teams PREFERRED -- Datawatch -- NextGens Mirth Connect (for Job Scheduling) -- Azure -- Snowflake BONUS -- NextGens Mirth Connect (Interface Engine) -- Working with Lyniate (NextGate) EMPI -- Informatica -- Active Directory -- WorkDay -- ServiceNow -- MS Power Apps MAJOR PLUS Sorian Clinical and knowledge of Avitar and Pulse Healthcare. Education & Experience Bachelors Degree in Data Analytics, Data Science, or Computer Science Equivalent experience will be considered Knowledge, Skills, & Abilities 1. Logically troubleshoots reporting issues 2. Presents multiple solutions, and their trade-offs, to teammates and customers 3. Performs report validation and verification 4. Recognizes when requests are connected to larger efforts 5. Asks good questions 6. Extrapolates information to new situations 7. Manages work on multiple tasks within the same timeframe 8. Optimizes reports for useability 9. Has strong requirements gathering skills 10. Has strong investigative and problem-solving skills Additional Information Preference will be given to individuals with experience in: 1) county government, 2) local jurisdiction health department, 3) Health IT, and/or 4) San Mateo County Health (preference goes from low to high as enumerated). Thanks, Anoop Sspearhead Inc. www.Sspearhead.com Keywords: csharp business intelligence active directory rlang information technology microsoft California Delaware |
| [email protected] View all |
| Wed Feb 22 01:48:00 UTC 2023 |