Data Architect - Staff

$90,459 - $142,438/Yr

Intermountain Health - Las Vegas, NV

Full-time - Mid Level

Las Vegas, NV

Hospitals

About the position

The Data Architect is responsible for designing relational and dimensional databases, applying relational theory and business process analysis to develop logical data models. This role involves converting 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. Additionally, the Data Architect is responsible for the design, development, and implementation of ETL (Extract, Transform, Load) processes. As a Staff level Data Architect, the individual will independently manage moderately complex projects and their components. This includes validating the analysis, models, and data conversion and quality assurance processes. The Staff Data Architect will provide input to help define best practices and standards in database design and business intelligence solutions. This position requires close collaboration with leadership and customers at the corporate level to develop integrated and standardized business intelligence solutions. Proficiency in Python is considered a valuable asset, while expertise in Microsoft SQL is critically important for this role.

Responsibilities

• Records detailed logical and physical data models in the information repository and coordinates the publication and maintenance of these models.
• Facilitates database design sessions and translates business requirements into logical and physical system designs for moderately complex projects.
• Coordinates the physical database design and implementation process for moderately complex projects, designing the optimal data presentation environment for the customer and working with various reporting tools.
• Coordinates specific database performance monitoring and tuning tasks, including the design of optimization and indexing schemes for moderately complex projects.
• Develops, tests, and implements ETL (extract, transformation, and load) routines.
• Documents business requirements and essential functionality requirements for in-house developments.
• Ensures proper integration with existing Intermountain Health's data, standards, and business processes.
• 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.
• Assists in the development and implementation of system backup, recovery, and support plans.
• Addresses customer needs, manages expectations, and ensures system-wide integration.
• Participates in the technical review process of designs completed by other designers.
• Develops, documents, and delivers complex ad-hoc queries of production data as requested by business users.
• Consults with business users performing queries, working effectively with clients and staff to determine needs, specifications, feasibility, and project priorities.

Requirements

• Bachelor's degree in Computer Science, Bioinformatics, Statistics, or a closely related field from an accredited institution.
• Three years of experience in database design, development, and business intelligence technologies.
• Demonstrated high degree of flexibility and motivation in an aggressively changing environment.
• Demonstrated general knowledge of SQL (structured query language).
• Demonstrated interpersonal communication skills to promote and advance business intelligence in collaboration with customers.
• Demonstrated project management skills, customer service skills, and organizational skills.
• Demonstrated ability to deal with highly sensitive and confidential material and adhere to data security and confidentiality protocols and procedures.
• Demonstrated knowledge of general data warehousing concepts and the primary differences between On-line Transaction Processing and Decision Support systems.

Nice-to-haves

• Experience with MS SQLServer DB, Dimensional Modeling/cube creation, Cognos, MS Access, MS Excel, Unix Kornshell.
• Demonstrated knowledge of basic information used in a healthcare environment and how the data is produced, consumed, and transformed.
• Experience with PL/SQL.

Benefits

• Comprehensive benefits package that covers a wide range of programs to foster a sustainable culture of wellness.
• Support for living healthy, happy, secure, connected, and engaged.