EHR Data Engineer

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 Engineer will be responsible for managing all aspects of EHR related data with a focus on database administration, data integration, and data flow design to deliver advanced clinical and operational analytics for the Philadelphia Department of Public Health, Ambulatory Health Services (AHS), a large community health organization.  The EHR Data Engineer will utilize a systematic approach and advanced tools to design and support AHS data management services. The position requires skills and knowledge to connect, store, manage, secure, analyze, report, distribute and govern EHR related data.  This position works directly with AHS Leadership, EHR Program Management Office (EHR PMO) Program staff, Health IT (HIT), City Office of Innovation and Technology (OIT) and respective partner personnel to support comprehensive planning and tactical delivery of data management services in production operations.  In addition, responsibilities include Tier 2 and Tier 3 support for EHR production issues and Helpdesk tickets regarding data, database, 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.  Work with EHR PMO to integrate data management strategies for projects, programs, and initiatives.
  • Assist 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.
  • Responsible for overseeing patch management and maintenance on reporting infrastructure and data related systems. Develop version and release migration methodologies.
  • Design, implement and control access to data and databases with/for approved AHS partners and City entities.
  • Assure systems and data integrity.
  • Oversee functional configuration components to support monitoring and administering assigned systems and applications.
  • Serve as the technical intermediary between departments and vendors for various database solutions and datasets within on-premise and cloud hosted systems.
  • Assist to design, implement, and manage 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, database, and system administration establishing standards and procedures to maintain 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.
  • Support the backup and recovery strategy for database environments. Oversee and administer business continuity and disaster recovery tests and methods. 
  • Perform daily administration and performance monitoring of database related systems.
  • Monitor and proactively support capacity and performance planning and analysis.
  • Identify database sizing requirements based on AHS patient population, provider, user and legal retention requirements; monitor space usage and alert appropriate staff members to resolve sizing issues and conditions that may cause application failures.
  • 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 to both monitor and maintain the database and support applications.
  • Actively participate in the creative process to continuously improve architectural designs and implementation to ensure optimal efficiency and cost effectiveness.
  • 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.
  • Other data analysis and management duties as required.

Education

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

Skills/Experience

  • Demonstrated knowledge of the Systems Development Life Cycle
  • 5-7 years of experience working with SQL Server (2016 or later) and related products; special consideration given to Microsoft Business Intelligence Platform/Development Studio suite (SSRS, SSIS, and SSAS)
  • 5-7 years of experience working with Windows Server (2016 or later) and related products
  • Five (5) years working in health services related field
  • HIPAA/HITECH trained
  • In depth understanding of conceptual, logical, and physical database structures, architectures, and integration
  • Ability to translate, integrate, and export data from various cross-platform software and databases
  • Comfortable leading the design of both relational and OLAP databases
  • Database related expertise working with SQL Server (2012 or later), Oracle SQL developer, and related products; special consideration given to Microsoft Business Intelligence Development Studio suite (SSRS, SSIS, and SSAS)
  • Experience with working in physical and virtual server environments
  • Experience with log shipping, SQL back-up restore, and SFTP
  • 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 eClinicalWorks, i2i Tracks, Rhapsody and VMware
  • Experience with Microsoft SQL, Oracle database, Azure Synapse Analytics, and other multi-model database management or data warehouse systems
  • Experience with Microsoft PowerShell, SharePoint, and Visual Studio
  • Experience with data visualization software such as Tableau, Power BI, Red Cap, Quickbase, etc.
  • Web Analytics; batch processing development; HTML; XML; IIS server administration

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 50 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.