Data Architect - Helena, United States - Intermountain Health

Intermountain Health Helena, United States

2 weeks ago

Description

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 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.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 and reference the above job title above or search for Job Number R105647 or email your 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.

Physical Requirements:

Anticipated job posting close date:
06/05/2024

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.

$ $83.52

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 to diversity, 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.

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 ) .

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 or email .

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. )

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

Data Warehouse Architect

3 weeks ago

Montana Department of Justice Helena, United States

The role of the · Data Warehouse Architect · is to strategically design and implement a data warehouse composed of data received from multiple agencies, at both the state and local levels, in varying formats while ensuring high levels of data availability. · This position is re ...
Data Warehouse Architect

2 weeks ago

Munro Footwear Group Helena, United States

Job Description - Data Warehouse Architect · Position Title: · Data Warehouse Architect · - · ( · ) · Division Overview: · The · Montana Board of Crime Control · (MBCC) mission · is to proactively contribute to public safety, crime prevention, victim assistance through pla ...
Data Warehouse Architect

2 weeks ago

State of Montana Helena, United States

: · Division Overview: · The Montana Board of Crime Control (MBCC) mission is to proactively contribute to public safety, crime prevention, victim assistance through planning, policy development and coordination of the justice system in partnership with citizens, government, and ...
Data Warehouse Architect

3 weeks ago

State of Montana Helena, United States

Data Warehouse Architect Division Overview: · The (MBCC) mission is to proactively contribute to public safety, crime prevention, victim assistance through planning, policy development and coordination of the justice system in partnership with citizens, government, and commun ...
Senior Salesforce Technical Architect

3 days ago

Confluent Helena, United States

Confluent · Senior Salesforce Technical Architect · Helena , · Montana · Apply Now · With Confluent, organizations can harness the full power of continuously flowing data to innovate and win in the modern digital world. We have a purpose that drives us to do better every day ...
Platform Solutions Consultant

3 days ago

Oracle Helena, United States

Oracle Platform Solutions Consultant - Technical Lead Helena , Montana Apply Now · Do you want to advance your career with the world's first cloud company? Since 1998, Oracle NetSuite has been on a mission to deliver an agile, unified application suite that gives leaders a compl ...
Sr Architect

2 weeks ago

Highmark Health Helena, United States

Company : · enGen · Job Description : · JOB SUMMARY · This position is for an IT Infrastructure architect to drive our strategy, architectural designs, and implementations related to (1.) our public cloud compute and storage ecosystems and (2.) our on-premises and public cloud co ...
Senior Cybersecurity Operations Engineer

2 days ago

Amentum Helena, United States

Amentum · Senior Cybersecurity Operations Engineer · Helena , · Montana · Apply Now · Amentum is seeking a · Senior Cybersecurity Operations Engineer · to support our cyber environment. This is a remote-telework and hands-on role, responsible for ensuring Amentum assets ar ...
Data & Integration Release Engineer

1 week ago

Beacon Hill Staffing Group Helena, United States

Job Title: Data & Integration Release Engineer Salary Range: $120,000 - $130,000 Job Location: This position can be 100% remote. Hiring Manager Notes: I do not expect the ideal candidate to possess all this, but I do expect that many of the items in required certifications and Cr ...
Senior DevOps Engineer

3 days ago

Highmark Health Helena, United States

Highmark Health · Senior DevOps Engineer · Helena , · Montana · Apply Now · This job is responsible to build and maintain automated pipelines, troubleshoot, and analyze complex issues with the DevOps toolchain, and improve the continuous integration and deploy (CICD) pipelin ...
Software Engineer

3 weeks ago

Assurant Automotive Warranty Solutions (India) Private Limited India, United States

We are seeking an experienced Senior Software Engineer to work with the leads of our software development team in enhancing and maintaining our suite of APIs and web-based interfaces. In this pivotal role, you will leverage your expertise in C#, SQL, WCF, and SOLID principles to ...
Senior Architect

3 days ago

Travelers Insurance Helena, United States

Travelers Insurance Company · Senior Architect – Master Data Management · Helena , · Montana · Apply Now · Taking care of our customers, our communities and each other. That's the Travelers Promise. By honoring this commitment, we have maintained our reputation as one of the ...
Senior Architect

2 days ago

Travelers Insurance Helena, United States

Travelers Insurance Company · Senior Architect Master Data Management · Helena , · Montana · Apply Now · Taking care of our customers, our communities and each other. Thats the Travelers Promise. By honoring this commitment, we have maintained our reputation as one of the be ...
Senior Software Engineer

3 days ago

Teradata Helena, United States

Teradata · Senior Software Engineer · Helena , · Montana · Apply Now · This position is for a Software Engineer in the SQL-Engine Services team within the Vantage Core – Platform Software organization. The position involves development, integration, functional and performanc ...
NetSuite Data and Analytics Solution Specialist

3 days ago

Oracle Helena, United States

Oracle · NetSuite Data and Analytics Solution Specialist · Helena , · Montana · Apply Now · Do you want to advance your career with the world's first cloud company? Since 1998, Oracle NetSuite has been on a mission to deliver an agile, unified application suite that gives le ...
Senior Software Engineer

2 weeks ago

Figure Helena, United States

About Figure · At Figure, we're on a mission to transform financial services through blockchain, bringing speed, efficiency and savings to both consumers and institutions. · Accomplishing this kind of transformation requires building really big things. And we understand that bu ...
Principal Machine Learning Applications Engineer

2 days ago

Oracle Helena, United States

Oracle · Principal Machine Learning Applications Engineer · Helena , · Montana · Apply Now · As a Senior Machine Learning Engineer, you should be proficient in building distributed systems, containerization, orchestration, and cloud-native architectures, you will collaborate ...
Senior Customer Solutions Engineer

3 days ago

Rocket Software Helena, United States

Rocket Software · Senior Customer Solutions Engineer (Services Presales) · Helena , · Montana · Apply Now · It's fun to work in a company where people truly BELIEVE in what they're doing · Job Description Summary: · The Senior Customer Solutions Engineer brings creativity, c ...
Senior Software Engineer

2 days ago

Social Finance Ltd Helena, United States

Who we are: · Shape a brighter financial future with us. · Together with our members, we're changing the way people think about and interact with personal finance. · We're a next-generation financial services company and national bank using innovative, mobile-first technology ...
IT Infrastructure Analyst

3 weeks ago

Marriott Helena, United States

Job Number · Job Category Information Technology · Location Frederick Data Center, 7300 Crestwood Blvd, Frederick, Maryland, United States · Schedule Full-Time · Located Remotely? Y · Relocation? N · Position Type Management · JOB SUMMARY · This position is responsible fo ...