IS Data Warehouse Architect II

$109,500 - $133,840/Yr

Careoregon - Phoenix, AZ

Full-time - Mid Level

Remote - Phoenix, AZ

Insurance Carriers and Related Activities

About the position

The IS Data Warehouse Architect II position at CareOregon is an intermediate-level role focused on the design and development of data models and ETL specifications, data analysis, system design and architecture, and vendor coordination. This fully remote position requires candidates to reside in specific states and emphasizes the importance of equity, diversity, and inclusion within the organization.

Responsibilities

• Create data models for moderate to advanced subjects.
• Develop moderate to advanced ETL specifications to meet business data needs.
• Analyze data sources and recommend solutions, including risk mitigation strategies.
• Participate in long-term data warehouse and dashboard architecture planning.
• Manage data warehouse and analytics architectures for solution development.
• Propose requirements, standards, and best practices for data modeling and ETL specifications.
• Conduct product and vendor research and present recommendations to management.
• Establish and maintain effective working relationships with vendors.

Requirements

• Minimum 3 years of data warehouse architecture experience.
• Working knowledge of Microsoft SQL Server.
• Experience with cloud data warehousing tools such as Snowflake or Redshift.
• Familiarity with ETL tools like SSIS or Azure Data Factory.
• Advanced troubleshooting skills for system performance issues.
• Effective communication skills, both verbal and written.
• Ability to collaborate effectively with coworkers and leaders across departments.

Nice-to-haves

• Experience in health care or managed care.
• Data Architect experience.

Benefits

• Estimated hiring range of $109,500 - $133,840 per year.
• 5% bonus target.
• Full benefits package.