Jobs via Dice
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 $111,690 - $136,510 / 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 Status Exempt Management Level n/a Direct Reports n/a Manager Title IS Development Manager Department Business Intelligence Requisition 25045 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 and architecture, standards and policy administration, and vendor coordination. Essential Responsibilities Create data models for moderate to advanced subjects. Create ETL specifications to meet business data needs. Develop and maintain documentation of design and operations. Analyze data sources; research and recommend solutions including risk 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 development. Review existing systems for compliance with standards and operational efficiency. Conduct product and vendor research; present recommendations. Establish and maintain relationships with vendors, including installation and repair services. Organizational Responsibilities Align work with the organization's mission, vision, and values. Support diversity, equity, and inclusion initiatives. Meet business goals aligned with strategic objectives. Adhere to policies and procedures. Perform other duties as needed. Minimum Requirements Minimum 3 years' experience in data warehouse architecture, including dimensional modeling, data quality, SQL proficiency, Agile/Scrum, source-target mapping, and data analysis. Preferred Qualifications 2+ years of experience gathering requirements. Experience with Snowflake, Azure, healthcare or managed care, metadata management, performance tuning, ETL/ELT design, cloud warehousing, and systems analysis. Knowledge, Skills, and Abilities Knowledge of Microsoft SQL Server, cloud data warehousing tools (Snowflake, Redshift), ETL tools (SSIS, Azure Data Factory), troubleshooting, and testing. Skills include effective communication, policy articulation, collaboration, learning, stress management, and physical ability to perform repetitive tasks and communicate clearly. Working Conditions Indoor/office environment, outdoor exposure, potential travel, work from home. Candidates of color and veterans are encouraged to apply. CareOregon is an equal opportunity employer. Visa sponsorship is not available at this time. #J-18808-Ljbffr