IS Data Warehouse Architect II

🔥 27 minutes ago

🌲 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 Insurance

🤝 Non-profit

Healthcare Insurance • Non-profit

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 • Focus on design and development of data models and ETL specifications • Conduct data analysis, system design and architecture, standards and policy administration • Coordinate vendor relations and conduct product/vendor research • Create moderate to advanced data models and ETL specifications • Maintain documentation on design and operation • Analyze data sources and recommend solutions • Participate in long-term data warehouse and dashboard architecture planning • Manage existing systems compliance with established standards

🎯 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

• Health insurance • Dental insurance • Vision insurance • Life insurance • AD&D insurance • 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, etc.) • Strong retirement plan with employer contributions • PTO and Paid State Sick Time based on hours worked/scheduled hours and the primary work state • Paid holidays • Volunteer time • Jury duty • Bereavement leave