Overview

Remote Position (OR/WA Only)

This is a remote position – incumbents, who reside in Oregon or Washington only. There may be occasional situations that require work to be performed on-site at an assigned Legacy Health location. All new hires are required to come to a designated Legacy Health office location in Portland, Oregon prior to their start date for a new hire health assessment and to complete new hire paperwork. This position may require initial training and orientation to be site-based, before transitioning to the remote schedule. 

Responsibilities

Every aspect of what we do at Legacy reinforces our commitment to improve the lives of our staff, our patients and our visitors. Information Services is no exception. IS drives so much of what we do, and we look for experts in the field to lead the way. Do you have your finger on the pulse of information systems for business and health care? Can you analyze, build, test, support and maintain systems that will benefit our hospital system and those we serve? If so, we’d like to hear from you.

The Data Engineer II is a mid-level engineering position that works collaboratively with Application Systems Analysts, Business Intelligence (BI) Consultants, and business partners to develop detailed specifications (requirements), and design, build and maintain the infrastructure necessary for data collection, storage, processing and analysis. Under general direction, the Data Engineer II facilitates use of data to solve organizational problems through data design, access, usage, security, and quality of information assets. The Data Engineer II will provide enterprise-wide support for all users requiring decision support and in particular Application Systems Analysts, Clinical Informatics staff, Power Users and other data consumers.

Qualifications

Education

Bachelor's degree in sciences (engineering, physics, computer science, math), information systems, statistics or business required. Relevant experience may be substituted for educational requirements.

Experience:

3 years’ experience developing and implementing enterprise-scale data infrastructure

• • Working with operational stakeholders in a requirements analysis role
  • Knowledge of logical and physical data modeling concepts (relational and dimensional) and structured methodologies
  • Data flow diagrams and flowcharting
  • Understanding of data integration concepts (e.g., validation and cleansing) and familiarity with complex data and structures

Two (2) to three (3) years’ experience in data mining and analytics or relational database management in systems such as SQL server.

• • Experience with data warehouse implementations and build out
  • Demonstrated knowledge of data structures and relationships used in reporting
  • Data Pipeline development
  • ETL/ELT concepts and tools

Skills:

Thorough understanding of current developments and trends in data integration and systems.

Demonstrated ability to do systematic, thorough problem solving and to initiate client problem resolution.

Ability to establish, conceive and describe systems, designs, flow charts, time schedules and network requirements.

Knowledge of enterprise's data and decision-making processes.

Excellent interpersonal skills (including verbal and written communication) to support working in project environments that include internal, external, and customer teams.

Requires strong analytical, conceptual and problem-solving abilities and critical thinking.

Flexibility, managing multiple priorities, assessing and adjusting quickly to changing priorities.

Demonstrated attention to detail

Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences.

Self-motivated; able to work within a high-volume project-based environment.

Leadership qualities including ability to mentor junior members of the team.

Strong TSQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques.

Demonstrated knowledge of data extraction and manipulation, ETL techniques required.

Preferred, but not required:

Comfort using both agile and waterfall development methods preferred

Familiarity with Epic applications and data model/database structure

SSAS development (OLAP and tabular models)

SSIS development for data warehouse ETL processes

Experience with cube development

LEGACY’S VALUES IN ACTIONFollow guidelines set forth in Legacy’s Values in Action.

Equal Opportunity Employer/Vets/Disabled