Data Engineer BILH Pharmacy Westwood, Ma, Hybrid / on-site

The Data Engineer will work on a team focused on the development and maintenance of the data pipelines for the innovative EHR+ applications, and manage and administer the tools and data pipelines for Epic EHR that include Clarity, Caboodle, Cogito and MindLAMP. This role will develop and maintain scalable data pipelines and builds out new ETL/API integrations to variable internal/external data sources, including EHR systems; to support continuing increase in data volume and complexity. 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., * 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 SU’s 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)

• Bachelor’s degree required.
• 1-3 years related 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., * 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., 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 constant sitting, Keyboard use.

The pay range listed for this position is the annual base salary range the organization reasonably and in good faith expects to pay for this position at this time. Actual compensation is determined based on several factors, that may include seniority, education, training, relevant experience, relevant certifications, geography of work location, job responsibilities, or other applicable factors permissible by law.

When you join the growing BILH team, you’re not just taking a job, you’re making a difference in people’s lives., 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) as a condition of employment.

More than 35,000 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.