About

Job Description: Employer: IHC Health Services, Inc. (dba Intermountain Health) Job Title: Data Architect Senior - Clinical Excellence Degree Required: Master’s degree or equivalent foreign education Academic Discipline(s): Computer Science, Information Systems, Bioinformatics, Statistics, or a closely related field Experience Required: 0 years of experience Job Description: Provide leadership in developing data marts, designing data models, implementing ETL processes, and ensuring data usability for clients. Lead the physical design and implementation of databases for complex projects, optimizing data presentation for reporting tools. Develop and maintain standards for data warehouse elements, such as architectures, models, tools, and databases ensuring it aligns with best practices. Provide troubleshooting support for data warehouses and address technical issues promptly Design, implement, and operate data warehouse systems to balance optimization of data access and resource utilization to meet performance requirements. Perform complex system and data analysis, using SQL, PLSQL, Python, and other languages to develop solutions through advanced programming and analysis. Build robust processes to streamline data flow by developing data warehouse process models, including sourcing, loading, transformation, and extraction, to support data integration pipelines. Create and manage supporting documentation, including metadata, diagrams of entity relationships, business processes, and process flows, for governance and reference. Ensure proper integration of data with existing standards and business processes to support smooth operations, maintaining consistency across systems. Create plans, test files, and scripts for data warehouse testing, including unit and integration testing to ensure system readiness. Develop, document, and deliver complex ad-hoc queries, consulting with business users to determine needs, feasibility, and priorities. Develop and implement ETL processes and map data between source systems, data warehouses, and data marts, ensuring smooth data flow across them, while verifying the structure, accuracy, and quality of warehouse data. This is a hybrid position requiring in-person presence three days per week. Position may telecommute within reasonable commuting distance of West Valley City, UT. Minimum Qualifications: Knowledge of Oracle or Microsoft SQL Server databases. Knowledge of Alteryx, Cognos, and Tableau. Knowledge of Architecture and Modeling Tools. Knowledge of Data Integration and Strategies. Knowledge of SQL. Knowledge of R and Python. Knowledge of Data Warehouse Concepts, Models, Cohorts, Metrics and KPIs. Knowledge of Informatica Intelligent Cloud Services and PowerCenter, and BMC – Control-M. Knowledge Azure Databricks. Knowledge of EPIC Clarity and Caboodle. Knowledge of EPIC Cogito. Knowledge of EPIC Caboodle Development. Knowledge of EPIC Clinical Data Model. Upon hire, all applicants will be subject to drug testing/screening and background checks. Salary (Annual): $117,645.00 – $127,645.00 Work Location: 4646 Lake Park Blvd., West Valley City, UT 84120. This is a hybrid position requiring in-person presence three days per week. Position may telecommute within reasonable commuting distance of West Valley City, UT. 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.wd108.myworkdayjobs.com/IntermountainCareers and search for the job title above or search for job number R154989 or email 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: Location: Lake Park Building Work City: West Valley City Work State: Utah Scheduled Weekly Hours: 40 The hourly range for this position is listed below. Actual hourly rate dependent upon experience. $43.92 - $69.16 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 package here. 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. At Intermountain Health, we use the artificial intelligence ("AI") platform, HiredScore to improve your job application experience. HiredScore helps match your skills and experiences to the best jobs for you. While HiredScore assists in reviewing applications, all final decisions are made by Intermountain personnel to ensure fairness. We protect your privacy and follow strict data protection rules. Your information is safe and used only for recruitment. Thank you for considering a career with us and experiencing our AI-enhanced recruitment process. All positions subject to close without notice. Headquartered in Utah with locations in six primary states and additional operations across the western U.S., Intermountain Health is a nonprofit system of 34 hospitals, 400+ clinics, a medical group of more than 4,800 employed physicians and advanced care providers, a health plan division called Select Health with more than one million members, 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. 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. 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. 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!