Oregon Health & Science University | Business Intelligence Engineer (Application Engineer) | Portland, OR | United States | BigDataKB.com | 13 Oct 2022

• SAP Business Objects Web Intelligence for department reporting
• Dashboard and data visualization development in Azure BI Analytics and/or Tableau;
• ETL development using Epic’s Caboodle Data Warehouse and SQL Server Integration Services (SSIS);
• SQL data extracts using T-SQL stored procedures and SSIS;
• Views and stored procedures for reporting using Microsoft SQL Server and the Epic Clarity and Caboodle data models;

Function/Duties of Position:

• Contribute to the growth of the OHSU Caboodle Data Warehouse architecture by designing, developing, testing and implementing ETL.
• Work 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.
• Document 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.
• 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.
• Coordinate data integration projects with system architects, DBAs, and vendors.
• Deploy data warehouse content using approved Azure DevOps systems and processes

• Conduct discovery sessions with customers 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 BusinessObjects BI solutions including scheduled reports, publications and ad hoc assets.
• Dashboard and data visualization development in Azure BI Analytics and/or Tableau
• Create and maintain metadata models (e.g., BusinessObjects Universes).
• Develop key metrics as prioritized by service line leadership
• Develop roll up dashboards to provide insight into operational metric performance.
• Provide datasets and advanced analysis.
• Provide technical expertise to support end users developing ad-hoc queries and departmental reports.
• Work with customers to improve user interfaces for improved reporting.
• Works closely with other BIAA staff to meet expectations for design reviews and coding standards.

• Understand and utilize approved System Development Life Cycle (SDLC) systems, processes, and procedures.
• Respond to and track issues using Jira Service Desk
• 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.
• 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.
• Maintain assets through system upgrades.

Required Qualifications:

• Two or more years of paid work experience as a Systems/Application Analyst or Application Administrator.

• Successful candidates must have experience and working knowledge in operating system software, relational and/or hierarchical databases, and technical application support for administrative and clinical systems

Preferred Qualifications:

• Minimum of two (2) years of experience as an Application Engineer or Developer (or equivalent classification) developing data warehouse objects and/or data integration 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 five (5) years developing reports and dashboards.
• Minimum of two (2) years of experience in a data warehouse environment

• Knowledge of data warehousing architecture and dimensional modeling concepts.
• Ability to read, write and maintain SQL code at an advanced skill level.
• Proven communication, analytical, and problem-solving skills.
• Ability to manage multiple projects 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.

• Epic Clarity Data Model Certifications and Epic Caboodle Developer Certification within 6 months of hire.

Additional Details:

All are welcome: Oregon Health & Science University values a diverse and culturally competent workforce. We are proud of our commitment to being an equal opportunity, affirmative action organization that does not discriminate against applicants on the basis of any protected class status, including disability status and protected veteran status. Individuals with diverse backgrounds and those who promote diversity and a culture of inclusion are encouraged to apply. To request reasonable accommodation contact the Affirmative Action and Equal Opportunity Department at 503-494-5148 or [email protected].

As an organization devoted to the health and well-being of people in Oregon and beyond, OHSU requires its employees to be fully vaccinated against COVID-19.