Clinical data engineer (application engineer)

Apply now

Location

remote, United States

Commitment

Full Time

Level

Junior (<2 years)

Required skills

Data engineeringSQL ServerT-SQLSSISEpic CaboodleEpic ClarityMicrosoft FabricPythonPySparkData warehousingDimensional modelingETLData qualityAzure DevOpsHealthcare systems

Job Description

Department Overview

The mission of the Information Technology Group (ITG) is to provide and support technology and information services that enable OHSU to be a national leader in health and science innovation. The work of the Business Intelligence & Advanced Analytics Division (BIAA) is to deliver meaningful analytic solutions by bringing together data, systems, and people to enhance the work and lives of OHSU members and the communities we serve.

The Clinical data engineer role is part of the clinical data team, part of a larger clinical business intelligence unit (CLBI) comprising analysts, engineers, administrators, and architects. This position is responsible for creating new clinical data warehousing solutions, data transformations, and data integration assets, as well as supporting changes, enhancements, and maintenance of existing assets in support of OHSU clinical data initiatives.

Function/Duties of Position

You will work closely with cross-functional teams, including healthcare professionals, data architects, and IT specialists, to develop robust data pipelines, implement data quality controls, and generate insights to support clinical decision-making. The ideal candidate has a strong background in both data engineering and analytics, with a deep understanding of healthcare systems and clinical data standards.

This position will be developing primarily in the Epic Caboodle Console, Microsoft SQL Server tools, and Microsoft Fabric Data Engineering tools. Duties may also extend to other cloud data engineering tools such as Apache Airflow, as needed. Azure DevOps will be used for version control, code management, and code deployment.

Data Management

  • Design and develop data pipelines to extract, transform, and load (ETL) clinical data from various sources into formal structures suitable for analysis.
  • Implement data quality controls to validate, monitor, and maintain the accuracy, completeness, and consistency of clinical data throughout the pipeline lifecycle.
  • Contribute to the growth of the OHSU Caboodle Data Warehouse architecture by designing, developing, testing, and implementing custom clinical data models.
  • Work with BI architects, developers, analysts, and customers (practice managers, data scientists, quality analysts, etc.) to design, create and publish data models, ETL processes, Lakehouses, Warehouses, Notebooks, and metadata using the Epic Caboodle Console, as well as third-party ETL tools.
  • Provide complete and consistent documentation of data warehouse content in the Caboodle Console to ensure that users can determine what data is available in the warehouse, how this data is defined, and lineage to Epic Clarity.
  • Document assets in the Analytics Marketplace.
  • Develop Epic Clarity and Caboodle data feeds using SSIS or similar tools, ensuring data feeds have undergone appropriate security review, and are transported abiding by the guidelines of the information privacy and security office, as well as any further security requirements outlined in a business associates' agreement or data use agreement.
  • Coordinate data integration projects with system architects, DBAs, and vendors.
  • Deploy data warehouse content using approved Azure DevOps systems and processes.

Systems Analysis & Operational Support

  • Conduct comprehensive analysis of clinical data, employing statistical techniques and data mining methodologies.
  • Troubleshoot and analyze ETL process failures, data anomalies and other ETL or data warehouse issues identified by automated monitoring, other developers, and end users.
  • Work through established processes to resolve any system or data problems and communicate updates and status to affected groups.
  • Recommend improvements to ETL processes, tool sets, data models, and monitoring techniques to improve existing structures and code to increase reliability and efficiency.
  • Create and maintain metadata models that accurately describe custom warehouse data structures.
  • Provide technical expertise to support end users by providing business logic and information about data pipeline transformations.
  • Respond to and track issues using Jira Service Desk.
  • Gather additional information from the customers and triage the issue and resolve or escalate by involving additional team members as required.

Project & Systems Management

  • Understand and utilize approved System Development Life Cycle (SDLC) systems, processes, and procedures.
  • Manage projects by creating timelines, identifying risks and milestones, and provide status reporting to others as defined.
  • Provide support to data warehouse developers, line-of-business analysts, and users to validate data in the data warehouse.
  • Investigate reported incidents and work to ensure the validity of the data warehouse.
  • Use approved development tools (BusinessObjects, SQL Server Management Studio, etc.) to identify data quality and data relationships to assist with the design of efficient and effective reporting solutions.
  • Schedule and oversee the schedules and publications of report distributions to ensure that data are delivered only to the intended recipients at the intended time.
  • Other duties as assigned.

Required Qualifications

  • Bachelor’s degree in computer science, a related field, or a clinical field and six years of work-related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
  • Associate’s degree in computer science, a related field, or a clinical field and seven years of work-related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
  • Eight years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
  • Equivalent combination of education and experience where one year of experience will be substituted for an Associate’s degree and two years of experience will be substituted for a Bachelor’s degree.

Experience

  • Minimum of two (2) years of experience as an Application Engineer or Developer (or equivalent classification) developing data warehouse objects and data integration ETL solutions.
  • Minimum of three (3) years SQL Server Experience, including SSIS and T-SQL, coding, performance tuning, and system optimization.
  • Minimum of five (5) years with Microsoft SQL Server T-SQL.
  • Minimum of two (2) years of experience in a medallion architecture data warehouse environment.
  • One year of experience with Microsoft Fabric using OneLake and Data Engineering tools.
  • One year of experience with Python or PySpark.

Skills and Abilities

  • Knowledge of data warehousing architecture and dimensional modeling concepts.
  • Knowledge of data validation and testing methodologies for ETL processes.
  • Familiarity with data governance and cataloging practices.
  • Proven communication, analytical, and problem-solving skills.
  • Ability to manage competing priorities and communicate progress on an ongoing basis with excellent attention to detail.
  • Ability to accurately document system technical artifacts at a level of detail sufficient for ongoing production support.

Certifications

  • Epic Clarity Data Model Certifications and Epic Caboodle Developer Certification within 6 months of hire.
  • Microsoft DP-700 Fabric Data Engineer certification within 9 months of hire.

Preferred Qualifications

  • Experience with the Epic Clarity and Caboodle data models.
  • Experience planning and managing small projects.
  • Experience with HIPAA and PHI compliance.
  • Microsoft DP-700 Fabric Data Engineer Certification.

Additional Details

Benefits

  • Healthcare for full-time employees covered 100% and 88% for dependents.
  • $50K of term life insurance provided at no cost to the employee.
  • Two separate above market pension plans to choose from.
  • Vacation - up to 200 hours per year dependent on length of service.
  • Sick Leave - up to 96 hours per year.
  • 9 paid holidays per year.
  • Substantial Tri-Met and C-Tran discounts.
  • Employee Assistance Program.
  • Childcare service discounts.
  • Tuition reimbursement.
  • Employee discounts to local and national businesses.

Why apply to OHSU?

We are Oregon's only public academic health center. In addition to caring for patients, we lead groundbreaking research. We also train the next generation of health care professionals. As Portland's largest employer, we give you opportunities to learn and advance in a system of hospitals and clinics across Oregon and Southwest Washington. All are welcome. OHSU welcomes people of all ages, ethnicities, genders, national origins, religions and sexual orientations. We are striving to build an anti-racist, multicultural institution and encourage people with diverse backgrounds to apply. To request reasonable accommodation, contact askhr@ohsu.edu

Ready to join the team?

Apply now