IS Data Warehouse Architect, II

CareOregon

. Perform intermediate-level data warehouse architecture .

Posted 9/25/2026full-timeRemote • Oregon • United StatesJuniorMid-Level💰 $113,940 - $139,260 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in data warehouse architecture, data modeling, and ETL specifications, with a strong focus on SQL proficiency and cloud data warehousing tools. Capable of effective communication and collaboration across departments to support data-driven decision-making.

Highest-signal resume keywords

Data Warehouse ArchitectureDimensional ModelingSQL ProficiencyETL Tools (SSIS, Azure Data Factory)Cloud Data Warehousing (Snowflake, Redshift)

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 DesignData ArchitectureData Quality AssessmentSource-Target MappingData AnalysisUnit TestingIntegration TestingAdvanced TroubleshootingETL SpecificationsData Modeling

Soft Skills

Effective CommunicationCustomer Service SkillsCollaborationListening SkillsVerbal and Written Communication

Tools & Technologies

Microsoft SQL ServerSnowflakeRedshiftSSISAzure Data Factory

Industry Keywords

AgileScrumData Warehouse DevelopmentCompliance StandardsRisk Mitigation

Tech Stack

Tools & technologies

Amazon RedshiftAzureCloudETLMS SQL ServerSQLSSIS

About the role

Key responsibilities & impact

Perform intermediate-level data warehouse architecture
Create data models for moderate to advanced subjects
Create ETL specifications to meet business data needs
Develop and maintain design and operation documentation
Analyze data sources and recommend solutions, including risks and mitigation
Participate in long-term data warehouse and dashboard architecture planning
Create and manage data warehouse and analytics architectures for solution development
Propose requirements, standards, and best practices for data modeling, ETL specifications, and data warehouse development
Review existing systems for compliance with established standards and to empower business operations
Conduct product and vendor research and present recommendations to database developers and/or management
Establish and maintain relationships with vendors and equipment suppliers, including installation and repair of services

Requirements

What you’ll need

Minimum 2 years of data design/data architecture experience and/or minimum 2 years of data warehouse architecture experience
Dimensional modeling experience
Data quality assessment
Proficiency with SQL
Agile/Scrum methodology
Source-target mapping
Data analysis
Working knowledge/skills of Microsoft SQL Server
Working knowledge of cloud data warehousing tools such as Snowflake or Redshift
Working knowledge/skills of ETL tools such as SSIS or Azure Data Factory
Advanced troubleshooting of system performance issues and root cause
Working knowledge/skills of unit and integration testing
Effective communication, listening, verbal, written, and customer service skills
Ability to articulate policies and instructions clearly
Ability to communicate appropriate detail to technical and non-technical staff
Ability to recommend policies, document risks, and propose solutions to IT management and senior leadership
Ability to collaborate across departments
Ability to learn, evaluate information, and determine appropriate actions
Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day
Ability to hear and speak clearly for at least 3–6 hours/day

Benefits

Comp & perks

Bonus opportunity; 5% annual SIP target
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
Supplemental benefits including voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, and 529 College Savings
Retirement plan with employer contributions
Paid time off (PTO)
Paid State Sick Time
Paid holidays
Volunteer time
Jury duty leave
Bereavement leave
401(k) contributions for non-benefits-eligible employees
Remote work from home