IS Data Warehouse Architect I

$88,430 - $108,080/Yr

Careoregon - Phoenix, AZ

posted 2 months ago

Full-time - Entry Level
Remote - Phoenix, AZ
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 initiatives and involves a variety of responsibilities that contribute to the overall data management strategy. The role requires collaboration with various stakeholders to ensure that data solutions meet business needs and adhere to established standards and best practices. In this role, the architect will create data models for basic to moderate subjects and develop ETL specifications that align with business data requirements. The architect will also be responsible for maintaining documentation related to current designs and operations, ensuring that all processes are well-documented and easily accessible for future reference. Data analysis is another critical aspect of this position, where the architect will analyze data sources and recommend solutions that address potential risks and enhance 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. This involves working closely with other team members to identify requirements and best practices for data modeling and ETL specifications, as well as ensuring compliance with established standards. Vendor coordination is also a key responsibility, where the architect will conduct product and vendor research, present recommendations to more experienced database developers or management, and develop effective working relationships with vendors and equipment suppliers. Overall, this position plays a vital role in supporting CareOregon's mission to provide high-quality healthcare services through effective data management and analysis.

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