Data Architect-Senior

at Intermountain Health in Springfield, Illinois, United States

Job Description

Job Description:

This role will be onsite.

Intermountain is a forward-thinking company at the forefront of Healthcare. We are committed to innovation, excellence, and delivering top-tier services to our clients. Our team is dynamic, collaborative, and dedicated to driving impactful results.

We are seeking a highly skilled ETL Data Architect to join our growing team. In this role, you will be responsible for designing, developing, and maintaining our data extraction, transformation, and loading ETL processes within a legacy platform. We are looking for talent that has experience in legacy technologies as we continue our efforts in migrating to new platforms in our future digital data strategy. This role will be have access to various data sources into our data warehouse, enabling efficient data analysis and reporting.

Our Senior Data Architect will manage projects that are moderate to large in complexity. Also responsible for the mentoring of junior staff and the validating of the analysis, models, and data conversion and quality assurance processes of junior data architects. The Senior Data Architect provides input and leadership to help define best practices and standards in database design and business intelligence solutions. Works closely with leadership and customers at the corporate level of the organization to develop integrated and standardized business intelligence solutions.

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

+ Leads 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.

+ Assists in leading the effort to ensure proper integration with existing Intermountain data, standards, and business processes.

+ Provides leadership 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.

+ Leads the development and implementation of system backup, recovery, and support plans.

+ Addresses the 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 the business users that are performing queries. Works effectively with clients and staff to determine needs, specifications, feasibility, and project priorities.

+ Maintains advanced understanding of industry application development methodologies, tools and techniques. Leads the definition of and subsequently follows enterprise and department-specific standards and methodologies.

+ Leads 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.

Minimum Qualifications

+ Bachelor’s degree. Degree must be obtained through an accredited institution. Education is verified.

+ Six years experience in database design, development, and business intelligence technologies.

+ Advanced knowledge of SQL (structured query language).

+ Demonstrated high degree of flexibility and motivation in an aggressively changing environment.

+ Demonstrated interpersonal communication skills to promote and advance business intelligence in collaboration with our customers

Preferred Qualifications

+ Data management professional with over 10 years of professional experience with strong data warehousing and ETL development experience preferred.

+ Highly desired skillsets include the following:

+ Legacy data management skillsets- Informatica ETL tool expertise, Oracle Database expertise and Strong SQL/PL/SQL

+ Big data and Cloud skillsets: Azure Cloud experience, experience working with Spark framework, and experience with Databricks

+ Experience with Dimensional Modeling, scripting, and Python

Physical Requirements:

Interact with others requiring the employee to communicate information.

- and -

Operate computers and other IT equipment requiring the ability to move fingers and hands.

- and -

See and read computer monitors and documents.

- and -

Remain sitting or standing for long periods of time to perform work on a computer, telephone, or other equipment.

Anticipated job posting close date:

08/16/2024

Location:

World Trade Center

Work City:

Salt Lake City

Work State:

Utah

Scheduled Weekly Hours:

40

The hourly range for this position is listed below. Actual hourly rate dependent upon experience.

$53.58 – $84.36

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