IS Data Warehouse Architect II

πŸ•’ September 25

Where this job comes from

Posted on CareOregon's careers page β†—CareOregon's careers page, not through a job board

First seen by Remote Rocketship September 25

Still open on CareOregon's site. Checked 3 hours ago.

Apply Now
Logo of CareOregon

CareOregon

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

β€’ Create data models for moderate to advanced subjects β€’ Create moderate to advanced ETL specifications to meet business data needs β€’ Develop and maintain documentation, including current design and operation β€’ Analyze data sources and research and recommend solutions, including potential risks and mitigation β€’ Participate in long-term data warehouse and dashboard architecture planning β€’ Participate in creating and managing data warehouse and analytics architectures for reference and 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 β€’ Work from home; occasional required or optional travel may occur

🎯 Requirements

β€’ 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 β€’ 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 β€’ Candidates should reside in Oregon or Southwest Washington; priority will be given to candidates residing in Oregon and Southwest Washington

πŸ–οΈ Benefits

β€’ Bonus opportunity: SIP target, 5% annual β€’ 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 β€’ 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

Apply Now

πŸ“Š Check your resume score for this job

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

Similar Jobs

πŸ•’ September 24

PerfectServe

201 - 500

πŸ₯ Healthcare

βš•οΈ Healthcare Insurance

☁️ SaaS

Data Engineer building ingestion pipelines and trusted datasets for PerfectServe’s healthcare communication platform. Developing AWS-based warehouse models, testing production data, and documenting owned pipelines.

πŸ‡ΊπŸ‡Έ United States – Remote

πŸ’΅ $115k - $140k / year

πŸ’° Private Equity Round on 2018-05

⏰ Full Time

🟑 Mid-level

🟠 Senior

🚰 Data Engineer

πŸ•’ September 24

Crum & Forster

1001 - 5000

πŸ›‘οΈ Insurance

βš•οΈ Healthcare Insurance

Senior data engineer supporting applications, data integrations, and financial systems at C&F, a property and casualty insurance provider. Building reliable solutions with SQL Server, ETL, and DevOps practices.

πŸ•’ September 24

Motional

1001 - 5000

πŸ’Ό Consulting

πŸ“¦ Logistics

🏭 Manufacturing

Senior Data Platform Engineer building scalable data infrastructure for Motional’s autonomous vehicle technology. Developing data discovery, lineage, processing, and cloud ETL systems.

πŸ•’ September 24

UJET

51 - 200

🚘 Automotive

πŸš— Transport

πŸ”§ Hardware

Data Engineer owning CDC, dbt, BigQuery, Terraform, and Looker systems for UJET’s AI-powered contact center platform. Building trusted analytics and scalable data infrastructure.

πŸ•’ September 23

Long & Foster Companies

10,000+ employees

πŸ›‘οΈ Insurance

πŸ“¦ Logistics

πŸ’Ό Consulting

Managing data engineering and integration teams delivering secure, governed data solutions. Leading cloud-platform initiatives, operational excellence, and cross-functional technology delivery.

Built byΒ Lior Neu-ner. I'd love to hear your feedback β€” Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok