Position: Health Data Analyst
Duration: 6 months
Location: 100% Remote

Description:

• The successful candidate will develop Ad Hoc and Automated/Scheduled reports for the client.
• The client is comprised of nine service providing divisions (San Mateo Medical Centre & Medical Clinics, Behavioural 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 County's 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.

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
• 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 clinical 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:

• 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
• NextGen's Mirth Connect (for Job Scheduling)
• Azure
• Snowflake
• BONUS
• NextGen's Mirth Connect (Interface Engine)
• Working with Lyniate (NextGate) EMPI
• Informatica
• Active Directory
• Workday
• ServiceNow
• MS Power Apps

Education & Experience:

• Bachelor's Degree in Data Analytics, Data Science, or Computer Science
• Equivalent experience will be considered
• Knowledge, Skills, & Abilities
• Logically troubleshoots reporting issues
• Presents multiple solutions, and their trade-offs, to teammates and customers
• Performs report validation and verification
• Recognizes when requests are connected to larger efforts
• Asks good questions
• Extrapolates information to new situations
• Manages work on multiple tasks within the same timeframe
• Optimizes reports for usability
• Has strong requirements gathering skills
• Has strong investigative and problem-solving skills

Preference will be given to individuals with experience in:

• county government,
• local jurisdiction health department,
• Health IT, and/or