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

When you join the growing BILH team, you're not just taking a job, you’re making a difference in people’s lives.

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.

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 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)

Required Qualifications:

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

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/perception, Visual monotony, Visual clarity <3 feet, Conversation, Telephone.

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 constant sitting, Keyboard use.

Pay Range:

$62,000.00 USD - $92,000.00 USD

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.

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.

Equal Opportunity Employer/Veterans/Disabled