Data Warehouse Developer

You Belong Here.
At MultiCare, we strive to offer a true sense of belonging for all our employees. Across our health care network, you will find a dynamic range of meaningful careers, opportunities for growth, safe workplaces, and flexible schedules. We are connected by our mission - partnering and healing for a healthy future - and dedicated to the health and well-being of the communities we serve.
Required Skills & Experience:
Strong experience with Epic's Clarity SQL (Clarity-related certifications are a plus)
Expertise in T-SQL, with a focus on writing complex queries and performance optimization
Advanced Power BI development skills, including DAX, data modeling, and use of external tools such as DAX Studio and Tabular Editor
FTE:

1.0,

Shift:

Day,

Schedule:

Monday - Friday, 8am - 4pm
Position Summary
The Data Warehouse Developer II is responsible for working with Data Warehouse and Information Intelligence team building a holistic, technology-agnostic view of the organization's business processes and information assets; linking the business mission, strategy and processes of the organization to its Enterprise Data Warehouse (EDW) strategy. This position engages in implementing EDW solutions by developing ETL (Extract, Transform and Load) in sustainable and agile manner; develops data models that support business objectives. This person works closely with the Data Warehouse Manager and other Data Architects to ensure consistency and scalability in developed solutions. The position supports information delivery solution requiring knowledge of data models and data sources. Provides support in all areas of technical requirement for BI solutions, including design, development and configuration of the basic data model and ETL. Works closely with business, and Information Intelligence associates to support the best-practices for data integration, security, performance and sustainability. Participate and support project or program efforts working with team members and customers in highly collaborative environment. Off-hours and weekends may be required to resolve emergency issues, during implementation and maintenance activities, and during 24x7 on-call rotations.

Requirements
Bachelor's degree in Healthcare, Mathematics, Informatics, Computer Science, and Business or Information Technology required
Equivalent technical training/certification and additional work experience that demonstrates technical competency may be considered
Minimum three (3) years experience in data architecture, data warehousing, logical and physical data modeling, ETL, business information system architectures, system engineering, project management, and information application design and development
Experience with healthcare systems, databases, and interfaces in hospitals and clinic settings or with a healthcare system vendor preferred
Experience in project management techniques that implement and support technology, applications, programs and services
Our Values
As a MultiCare employee, we'll rely on you to reflect our core values of Respect, Integrity, Stewardship, Excellence, Collaboration and Kindness. Our values serve as our guiding principles and impact every aspect of our organization, including how we provide patient care and what we expect from each other.
Why MultiCare?
Belonging: We work to create a true sense of belonging for all our employees
Mission-driven: We are dedicated to our mission of partnering for healing and a healthy future and the patients and communities we serve
Market leadership: Washington state's largest community-based, locally governed health system
Employee-centric: Named Forbes "America's Best Employers by State" for several years running
Technology: "Most Wired" health care system 15 years in a row
Leading research: MultiCare Institute for Research & Innovation, 40 years of ground-breaking, clinical and health services research in our communities
Lifestyle: Live and work in the Pacific Northwest - offering breathtaking water, mountains and forest at every turn
Pay and Benefit Expectations
We provide a comprehensive benefits package, including competitive salary, medical, dental and retirement benefits and paid time off. As required by various pay transparency laws, we share a competitive range of compensation for candidates hired into each position. The pay scale is $98,654.00 - $136,261.00 USD. However, pay is influenced by factors specific to applicants, including but not limited to: skill set, level of experience, and certification(s) and/or education. If this position is associated with a union contract, pay will be reflective of the appropriate step on the pay scale to which the applicant's years of experience align.

Associated benefit information can be viewed here.