IS Data Warehouse Architect II

Role Overview

• 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)

Tech Stack

• Cloud
• ETL
• SQL

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