Data Architect Senior

Job Description:

Employer: IHC Health Services Inc. (dba Intermountain Health)

Job Title: Data Architect - Senior

Degree Required: Masters degree or equivalent foreign education

Academic Discipline(s): Computer Science Information Systems Bioinformatics Statistics or a closely related field

Experience Required: None

OR

Degree Required: Bachelors degree or equivalent foreign education

Academic Discipline(s): Computer Science Information Systems Bioinformatics Statistics or a closely related field

Experience Required: 3 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 databasesensuring 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 utilizationto 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 once per month. Position may telecommute from any state in the United States except California Connecticut Hawaii Illinois New York Rhode Island Vermont and Washington.

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 of 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): $117645.00 - $127645.00

Work Location: 4646 Lake Park Blvd. West Valley City UT 84120. This is a hybrid position requiring in-person presence once per month. Position may telecommute from any state in the United States except California Connecticut Hawaii Illinois New York Rhode Island Vermont and Washington.

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

Applicants interested in applying for this position should go to and search for the job title above or search for job number R175829 or email resume to Mary Hansen at . 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.

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 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 usethe artificial intelligence (AI) platform HiredScore to improve your job application helps match your skills and experiences to the best jobs for you. WhileHiredScore assists in reviewing applications all final decisions are made byIntermountain 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.