Share this Job

Senior Data Warehouse Developer - EDW Team

Benefits Eligibility (Employment Type):  Full-time benefits (32-40 hours per week)
Shift Type:  Day
Shift Length:  8 Hours
Primary Location (City):  Vancouver
State:  WA

PeaceHealth is seeking a Senior Data Warehouse Developer - EDW Team for a 1.0 full time equivalent Exempt position. This position will be working Day shift with shift durations of 8 Hours.

Req ID: 178538

 

JOB SUMMARY

Responsible for designing, implementing and maintaining data collection, integration and storage tools.  Responsible for coordinating small to medium projects and providing leadership for team members. Develops portions of applications not provided by software vendors, customization of vendor –supplied systems and integrate a mix of vendor-supplied or internally developed applications and databases. Able to work within and across HID teams. Responsible for promoting system and process development in a manner that facilitates and supports standards and policies pertaining to data management.

 

 

ESSENTIAL FUNCTIONS

1. With minimal direction, analyze, monitor, and troubleshoot data warehouse loads - integration systems, tune and optimize data warehouse loading to enhance performance. Create and implement data warehouse load processes.

2. Design and construct the data warehouse technical infrastructure.  Plan and conduct structured testing of database designs to confirm functionality and performance.  Develop and maintain logical and physical data models of the data warehouse and data marts.  Assist in developing and implementing the metadata strategy.  Assist in developing standards.  Design and maintain database security

3. Write SQL statements to extract and integrate data.  Create customizations as allowed by application, i.e. triggers, stored procedures

4. Design, build, install and upgrade test and production relational and object-oriented databases and accompanying front-end applications.  Plan and conduct structured testing of data warehouse designs to confirm functionality and performance.  Develop and implement complex data models and logical database designs. Demonstrates an awareness of the larger environment and how the work done by the team impacts other teams in HID.

5. Participate as needed in implementations and recommend improvements to the overall approach to the warehouse life cycle.  Perform routine and customary operational and monitoring activities to ensure the data warehouse environment is stable and capable of meeting ongoing business needs and provides leadership for team members on standard processes and procedures that promotes consistent team work

6. Participates as needed in implementations and recommends improvements to the overall approach to the warehouse life cycle and tool administration.  Performs routine and customary operational and monitoring activities to ensure the data warehouse environment is stable and capable of meeting ongoing business needs and provides leadership for team members on standard processes and procedures that promotes consistent team work.

7. Participate as an expert advisor in training sessions for customers.

8. Perform special projects as requested and adapt to sudden project needs and requests.

9. Performs other duties as assigned.

 

QUALIFICATIONS

EDUCATION:     

  • Bachelor’s degree in Computer Science or related, relevant field.  Equivalent experience may substitute for degree.

 

EXPERIENCE/TRAINING:              

  • Five or more years experience in database development, implementation and healthcare information systems development or implementation. 
  • Experience with industry common programming languages, tools, and concepts such as SQL, XML, Active Server Pages, HTML and ETL.
  • Five or more years experience with data warehousing, applying principles, techniques and/or with relational and object oriented database and data structures.
  • Five or more years experience in design and implementation of data structures, in retrieval, access methods, database software and development of standards.
  • Five or more years with data modeling, logical and relational database design is strongly preferred.
  • Epic/Clarity experience preferred.
  • Epic's Caboodle Data Warehouse (CDW), SSIS and Informatica experience strongly preferred.
  • Dimensional modeling experience preferred.

 

OTHER SKILLS:  

  • Excellent verbal and written communication skills
  • Strong organizational and analytical skills
  • Ability to manage multiple priorities, projects and display flexibility in a fast paced and changing work environment.

 

SYSTEM PHYSICAL/COGNITIVE REQUIREMENTS:

  • Work requires fairly light physical exertion from up to 65% of the time.
  • Ability to lift objects weighing 30 lbs. or less.
  • Work is performed under normal working conditions with adequate lighting and ventilation.
  • Job duties frequently require intense concentration and attention to detail (up to 65% of work time).

 

 

Please apply online to be considered. For full consideration of your skills and abilities, please attach a current resume with your application.

 

About PeaceHealth

 

PeaceHealth, based in Vancouver, Wash., is a not-for-profit Catholic health system offering care to communities in Washington, Oregon, and Alaska. PeaceHealth has approximately 16,000 caregivers, a multi-specialty medical group practice with more than 900 providers and 10 medical centers serving both urban and rural communities throughout the Northwest. In 1890, the Sisters of St. Joseph of Peace founded what has become PeaceHealth. Today, PeaceHealth is the legacy of its founding Sisters and continues with a spirit of respect, stewardship, collaboration and social justice in fulfilling its Mission. 

 

We offer competitive compensation, a robust benefits package and a collaborative, Mission-driven work environment! To learn more about working at PeaceHealth and the Vancouver community please visit our homepage: www.peacehealth.org/careers.

 

Get a feeling for the Spirit of PeaceHealth through this three-minute video, and visit us on Facebook or LinkedIn!

 

Questions? Review our Employment FAQ or email Recruitment@peacehealth.org. Please note this email does not accept resumes or applications.

 

Location: Vancouver, Shared Services Center (802)
Job Category:  Business, Administrative & Facilities 
Shift:  Day
Shift Length: 8 Hours
FTE: 1.0
Work Type:  Full Time
Required Certifications/Licensure: 

 

PeaceHealth is committed to providing equal employment opportunities to all qualified job applicants and employees without regard to the following statuses: protected veteran; qualified individual with a disability; race; ethnicity; religion; gender; pregnancy; gender identity; national origin; age; genetic information; sexual orientation; or any other protected status in accordance with local, state, or federal laws.

 

The above information is intended to indicate the general nature and level of work performed by this position. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of caregivers assigned to this job.

 

Posting Notes: Vancouver || Business, Administrative & Facilities || IT & Health Information Management || Full Time || IS ADMINISTRATION


Nearest Major Market: Portland Oregon
Nearest Secondary Market: Tacoma

Job Segment: Database, Data Warehouse, Medical, Developer, Information Systems, Technology, Healthcare