This position will be part of a dynamic, energetic and collaborative team that supports the organization in the use of data and information to further OHSU’s mission to strive for excellence in education, research and scholarship, clinical practice and community service. Members of the Business Intelligence and Advanced Analytics (BIAA) team work to apply knowledge and best practices to assist in the development of integrated data warehouse and analytic systems to support analytic tools and efforts to analyze enterprise data for informed decision making throughout the organization. 

 

As a Sr. Data Warehouse Developer with expertise in Oracle, the primary responsibility will be to design, develop, and maintain data warehousing systems that effectively manage and process large volume of data. 

 

This person will work closely with database administrators, business intelligence architects, business intelligence analysts, business partners, and leadership to gather requirements, design data models, and develop ETL processes to ensure high-quality academic, administrative (HR, Payroll, Grants, Accounting, etc), clinical, and research data is available for reporting and analysis.  Experience with human resources data model and systems (eg – Oracle HR, Kronos, iCIMS, etc) is a plus.

 

Key responsibilities:

1. Designing and developing ETL processes using IBM DataStage, Oracle PL/SQL, or Teradata Decision Experts (TDE) Administrator that can efficiently extract data from multiple sources, transform it into a consistent format, and load it into a data warehouse.
2. Monitor and troubleshoot any issues that arise with the ETL processes. Ensure that ETL processes are running efficiently and accurately. They may use estimation and monitoring tools to detect and resolve any issues with the ETL process, while applying a strong understanding of the underlying data and systems to diagnose problems related to data integration, data quality and performance.
3. Optimize data performance by designing and implementing appropriate indexing, partitioning, and clustering strategies in Oracle databases.
4. Ensure that the ETL process is secure and that sensitive data is protected. This may involve implementing access controls and other security measures.
5. Ensure ETL is maintained through version control and change management.
6. Maintain documentation on the ETL process, including standards and procedures for the definition of reference architectures, synchronize on coordinated efforts/projects, and provide guidance around ETL consideration/issues. This documentation is critical for troubleshooting, maintenance, and compliance purposes.
7. Collaborate with business analysts & stakeholders to understand the business requirements and ensure that the data warehouse meets their needs.

• Minimum 2 years of paid work experience as an Application Engineer (or equivalent classification
• Minimum 3 years working with relational databases
• Strong understanding of data warehousing concepts, data modeling, and ETL processes
• Experience with the following tools: IBM DataStage, or Teradata Decision Experts (TDE) Administrator
• Experience with Oracle databases, SQL, PL/SQL, and Oracle RDBMS
• Experience managing major systems implementations.
• Knowledgeable of Azure Data Factory, DataBrick, Datalake and SSMS, SSAS, Power BI
• Experience compiling flowcharts and ER diagrams

• Applied knowledge of operating system software (eg – scripting in unix, command, powershell);
• Administer the installation & updates of ETL tools on local machine)
• Must have excellent communication, analytical, and organizational skills: both written and verbal.
• Ability to use tact and diplomacy to maintain effective working relationships.
• Excellent problem-solving skills and the ability to troubleshoot complex issues
• Strong communication skills and the ability to work collaboratively with cross-functional teams
• ­Must possess energy and drive to coordinate multiple projects simultaneously.
• Knowledge of development life cycle and production environment procedures.

Please note: Effective Oct. 18, 2021, all OHSU employees are required to be fully vaccinated against COVID-19 unless they have an approved medical or religious exception. If you are hired by OHSU after Oct. 18, you will need to be fully vaccinated (or obtain an approved exception) prior to starting work, and need to provide proof of vaccination (or approved exception) within 10 days of starting work.

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 aaeo@ohsu.edu.


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.