As a Data Architect at Intermountain Healthcare, you will be responsible for designing relational and dimensional databases. This position coordinates gathering data requirements from the business, and designing dimensional data models and ETLs to support those requirements for all PeopleSoft and OBIA/OBIEE reporting for Finance, Supply Chain and HR/Payroll ERP applications.
Candidates should have the ability to effectively respond to complex inquiries from clients, coworkers, and or management to solve advanced problems and develop a variety of options in complex situations.
The Data Architect is responsible for designing dimensional databases. The Data Architect applies dimensional 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 position 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 independently manages many complex projects and their components. Also responsible for the mentoring of staff and the validating of the analysis, models, and data conversion and quality assurance.
The 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.
Additionally, Data Architects will be responsible for the following duties:
Expert knowledge of SQL (structured query language). Expert understanding of industry application development methodologies, tools and techniques. Experience working with Oracle’s Supply Chain and Order Management, Procurement and Spend, Financial and Human Resources pre-built Analytics (OBIA). Experience working with Oracle Business Intelligence Enterprise Edition (OBIEE).
Experience working with Informatica PowerCenter and PowerCenter Adaptors. Experience working with Oracle Data Integrator. Experience working with Oracle PeopleSoft and/or E-Business Suite ERP applications for Finance, Supply Chain and HR/Payroll. Knowledge of data warehousing concepts, data modeling/architecting. Must be willing to work evenings or weekends.
Job ID: 207246