IS Data Warehouse Architect II

This is a fully remote position, open to applicants in Oregon.

📋 Description

• Execute Data Warehouse Architecture at an intermediate level.

• Design and create data models along with ETL specifications.

• Perform data analysis and research to propose effective solutions.

• Engage in long-term planning for data warehouse and dashboard architecture.

• Develop and oversee moderate to advanced data warehouse and analytics architectures.

• Suggest requirements, standards, and best practices for data modeling and ETL specifications.

• Carry out product and vendor research and present findings.

• Build and sustain effective working relationships with vendors.

⛳️ Requirements

• At least 3 years of experience in data warehouse architecture.

• Experience with dimensional modeling.

• Ability to assess data quality.

• Proficiency in SQL.

• Familiarity with Agile/Scrum methodologies.

• Experience in source-target mapping.

• Competence in data analysis.

• Preferred background in healthcare or managed care.

• Knowledge of metadata management.

• Skills in performance tuning and optimization.

• Experience with ETL/ELT design.

• Understanding of cloud warehousing solutions.

• Experience in health insurance systems analysis and design.

🏝️ Benefits

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

• Various supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings).

• Robust retirement plan with employer contributions.

• PTO and Paid State Sick Time based on hours worked/scheduled hours.

• Paid holidays, volunteer time, jury duty, and bereavement leave, depending on eligibility.