CareOregon
Making health care work for everyone.
IS Data Warehouse Architect II
Location
Arizona + 4 moreAll locations: Arizona, Montana, Oregon, Texas, Utah
Posted
21 days ago
Salary
$111.7K - $136.5K / year
Bachelor Degree3 yrs expEnglishCloudETLSQL
Job 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
• Propose requirements, standards, and best practices for data modeling
• Conduct product and vendor research, and present recommendations
Job 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
- Experience in health care or managed care (preferred)
- Metadata management (preferred)
- Performance tuning and optimization (preferred)
- ETL/ELT design (preferred)
- Cloud warehousing solutions (preferred)
- Health insurance Systems analysis and design (preferred)
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.)
- Retirement plan with employer contributions
- PTO and Paid State Sick Time
