CAILHS Data Engineer; Applications Engineer, Sr

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 establish data as a strategic asset.

• Work with BI architects, developers, data scientists, and informaticians to design, create, and publish data sets, data flow processes, and metadata.
• Data mapping, transformation, cleaning and otherwise optimizing for storage and use according to business and technical requirements.
• Leverage and extend the OHSU Epic Caboodle Data Warehouse capabilities by designing, developing, testing, and implementing ETL.
• Develop and maintain innovative cloud data feed and/or solutions, task automations, and data pipelines.
• Collaborate with BI Architects, Developers, Analysts, and customers to design, create and publish data models, ETL processes, 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.
• Documentation of created assets in the appropriate BI asset library.
• Develop Epic Clarity and Caboodle data feeds using SSIS, 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.
• Apply appropriate security structures and policies to data and database objects.
• Make recommendations on best practices for code maintenance, deployments, and migrations working in conjunction with SQL Server DBAs and enterprise data architects.

• Gather and document technical requirements necessary for planning and managing enterprise projects with technical deliverables.
• Participate in discovery sessions with customers, data scientists, informaticians, and vendors to gather and document detailed requirements that inform the design and development of new or modifications to existing BI solutions.
• Data Analysis, data profiling, and solution design.
• Develop data sources and metadata models to be used for ad hoc analysis or reporting.
• 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.

• Bachelor’s degree in computer science, a related field, or a clinical field and eight years 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 nine years work related experience in the information technology field or a combination of clinical or operational healthcare environments;
  OR
• Ten 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.

• Two or more years of paid work experience as an Application Engineer.
• Two or more years of paid work experience developing data warehouse objects and/or data integration ETL solutions.
• Minimum three years of experience with Microsoft SQL Server SSIS ETL development.
• Minimum…