IS Data Warehouse Architect III
CareOregon - Portland, OR
Hiring: IS Data Warehouse Architect III Company: CareOregon Location: Portland, OR Job Posted Time: 2026-09-16 22:05:49 Target Skills & Keywords : Agile, Azure, Data Warehouse, ELT, ETL, Integration Testing, Redshift, SQL, SQL Server, Scrum, Snowflake, Systems Design, Workday About the job Experience: •Metadata management •Systems analysis and design Required Skills: •Data Modeling and ETL Specifications •Create data models for advanced to complex subjects and provide guidance to junior architects. •Create advanced ETL specifications to meet business data needs. •Develop and maintain appropriate documentation, including current design and operation. •Analyze data sources; partner with leaders across the organization to effectively research and recommend solutions which balance business need and risk mitigation. •System Design and Architecture •Recommend long-term data architecture goals and planning for IS and business. •Lead and provide direction in creating and managing advanced to complex data warehouse and analytics architectures for use as reference and as input to solution development process. Qualifications: •Knowledge, Skills And Abilities Required •Advanced knowledge of cloud data warehousing tools such as Snowflake or Redshift •Advanced troubleshooting of system performance issues and root cause •Advanced knowledge/skills of Microsoft SQL Server •Advanced knowledge/skills of ETL tools, such as SSIS or Azure Data Factory •Advanced knowledge/skills of unit and integration testing •Strong communication skills, including listening, verbal, written, customer service, meeting facilitation, and presentations •Demonstrated capacity to clearly articulate policies, instructions, goals, and objectives •Demonstrated capacity to convey appropriate level of detail effectively to all levels of the organization including non-technical staff •Demonstrated capacity to author policies, document risks, and propose solutions to information technology management and senior leadership Compensation: •$126,720 - $154,880 / year •Flexible work environment (work from home / hybrid options) •Competitive benefits and rewards package Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!