IS Data Warehouse Architect II

🕒 July 24

🌲 Oregon – Remote

🌲 Oregon – Remote

💵 $113.9k - $139.3k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CareOregon

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 1994

🏥 Healthcare

📦 Logistics

🛡️ Insurance

Healthcare • Logistics • Insurance

CareOregon is a community-focused health plan that provides coordinated physical, behavioral, dental and social-support services to Oregon Health Plan members, serving more than 500,000 people. The organization operates provider and member portals, offers care coordination, telehealth, language and tribal services, community grants and outreach, and programs addressing social determinants of health such as housing, nutrition and transportation.

📋 Description

• Perform Data Warehouse Architecture at an intermediate level • Design and develop data models and ETL specifications • Conduct data analysis and research to recommend solutions • Participate in long-term data warehouse and dashboard architecture planning • Create and manage moderate to advanced data warehouse and analytics architectures • Propose requirements, standards and best practices for data modeling and ETL specifications • Conduct product and vendor research and present recommendations • Establish and maintain effective working relationships with vendors

🎯 Requirements

• Minimum 3 years’ of data warehouse architecture experience • Dimensional modeling experience • Data quality assessment • Proficiency with SQL • Agile/Scrum methodology • Source Target mapping • Data Analysis • Preferred experience in health care or managed care • Metadata management • Performance tuning and optimization • ETL/ELT design • Cloud warehousing solutions • Health insurance Systems analysis and design

🏖️ Benefits

• Medical, dental, vision, life, AD&D, and disability insurance • Health savings account • Flexible spending account(s) • Lifestyle spending account • Employee assistance program • Wellness program • Discounts • Multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings) • Strong retirement plan with employer contributions • PTO and Paid State Sick Time based on hours worked/scheduled hours • Paid holidays, volunteer time, jury duty, bereavement leave, depending on eligibility