IS Data Warehouse Architect I

$88,430 - $108,080/Yr

Careoregon - Portland, OR

Full-time - Entry Level

Remote - Portland, OR

Insurance Carriers and Related Activities

About the position

The IS Data Warehouse Architect I position is an entry-level role focused on the design and development of data models and ETL (Extract, Transform, Load) specifications within the Business Intelligence department. This fully remote position requires candidates to reside in specific states, including Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin. The role involves a variety of responsibilities that contribute to the overall architecture and functionality of the data warehouse, ensuring that it meets the business's data needs effectively. In this role, the architect will create data models for basic to moderate subjects and develop ETL specifications that align with business requirements. The position also entails maintaining documentation related to current designs and operations, which is crucial for ongoing data management and system integrity. Data analysis is another key responsibility, where the architect will analyze data sources, research potential solutions, and identify risks associated with data handling. 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 essential, as the architect will work with others to establish requirements, standards, and best practices for data modeling and ETL specifications. Additionally, the role includes vendor coordination, where the architect will conduct product research and develop relationships with vendors to ensure effective service delivery. Organizationally, the architect is expected to align their work with the mission, vision, and values of the organization, supporting its commitment to equity, diversity, and inclusion. The role also involves striving to meet annual business goals and adhering to the organization's policies and compliance needs. Overall, this position is designed for individuals who are eager to learn and grow within the field of data architecture, contributing to the organization's strategic goals.

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.
• Perform work in alignment with the organization's mission, vision, and values.
• Support the organization's commitment to equity, diversity, and inclusion by fostering a culture of open mindedness, cultural awareness, compassion, and respect for all individuals.
• Strive to meet annual business goals in support of the organization's strategic goals.
• Adhere to the organization's policies, procedures, and other relevant compliance needs.
• Perform other duties as needed.

Requirements

• Minimum 1 year of data warehouse architecture experience.
• General knowledge/skills of Microsoft SQL Server.
• General knowledge of cloud data warehousing tools such as Snowflake or Redshift.
• General knowledge/skills of ETL tools, such as SSIS or Azure Data Factory.
• General troubleshooting of system performance issues and root cause.
• General knowledge/skills of unit and integration testing.
• Proficient communication skills, including listening, verbal, written, and customer service.
• Ability to articulate policies and instructions.
• Ability to assist in recommending policies, documenting risks, and proposing solutions to information technology staff and management.
• Possess a high degree of initiative and motivation.
• Ability to effectively collaborate with coworkers and others.

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.