EHR Data Analyst

Equal Opportunity Employer

The mission of the Health Federation of Philadelphia is to promote health equity for marginalized communities by advancing access to high-quality, integrated, and comprehensive health and human services.  Health equity is at the heart of all our work. We believe in and are firmly committed to equal employment opportunity for employees and applicants. We do not discriminate on the basis of race, color, national or ethnic origin, ancestry, age, religion, disability, sex or gender, gender identity and/or expression, sexual orientation, military or veteran status.  This commitment applies to all aspects of the Health Federation of Philadelphia’s employment practices, including recruiting, hiring, training, and promotion.

JOB SUMMARY

The Electronic Health Records (EHR) Data Analyst will utilize a systematic approach and advanced tools to design, develop and support data management services for the Philadelphia Department of Public Health, Ambulatory Health Services (AHS), a large community health organization.  The EHR Data Analyst will be responsible for data request intake, requirements definition, approvals, analytic methods, implementation, delivery and monitoring to deliver advanced data analysis, performance measurement and custom reports to support internal and external requests for clinical, operational and policy insights. The position requires skills and knowledge to manage, analyze, report, distribute and protect EHR related data.  This position works directly with AHS Leadership, EHR Program Management Office (EHR PMO) Program staff, and respective partner personnel to support comprehensive planning and tactical delivery of data analytic services in production operations.  In addition, responsibilities include Tier 2 and Tier 3 support for EHR production issues and Helpdesk tickets regarding data, visualization, and respective services. 

Strategic direction, programmatic and operational prioritization will be specified through the authority of AHS Leadership. Accountability is managed through the EHR PMO with AHS oversight.

JOB SPECIFICATIONS

Responsibilities/Duties

  • Support the design, development, deployment, and ongoing management of AHS data requests and related work.  Work with EHR PMO to integrate data management strategies for projects, programs, and initiatives.
  • Participate in the design, development, deployment, and support of relational and non-relational database designs in a team-oriented environment using various data visualization tools in accordance with City OIT standards.
  • Serve as the analytic intermediary between staff, departments and vendors for various database solutions and datasets within on-premises and cloud hosted systems.
  • Participate in the design and implementation of integration points for automated retrieval, sharing and delivery of incoming and outgoing data.
  • Assist with data conversion, migration, and validation of data to ensure quality and accuracy.
  • Develop Standard Operating Procedures (SOPs) for EHR data management and related system administration to establish and maintain standards and procedures to support consistent practices. 
  • Abide by the EHR PMO change control policies and procedures while ensuring change control methods are congruent with overall Health IT and OIT procedures; Submit and present various changes related to AHS data management.
  • Understand and support monitoring, backup and recovery operations for database environments to maintain business continuity.
  • Monitor performance of database related systems to ensure system and data integrity
  • Perform root cause analyses and troubleshoot internal and external data-related problems. 
  • Aid in the support/writing/configuration of data transformation services (DTS) and extract, transform, load (ETL) packages, Web Services, and SQL database objects.
  • Assist AHS in developing and conducting presentations related to data management.
  • Maintain working relationships with AHS, EHR, HIT, City OIT, and Partner staff including regular status communications using EHR and AHS methods of communication.
  • Provide off-hours support for upgrades, problem resolution, outages, or disaster recovery events as needed. 
  • Stay current with data management tools as departmental infrastructure evolves.
  • Assist AHS leadership & staff as needed to define opportunities for enhanced analytics and data visualization.
  • Perform other data management and analysis duties as required.

Education

  • Bachelors Degree in Computer Science/Information Systems, Data Analytics, or related experience in the field.
  • Industry related certificates or certification a plus

Skills/Experience

  • Demonstrated knowledge of the Systems Development Life Cycle
  • 3-5 years of experience working with SQL Server (2016 or later), Oracle SQL developer, and related products
  • Three (3) years working in health services related field
  • Working knowledge of HIPAA/HITECH regulations
  • In depth understanding of conceptual, logical, and physical database structures
  • Ability to translate, integrate, and export data from various cross-platform software and databases
  • Strong analytical skills including experience with tools for Business Intelligence; analytics; dashboards; reporting
  • Well-developed computer skills including: Office365, Visio, entity relational diagrams
  • Effective organizational skills, detail-oriented
  • Excellent communication and presentation skills, both written and oral
  • Well-developed interpersonal skills including proper phone etiquette
  • Ability to work independently, be flexible and handle multiple tasks
  • Ability to work with a variety of cultures and diverse audiences

Additional proficiencies not required, but preferred

  • Experience with FQHC, ambulatory, municipal government and/or public health
  • Knowledge of healthcare, medical, lab and/or public health terminology
  • Experience with EHR systems, experience with eClinicalWorks is a plus
  • Experience with Microsoft SQL, Oracle database, Azure Synapse Analytics, and other multi-model database management or data warehouse systems
  • Experience with log shipping, SQL back-up restore, SFTP, or other data sharing processes
  • Exposure to data visualization software such as Tableau, Power BI, Red Cap, Quickbase, etc.

Work Environment

  • Standard office setting with extended periods at work station and periodic use of office equipment

Position Type and Work Schedule

  • Full time position, typical hours are Monday through Friday 8:30 am to 5:00 pm.  Flex office schedule options available with supervisor approval.

Travel

  • Local travel to multiple sites could be required for periodic implementations, upgrades, outages or onsite meetings.

Physical Demands

  • Ability to manage in an office environment located in a City health center.
  • Ability to work in a cubicle or shared space environment.
  • Ability to travel between city locations.
  • Ability to lift up to 30 pounds.
  • Ability to work in a fast paced, high pressure setting.
  • Ability to tolerate extensive use of keyboard, typing, computer.

Salary and Benefits

Our employees are our most valuable resource, so we offer a competitive and comprehensive benefits package, which can include:

  • Medical with vision benefits
  • Dental insurance
  • Flexible spending accounts
  • Life, AD&D and long term care insurance
  • Short- and long-term disability insurance
  • 403(b) Retirement Plan, with a company contribution
  • Paid time off including vacation, sick, personal and holiday
  • Employee Assistance Program

Eligibility and participation is consistent with the plan documents and HFP policy. 

DISCLAIMER

The Health Federation reserves the right to modify, interpret, or apply this job description in any way the Company desires. The above statements are intended to describe the general nature and level of work being performed by an employee assigned to this position. This job description in no way implies that these are the only duties, including essential duties, responsibilities and/or skills to be performed by the employee occupying this position. This job description is not an employment contract, implied, or otherwise. The employment relationship remains “at will.” The aforementioned job requirements are subject to change to reasonably accommodate qualified disabled individuals.