Working Each Day to Make a Difference

At Community Health Plan of Washington, we're driven by our belief that everyone deserves access to quality health care.

More than 25 years ago, we made a commitment to improve the health of our communities by making quality health care accessible to all Washington state residents.

We continue that pledge today by providing affordable comprehensive coverage to more than 315,000 individuals and families throughout the state.

• We are a local not-for-profit health plan in Washington State.
• We are committed to keeping Washington families healthy.
• We connect our communities to the health resources they need.
• We provide access to high-quality care for our members.
• We connect and empower our members through technology.
• The Community Health Centers we partner with strive to support members with a comprehensive mix of medical resources in one convenient location.
• Our partnerships with Community Health Centers and our extended provider network help us improve the health care delivery system.

To learn more about how you can make a difference working at Community Health Plan of Washington, visitwww.chpw.org{rel="nofollow"}.

* *

Sr. Data Warehouse Architect

*  *

[POSITION PURPOSE:]{.underline}

As a member of the Data Engineering team, responsible for architecting and solutioning high quality data pipelines for CHPW's Enterprise Data Hub Platform and other data repositories.

[PRINCIPAL DUTIES:]{.underline}

• Applies approved Data warehouse architecture and design practices to translate business requirements into functional requirements and mapping design documents to build data pipelines moving data and metadata into Enterprise Data Warehouse and other Integrated managed data repositories.
• Perform Snowflake data modeling, with hands on experience in implementing data frameworks including ingestion, transformation, data quality checks, master data management, monitoring, alerts, notifications etc.
• Collaborate with vendors, data providers and business stake holders on new data acquisitions to ingest data by defining formats, filling data gaps, adjusting source-system data structures to facilitate integration with other organizational data.
• Oversee Data analysts and Product managers responsible to write and maintain documentation of the ETL processes via process flow diagrams, data profiling and source to target mappings adhering to best practices.
• Educates end users of the warehouse by providing data warehouse design/schema information via educational sessions, in-person discussions, or instructional documents.
• Promotes the use of the warehouse by working with data stewards, data analysts, business solution analysts, and governance analysts to help end users understands data definitions, lineage, storage locations and access.
• Participates in data governance activities and ensure data security working closely with Database Administrators, Information security and Infrastructure teams.
• Leads and/or participates in design and code reviews.
• Provides application and operational support, fulfills assigned On-call duties.
• Provides mentorship, coaching and technical leadership to less experienced team members.
• Other duties as assigned.

[QUALIFICATIONS:]{.underline}

[Education]{.underline} & [Prior Related Experience]{.underline}:

 Bachelor's degree in computer science, Management Information Systems or an equivalent combination of education and highly relevant experiences required.

Have a minimum of five (5) years of experi