Data Architect – Operations

Job Description:Employer: IHC Health Services, Inc. (D/B/A Intermountain Health)Job Title: Data Architect – OperationsDegree Required: Master’s degree or equivalent foreign educationAcademic Discipline(s): Computer Science or Electrical EngineeringExperience Required: 2 years’ experienceAlternate Occupations Accepted: Computer Science or Electrical EngineeringJob 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 by business 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.00Work 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 FridayApplicants 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:06/05/2024Location:Lake Park BuildingWork City:West Valley CityWork State:UtahScheduled Weekly Hours:40The hourly range for this position is listed below. Actual hourly rate dependent upon experience.$53.05 - $83.52We 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 (https://intermountainhealthcare.org/careers/working-for-intermountain/employee-benefits/) , and for our Colorado, Montana, and Kansas based caregivers (http://www.sclhealthbenefits.org) ; and our commitment to diversity, equity, and inclusion (https://intermountainhealthcare.org/careers/working-for-intermountain/diversity/) .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.Intermountain Health is a Utah-based, not-for-profit system of 33 hospitals (includes "virtual" hospital), a Medical Group with more than 3,800 physicians and advanced practice clinicians at about 385 clinics, a health plans division called Select Health, and other health services. Helping people live the healthiest lives possible, Intermountain is widely recognized as a leader in clinical quality improvement and efficient healthcare delivery.Join our world-class team and embark on a career filled with opportunities, strength, innovation, and fulfillment.To find out more about us, head to our career site here (https://intermountainhealthcare.org/careers/?utmsource=Workday&utmmedium=Redirect&utmcampaign=CareerHomeworkday) .Sign up for job alerts! Click ‘sign in’ at the top right corner, create a candidate account, and when we have opportunities that meet your interests, you will receive an email with the job details.Intermountain Health strives to make the application process accessible to all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact 1-800-843-7820 or email recruitment@imail.org . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.We intentionally work toward an Intermountain Health that reflects our diverse communities and provides culturally competent care, health equity, and a sense of belonging amongst all our caregivers (employees). This is an important part of fulfilling our mission to help people live the healthiest lives possible. The three pillars of our work are talent experience with Intermountain (application, internship, development, etc.), community benefit, and care delivery.Learn more about diversity at Intermountain, here. (https://intermountainhealthcare.org/careers/working-for-intermountain/diversity/)Introduce yourself to our Talent Acquisition team and we will get in touch if there is a role that seems like a good match.Intermountain Health’s PEAK program supports caregivers in the pursuit of their education goals and career aspirations by providing up-front tuition coverage paid directly to the academic institution. The program offers 100+ learning options to choose from, including undergraduate studies, high school diplomas, and professional skills and certificates. Caregivers are eligible to participate in PEAK on day 1 of employment. Learn more. (https://intermountainhealthcare.org/careers/working-for-intermountain/employee-benefits/peak-program/)The primary intent of this job description is to set a fair and equitable rate of pay for this classification. Only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties may be assigned by the supervisor.All positions subject to close without notice.Thanks for your interest in continuing your career with our team!