Data Architect - Senior

Job Description:

Employer: SelectHealth, Inc.

Job Title: Data Architect - Senior

Degree Required: Master’s degree or equivalent foreign education

Academic Discipline(s): Computer Science, Information Systems, Mathematics, or a closely related field

Experience Required: 1 year of experience

Alternate Occupations Acceptable: Computer Science, Information Systems, Mathematics, or a closely related field

OR

Degree Required: Bachelor’s degree or equivalent foreign education

Academic Discipline(s): Computer Science, Information Systems, Mathematics, or a closely related field

Experience Required: 5 years of post-degree progressive experience

Alternate Occupations Acceptable: Computer Science, Information Systems, Mathematics, or a closely related field

Job Description:

· Records detailed logical and physical data models in the information repository and coordinates the publication and maintenance of these models. Ensures appropriate integration of models and designs across the enterprise.

· Facilitates database design sessions and translates business requirements into logical and physical system designs for moderate to large complex projects.

· Coordinates the physical database design and implementation process for moderate to largely complex projects. Designs the optimal data presentation environment for the customer and works with various reporting tools.

· Coordinates with specific database performance monitoring and tuning tasks including the design of optimization and indexing schemes for moderate to large complex projects.

· Develops, tests, and implements moderately complex ETL (extract, transformation, and load) routines.

· Documents business requirements and essential functionality requirements for in-house developments and the selection of third-party applications.

· Provides coordination for moderate to large complex projects through development of project work plans, recommendations for optimal utilization of resources, milestone tracking, and coordination of project team efforts. Keeps management and customers informed of progress and exceptions.

· Coordinates the development and implementation of system backup, recovery, and support plans.

· Addresses customer needs, manages expectations and ensures system-wide integration.

· Participates in the technical review process of designs completed by other designers and serves as a mentor to junior designers.

· Develops, documents, and delivers complex ad-hoc queries of production data as requested by business users. Consults with business users performing queries.

· Maintains advanced understanding of industry application development methodologies, tools, and techniques.

· Coordinates projects and understands the differences between On-line Transaction Processing and Decision Support systems and how to appropriately support the requirements and environments for each.

This is a hybrid position requiring in-person presence once per quarter. 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 database design, development, and business intelligence technologies.

· Knowledge of SQL (structured query language).

· Knowledge of information used in a healthcare environment and how healthcare data is produced, consumed, and transformed.

· Knowledge of Cloud Technologies (Databricks, Apache Spark, and Delta Lake) for real-time and batch data processing.

· Knowledge of APIs to retrieve and integrate data from external systems.

· Knowledge of developing APIs to provide data as a product.

· Knowledge of programming languages Python and PySpark for data engineering tasks.

· Knowledge of ETL/ELT processes and tools, including both traditional (SSIS, Informatica) and cloud-native solutions (Azure Data Factory, Databricks).

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

Salary (Annual): $158,787.00 – $168,787.00

Work Location: 5381 S Green St, Murray, UT 84123. This is a hybrid position requiring in-person presence once per quarter. 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 https://imh.wd108.myworkdayjobs.com/IntermountainCareers and search for the job title above or search for job number R160772 email resume to Mary Hansen at [email protected]. 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 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.