Job Description:

Employer: IHC Health Services, Inc. (D/B/A Intermountain Health)

Job Title: Data Architect - Operations

Degree Required: Master's degree or equivalent foreign education

Academic Discipline(s): Computer Science or Electrical Engineering

Experience Required: 2 years' experience

Alternate Occupations Accepted: Computer Science or Electrical Engineering

Job Description:

• Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
• Verify the structure, accuracy, and quality of warehouse data.
• Design, develop, and implement ETL processes.
• Ensure proper integration of data with existing Intermountain data standards and business processes.
• Develop, document, and deliver complex ad-hoc queries for production data as requested bybusiness users.
• Map data between source systems, data warehouses, and data marts.
• Design and implement warehouse database structures.
• Develop and maintain standards for the design of data warehouse elements, such as data architectures, models, tools, and databases.
• Provide troubleshooting support for data warehouses.
• Write new programs and modify existing programs to meet customer requirements, using SQL PLSQL, Python, Linux, and ETL tools.
• Design, implement, and operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
• Perform system analysis, data analysis and programming, using a variety of computer languages including SQL, PLSQL, and Python.
• Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
• Create and implement metadata processes and frameworks.
• Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.

Position may telecommute from any state in the United States except California, Washington, New York, New Jersey, and Hawaii.

Minimum Qualifications:

• Knowledge of administration, installation, configuration, and upgrades to Oracle databases;
• Knowledge of applying database patches under Linux HP-Unix, IBM-AIX, and Windows platforms;
• Knowledge of MongoDB and MemSQL (SingleStore);
• Knowledge of Real Application Cluster (RAC) and Automatic Storage Management (ASM) environments using the Oracle Enterprise Manager (OEM) Grid Control;
• Knowledge of Unix shell scripting and PL/SQL;
• Knowledge of Log Miner, Toad, and Oracle SQL Developer;
• Knowledge of Red Hat Enterprise's Linux (RHEL).

Upon hire, all applicants will be subject to drug testing/screening and background checks.

Salary (Annual): $137,500.00 - $142,500.00

Work Location: 4646 West Lake Park Blvd, West Valley City, Utah 84120, position may also telecommute from any state in the United States except California, Washington, New York, New Jersey, and Hawaii.

Hours of work: Usually 8 a.m. to 5 p.m., Monday through Friday

Applicants interested in applying for this position should go to https://imh.wd5.myworkdayjobs.com/IntermountainCareers and reference the above job title above or search for Job Number R105647 or email your resume to Mary Hansen at mary.hansen@imail.org. Applicants who fail to provide a resume and pre-screening question responses will not be considered. This position is for permanent direct hire only; applications for contract labor will not be considered.

Physical Requirements:

Anticipated job posting close date:

Location:

Work City:

Work State:

Scheduled Weekly Hours:

The hourly range for this position is listed below. Actual hourly rate dependent upon experience.

We care about your well-being - mind, body, and spirit - which is why we provide our caregivers a generous benefits package that covers a wide range of programs to foster a sustainable culture of wellness that encompasses living healthy, happy, secure, connected, and engaged.

Learn more about our comprehensive benefits packages for our Idaho, Nevada, and Utah based caregivers, and for our Colorado, Montana, and Kansas based caregivers; and our commitment todiversity, equity, and inclusion.

Intermountain Health is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.