Data Engineer, Department of Surgery

When you join the growing BILH team youre not just taking a job youre making a difference in peoples lives.

The Data Engineer will work on a team focused on the development and maintenance of streamlined workflows with the Department of Surgerys project management team. This will exclude but not limited to Power BI EPIC data mining EHR applications SharePoint Salesforce etc. This role will develop and maintain scalable data projects and builds out new workflows supporting DFCI expansion as it relates to the department.

Role collaborates with analytics and business teams to improve data models that feed innovative EHR applications increasing data accessibility and fostering data-driven decision making across the organization. Implements processes and systems to monitor data quality ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.

Job Description:

The following statements are not intended to be an exhaustive list of all duties responsibilities and skills required of this position.

Primary Responsibilities:

• Develops and maintains scalable data pipelines and builds out new ETL/API integrations to variable internal/external data sources including EHR systems; supports continuing increase in data volume and complexity (essential)
• Manages and administers the EHR tools and data pipelines for Epic EHR that include Clarity Caboodle Cogito and mindLAMP; monitors the Epic Cogito systems environment which includes monitoring day-to-day ETL jobs troubleshooting any issues that arise and monitoring database growth; works with DBAs and Epic TS Representatives to maintain overall database health and availability if required. (essential)
• Performs modifications full upgrades patches and SUs on all Epic Clarity and Caboodle environments if required. (essential)
• Participates with analytics and business teams to develop data models that feed innovative EHR applications increasing data accessibility and foster data-driven decision making across the organization. (essential)
• Implements processes and systems to monitor data quality ensuring production data is always accurate and available for key stakeholders and business processes that depend on it. (essential)
• Contributes to unit/integration tests engineering wiki and documents work (essential)
• Participates in data analysis required to troubleshoot data related issues and assist in the resolution of data issues (essential)
• Provides on call / after-hours support as required (essential)
• Performs all other duties as needed or directed to meet the needs of the department and or customer (essential)
• Achieves and maintains required certifications (if applicable) (essential)

Required Qualifications:

- Bachelors degreerequired.

- 1-3 yearsrelated work experience required in Python or Java Development SQL Schema Design and Dimensional Data Modeling; Epic experience with Clarity Caboodle or MindLAMP if applicable.

- Experience with ETL processes and methodologies.

- Experience designing building and maintaining data processing systems.

- Working knowledge of Unix/Linux systems.

- Ability to access manage transfer integrate and analyze complex datasets especially using SQL. - Advanced technical computer skills as required for technical support specific to functional area and related systems.

Preferred Qualifications:

- Knowledge and experience using basic or intermediate project management tools and techniques.

- Experience with working on large data sets especially with Spark.

- Experience with Python and Java.

- Experience with cloud computing platforms such as AWS or GCP.

- Experience with Kubernetes.

- Candidate will have a proven track record of producing quality deliverables on time taking ownership and accountability of assignments and demonstrating a strong work ethic

Competencies:

Decision Making:Ability to make decisions that are guided by precedents policies and objectives. Regularly makes decisions and recommendations on issues affecting a department or functional area.

Problem Solving:Ability to address problems that are varied requiring analysis or interpretation of the situation using direct observation knowledge and skills based on general precedents.

Independence of Action:Ability to set goals and determines how to accomplish defined results with some guidelines. Manager/Director provides broad guidance and overall direction.

Written Communications:Ability to summarize and communicate in English moderately complex information in varied written formats to internal and external customers.

Oral Communications:Ability to comprehend and communicate complex verbal information in English to medical center staff patients families and external customers.

Knowledge:Ability to demonstrate in-depth knowledge of concepts practices and policies with the ability to use them in complex varied situations.

Team Work:Ability to work collaboratively in small teams to improve the operations of immediate work group by offering ideas identifying issues and respecting team members.

Customer Service:Ability to provide a high level of customer service and staff training to meet customer service standards and expectations for the assigned unit(s). Resolves service issues in the assigned unit(s) in a timely and respectful manner.

Social/Environmental Requirements:

Work requires close attention to task for work to be accurately completed. Intermittent breaks during the work day do not compromise the work.

Work requires constant response to changing circumstances and using new information to adjust approach and to quickly respond to new needs.

No substantial exposure to adverse environmental conditions

Health Care Status:NHCW: No patient contact. -Health Care Worker Status may vary by department

Sensory Requirements:

Close work (paperwork visual examination)Color vision/perceptionVisual monotonyVisual clarity <3 feetConversationTelephone.

Physical Requirements:

Sedentary work: Exerting up to 10 pounds of force occasionally in carrying lifting pushing pulling objects. Sitting most of the time with walking and standing required only occasionally. This job requires constantsittingKeyboard use.

As a health care organization we have a responsibility to do everything in our power to care for and protect our patients our colleagues and our communities. Beth Israel Lahey Health requires that all staff be vaccinated against influenza (flu) and COVID-19 as a condition of employment. Learn more about this requirement.

More than 35000 people working together. Nurses doctors technicians therapists researchers teachers and more making a difference in patients lives. Your skill and compassion can make us even stronger.

Equal Opportunity Employer/Veterans/Disabled