IS Data Warehouse Architect I

$88,430 - $108,080/Yr

Careoregon - Boise, ID

posted 2 months ago

Full-time - Entry Level
Remote - Boise, ID
Insurance Carriers and Related Activities

About the position

The IS Data Warehouse Architect I position at CareOregon is an entry-level role focused on the design and development of data models and ETL (Extract, Transform, Load) specifications. This position is essential for supporting the organization's data architecture and analytics needs. The architect will engage in various responsibilities, including data analysis, system design, and architecture, as well as standards and policy administration. The role also involves vendor coordination and maintaining effective relationships with external suppliers. In terms of data modeling, the architect will create data models for basic to moderate subjects and develop ETL specifications that align with business data requirements. Documentation is a critical aspect of this role, as the architect will be responsible for maintaining current design and operational documentation. The position also requires analyzing data sources to recommend solutions that address potential risks and improve data quality. The architect will participate in long-term planning for data warehouse and dashboard architecture, contributing to the creation and management of simple data warehouse and analytics architectures. Collaboration is key, as the architect will work with others to identify requirements, standards, and best practices for data modeling and ETL specifications. Additionally, the architect will review existing systems to ensure compliance with established standards and support business operations effectively. Vendor coordination is another important responsibility, where the architect will conduct product and vendor research, presenting recommendations to more experienced database developers and management. Building effective working relationships with vendors and suppliers is crucial for the successful installation and repair of services. Overall, this position aligns with CareOregon's mission, vision, and values, emphasizing equity, diversity, and inclusion in the workplace. The architect will strive to meet annual business goals that support the organization's strategic objectives while adhering to relevant policies and compliance needs.

Responsibilities

  • Create data models for basic to moderate subjects.
  • Create basic to moderate ETL specifications to meet business data needs.
  • Develop and maintain appropriate documentation, including current design and operation.
  • Analyze data sources; research and recommend solutions which include potential risks.
  • Participate in long-term data warehouse and dashboard architecture planning.
  • Participate in creating and managing simple data warehouse and analytics architectures for use as reference and as input to solution development process.
  • Collaborate with others to identify requirements, standards and best practices for data modeling, ETL specifications, and data warehouse development.
  • Participate in the ongoing review of existing systems to ensure they are designed to comply with established standards and to empower business operations.
  • Conduct product and vendor research, and present recommendations to more advanced database developers and/or management.
  • Develop effective working relationships with vendors and related equipment suppliers, including installation and repair of services.

Requirements

  • Minimum 1 year of data warehouse architecture experience.
  • Dimensional modeling experience.
  • Metadata management experience.
  • Data quality assessment experience.
  • Performance tuning and optimization experience.
  • ETL/ELT design experience.
  • Experience with cloud warehousing solutions.
  • Proficiency with SQL.
  • Experience in health insurance systems analysis and design.
  • Familiarity with Agile/Scrum methodology.

Nice-to-haves

  • SQL experience
  • Experience in health care or managed care

Benefits

  • Estimated hiring range $88,430 - $108,080 / year
  • 5% bonus target
  • Full benefits package
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service