**Job Description:**A 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 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 is also responsible for the design, development, and implementation of ETL processes. The Senior Level Data Architect independently manages 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.Job Essentials1. 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.2. Facilitates database design sessions and translates business requirements into logical and physical system designs for moderate to large complex projects.3. 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.4. Coordinates with specific database performance monitoring and tuning tasks including the design of optimization and indexing schemes for moderate to large complex projects.5. Develops, tests and implements moderately complex ETL (extract, transformation, and load) routines.6. Documents business requirements and essential functionality requirements for in-house developments and the selection of third-party applications.7. Assists in leading the effort to ensure proper integration with existing Intermountain data, standards, and business processes.8. 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.9. Leads 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 and serves as a mentor to junior designers.12. 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.13. 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.14. 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 QualificationsBachelor's degree. Degree must be obtained through an accredited institution. Education is verified.Six years experience in database design, development, and business intelligence technologies.- and -Advanced knowledge of SQL (structured query language).- and -Demonstrated high degree of flexibility and motivation in an aggressively changing environment.- 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 healthcare concepts including patient care and healtcare financing.- and -Demonstrated knowledge of basic information used in a healthcare environment and how the data is produced, consumed and transformed.- and -Demonstrated knowledge of advanced data warehousing concepts.Preferred QualificationsExperience 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 -Experience with PL/SQL**Physical Requirements:**Preferred Qualifications+ Master's Degree. Degree must be obtained through an accredited institution. Education is verified.+ Degree in an analytics-related field such as statistics, mathematics, information systems, computer science, finance, economics, or an MBA with an emphasis in analytics+ Demonstrated proficiency and working knowledge on NoSQL and Big data technologies.+ Proficiency using programming languages and tools.+ Strong experience with SQL query tuning.+ Experience in healthcare and population health+ Experience presenting to a variety of audiences and coaching leaders, customers and peers on data analysis best practices, trends, tools, and techniques.+ Solid experience using industry standard BI, statistical, or analytical tools and technologies.+ Demonstrated applied understanding of data visualization design best practices.+ Demonstrated proficiency and an advanced working knowledge of quality improvement principles.**Location:**World Trade Center**Work City:**Salt Lake City**Work State:**Utah**Scheduled Weekly Hours:**40Being a part of Intermountain Healthcare means joining a world-class team of over 38,000 employees and caregivers while embarking on a career filled with opportunities, strength, innovation, and fulfillment. Our mission is: Helping people live the healthiest lives possible.Our patients deserve the best in healthcare, and we deliver.To find out more about us, head to our career site here .**ADA Statement:**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-###-#### or email . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.**Equal Opportunity Employer**Intermountain Healthcare is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.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!
Associated topics: architect, architecture, back end, design, devops, expert, maven, programming, senior software developer, senior software engineer