IS Data Warehouse Architect II

Jobs via Dice; San Antonio (TX); Remote; USD 109,000 - 134,000; Full time

Job summary

A leading company is seeking an IS Data Warehouse Architect II to design and develop data models and ETL specifications. This role involves data analysis, system design, and vendor coordination, contributing to the organization's mission of diversity and excellence. Candidates should have at least 3 years of experience in data warehouse architecture and familiarity with SQL and Agile methodologies.

Qualifications

• Minimum 3 years' experience in data warehouse architecture.
• Experience with dimensional modeling and data quality.
• Familiarity with Agile/Scrum methodologies.

Responsibilities

• Create data models and ETL specifications.
• Analyze data sources and recommend solutions.
• Participate in data warehouse architecture planning.

Skills

Data analysis

SQL

Effective communication

Collaboration

Education

Bachelor's degree in a related field

Tools

Microsoft SQL Server

Snowflake

ETL tools (SSIS, Azure Data Factory)

Job description

Join to apply for the IS Data Warehouse Architect II role at Jobs via Dice.

Dice is the leading career destination for tech experts at every stage of their careers. Our client, CareOregon, Inc., is seeking the following. Apply via Dice today!

Pay & Benefits

Estimated hiring range $109,500 - $133,840 / year, 5% bonus target, full benefits.

Note: Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.

Job Title

IS Data Warehouse Architect II

Exemption

Exempt

Management Level

n/a

Direct Reports

n/a

Manager Title

IS Development Status Manager

Department

Business Intelligence

Requisition

24969

Posting Notes

This is a fully remote position, but you must reside in one of the listed 9 states.

Job Summary

This position performs Data Warehouse Architecture at an intermediate level. Responsibilities include design and development of data models and ETL specifications, data analysis, system design, standards and policy administration, and vendor coordination.

Essential Responsibilities

• Create data models for moderate to advanced subjects.
• Create moderate to advanced ETL specifications to meet business data needs.
• Develop and maintain documentation, including current design and operation.

• Analyze data sources; research and recommend solutions including risks and mitigation.

• Participate in long-term data warehouse and dashboard architecture planning.
• Participate in creating and managing data warehouse and analytics architectures.

• Propose requirements, standards, and best practices for data modeling, ETL, and data warehouse development.
• Review existing systems for compliance with standards and business needs.

• Conduct product and vendor research, present recommendations, and establish vendor relationships.

Organizational Responsibilities

• Align work with the organization's mission, vision, and values.
• Support diversity, equity, and inclusion initiatives.
• Meet business goals and adhere to policies and procedures.
• Perform other duties as needed.

Required Experience and Education

• Minimum 3 years' experience in data warehouse architecture.
• Experience with dimensional modeling, data quality, SQL, Agile/Scrum, source-target mapping, and data analysis.

Preferred Qualifications

• Experience in healthcare or managed care.
• Metadata management, performance tuning, ETL/ELT design, Snowflake, Azure, cloud warehousing, health insurance, systems analysis.

Knowledge, Skills, and Abilities

Knowledge:

• Microsoft SQL Server, Snowflake or Redshift, ETL tools (SSIS, Azure Data Factory), troubleshooting, testing.

Skills and Abilities:

• Effective communication, policy articulation, collaboration, initiative, stress management, physical and auditory capabilities as described.

Working Conditions

Indoor/office, community facilities, outdoor exposure, work from home, occasional travel, ergonomic hazards, general office equipment.

CareOregon is committed to diversity and encourages all qualified candidates to apply. Veterans are encouraged to apply. No visa sponsorship available.