IS Data Warehouse Architect II
CareOregon
full-time
Posted on:
Location Type: Remote
Location: Arizona • Montana • United States
Visit company websiteExplore more
Salary
💰 $111,690 - $136,510 per year
About the role
- 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
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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Data Warehouse ArchitectureData ModelingETL SpecificationsSQLDimensional ModelingData Quality AssessmentSource Target MappingData AnalysisPerformance TuningETL/ELT Design
Soft Skills
CommunicationResearchPresentation