Data Architect (All levels)

Company: Intermountain Healthcare
Location: Salt Lake City
Posted on: March 19, 2023

Job Description:

**Job Description:**The Data Architect is responsible for designing relational and dimensional databases. The Data Architect applies relational theory and business process analysis to the development of logical data models and converts these logical models into physical database objects using data modeling CASE tools. The Data Architect develops and implements enterprise-level strategies and principles for the integration of enterprise information resources by defining corporate standards for data architecture, format, quality, and database design. The Data Architect is also responsible for the design, development, and implementation of ETL processes. The Staff level Data Architect independently manages moderately complex projects and their components. The Staff Data Architect is responsible for the validating of the analysis, models, and data conversion and quality assurance processes. The Staff Data Architect provides input to help define best practices and standards in database design and business intelligence solutions. This position works closely with leadership and customers at the corporate level of the organization to develop integrated and standardized business intelligence solutions.Position is 100% remote, however, currently we are unable to consider candidates for remote opportunities in the following states: California, Hawaii, New Jersey, New York, and Washington.**At this time, we are currently not accepting candidates that require a Visa Sponsorship**1. Records detailed logical and physical data models in the information repository and coordinates the publication and maintenance of these models.2. Facilitates database design sessions and translates business requirements into logical and physical system designs for moderately complex projects.3. Coordinates the physical database design and implementation process for moderately complex projects. Designs the optimal data presentation environment for the customer and works with various reporting tools.4. Coordinates with specific database performance monitoring and tuning tasks including the design of optimization and indexing schemes for moderately complex projects.5. Develops, tests and implements ETL (extract, transformation. and load) routines.6. Documents business requirements and essential functionality requirements for in-house developments.7. Ensures proper integration with existing Intermountain Healthcare?s data, standards, and business processes.8. Provides leadership for moderately 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.9. Assists in the development and implementation of system backup, recovery, and support plans.10. Addresses the customer needs, manages expectations and ensures system-wide integration.11. Participates in the technical review process of designs completed by other designers.12. Develops, documents, and delivers complex ad-hoc queries of production data as requested by business users.13. Consults with the business users that are performing queries. Works effectively with clients and staff to determine needs, specifications, feasibility, and project priorities.**Minimum Qualifications**Bachelor's degree in Computer Science, Bioinformatics, Statistics or closely related field. Degree must be obtained through an accredited institution. Education is verified.Three years experience in database design, development, and business intelligence technologies.- and -Demonstrated high degree of flexibility and motivation in an aggressively changing environment.- and -Demonstrated general knowledge of SQL (structured query language).- and -Demonstrated interpersonal communication skills to promote and advance business intelligence in collaboration with our customers.- and -Demonstrated project management skills, customer service skills, as well as demonstrated organizational skills.- and -Demonstrated ability to deal with highly sensitive and confidential material and adher to data security and confidentiality protocols and procedures.- and -Demonstrated knowledge of general data warehousing concepts and understands the primary differences between On-line Transaction Processing and Decision Support systems and how to appropriately support the requirements and environments for each.**Preferred Qualifications**Experience with the following technologies and tools: Oracle RDBMS, MS SQLServer DB, Dimensional Modeling/cube creation, Cognos, MS Access, MS Excel, Unix Kornshell, CASE tools.- and -Demonstrated knowledge of basic information used in a healthcare environment and how the data is produced, consumed and transformed.- and -Experience with PL/SQL**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.**Location:**SelectHealth - Murray**Work City:**Murray**Work State:**Utah**Scheduled Weekly Hours:**40The hourly range for this position is listed below. Actual hourly rate dependent upon experience.$42.63 - $67.13We 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 (https://intermountainhealthcare.org/careers/working-for-intermountain/employee-benefits/) and our commitment to diversity, equity, and inclusion (https://intermountainhealthcare.org/careers/working-for-intermountain/diversity/) .Intermountain Healthcare 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 SelectHealth, 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 (https://intermountainhealthcare.org/careers/?utm\_source=Workday&utm\_medium=Redirect&utm\_campaign=CareerHome\_workday) .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 Healthcare 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.Intermountain Healthcare 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.We intentionally work toward an Intermountain Healthcare 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. (https://intermountainhealthcare.org/careers/working-for-intermountain/diversity/)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 Healthcare'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. (https://intermountainhealthcare.org/careers/working-for-intermountain/employee-benefits/peak-program/)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. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability or protected veteran status. Women, minorities, individuals with disabilities, and veterans are encouraged to apply.Thanks for your interest in continuing your career with our team!

Keywords: Intermountain Healthcare, Salt Lake City , Data Architect (All levels), Other , Salt Lake City, Utah