Data Warehouse Developer II

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 fo