IS Data Warehouse Architect III

CareOregon

Data Warehouse Architect creating advanced ETL specifications and data models for CareOregon. Collaborating with leaders to recommend data architecture goals while ensuring compliance with standards.

Posted 7/23/2026full-timeRemote • Oregon • 🇺🇸 United StatesMid-LevelSenior💰 $126,720 - $154,880 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive experience in data warehouse architecture, including design and development of data models, ETL specifications, and performance tuning. Proficient in SQL and cloud warehousing solutions, with a strong focus on data quality assessment and metadata management.

Highest-signal resume keywords

Data Warehouse ArchitectureDimensional ModelingETL/ELT DesignPerformance TuningCloud Warehousing Solutions

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data Warehouse ArchitectureDimensional ModelingETL/ELT DesignPerformance TuningData Quality AssessmentMetadata ManagementSQLData ModelingData AnalysisData Architecture

Soft Skills

LeadershipCollaborationCommunication

Tools & Technologies

Cloud Warehousing Solutions

Industry Keywords

Health CareManaged Care

Tech Stack

Tools & technologies

CloudETLSQL

About the role

Key responsibilities & impact

Perform data warehouse architecture or enterprise data architecture at a senior level
Focus on design and development of data models and ETL specifications
Analyze data sources and partner with leaders across the organization
Recommend long-term data architecture goals and planning
Lead and provide direction in creating and managing advanced to complex data warehouse and analytics architectures
Author and serve as subject matter expert to define requirements, standards and best practices

Requirements

What you’ll need

Minimum 5 years of data warehouse architecture experience
Dimensional modeling experience
Metadata management
Data quality assessment
Performance tuning and optimization
ETL/ELT design
Cloud warehousing solutions
Proficiency with SQL
Experience in health care or managed care

Benefits

Comp & perks

Health insurance
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
Paid holidays, volunteer time, jury duty, bereavement leave