Providence Health & Services ETL Developer II, Healthcare Intelligence in Portland, Oregon


ETL Developer II, Healthcare Intelligence

Employer Name: Providence Health & Services - Washington

Employer Address: 1801 Lind Avenue SW Renton, WA 98057

Contact: Gerald Leighton

Place of Employment: 4400 NE HasleyStreet, Portland, OR 97213

Hours: 40 hours per week

Providence Health & Services - Washington desires to hire a full-time ETL Developer II, Healthcare Intelligence ("ETL Developer II") in Portland, Oregon. The ETL Developer II designs, develops, documents, maintains, and operates the extract, transform and load (ETL) processes that populate the Enterprise Data Warehouse and related databases from various transaction systems and other data sources. The ETL Developer II works with other Healthcare

Intelligence team members and Information Systems staff in cross-functional teams to deploy analytical solutions in support of Providence Health & Services.

The ETL Developer II may lead projects of high technical complexity and will also set direction for ETL standards, will optimize and administer the ETL platforms, plan for growth and scalability, oversee deployments and upgrades, and will mentor junior ETL developers. The position reports to the Senior Manager of Healthcare Intelligence Systems.

Specifically, the ETL Developer II's duties shall include:

  • Develop and maintain ETL processes that meet the business and technical requirements of the specific project and of the overall Enterprise Data Warehouse data integration portfolio.

  • Document all processes and support source code control using standard tools and processes.

  • Explore and profile source system data to inform the technical and business requirements.

  • Identify relevant data sets from transaction systems through hands-on analysis, documentation review, and consultation with application teams.

  • Design database structures using standard design methods and modeling tools.

  • Ensure that all assets and processes adhere to all quality assurance, security, reliability and usability standards set by the Healthcare Intelligence program.

  • Resolve production problems through root cause analysis, data investigation, debugging and testing.

  • Assure consistency and maintainability of new assets and processes by facilitating design reviews by specialists and other architects.

  • Other duties as assigned.


Minimum requirements:

  • Master's Degree or foreign equivalent in Computer Science, Information Technology,Management Information Systems, Mathematics, or related field, as well as three years ofexperience in ETL, software development, or data management.


  • Bachelor's degree or foreign equivalent in Computer Science, Information Technology,Management Information Systems, Mathematics, or related field, as well as five years ofexperience in ETL, software development, or data management.

Additionally, the position requires Experience with the following:

  • ETL development processes and best practices using standard ETL tools like Informatica PowerCenter, Microsoft SSIS.

  • Advanced SQL skills including stored procedures, triggers and advanced functions.

  • Relational database design principles; performance tuning, indexing and compression, transaction management and partitioning.

  • Programming skills in VB, C#, .NET, UNIX shell, or Java.

  • Data transport methodologies and standards: secure file transfer, HL7, XML, web services.

  • Data warehousing and business intelligence principles; familiarity with quantitative methods.

  • Project management principles; Agile development methodology and other SDLC principles; testing, peer review and ongoing quality assurance processes.

  • Source code control; Microsoft Team Foundation Server; project deployment across multiple environments.

  • Participation in on-call rotation to support 24x7 operations.

  • Healthcare, clinical, and administrative processes and data.

To apply please visit

We offer a full comprehensive range of benefits - see our website for details

Our Mission

As expressions of God’s healing love, witnessed through the ministry of Jesus, we are steadfast in serving all, especially those who are poor and vulnerable.

About Us

Providence Health & Services is a not-for-profit Catholic network of hospitals, care centers, health plans, physicians, clinics, home health care and services guided by a Mission of caring the Sisters of Providence began over 160 years ago. Providence is proud to be an Equal Opportunity Employer. Providence does not discriminate on the basis of race, color, gender, disability, veteran, military status, religion, age, creed, national origin, sexual identity or expression, sexual orientation, marital status, genetic information, or any other basis prohibited by local, state, or federal law.

Schedule: Full-time

Shift: Day

Job Category: Information Technology

Location: Oregon-Portland

Req ID: 202848