Data Architect

If you're ready to be part of our legacy of hope and innovation, we encourage you to take the first step and explore our current job openings. Your best is waiting to be discovered.

Day - 08 Hour (United States of America)

This is a Stanford Health Care job.

A Brief Overview

The Data Architect is responsible for providing analytics supporting improvement efforts, generally within a defined value stream or strategic domain. This includes developing data architecture and solutions to sustain improvement efforts and provide ongoing support for existing applications.

Locations

Stanford Health Care

What you will do

• Builds effective working relationships with cross discipline team members, including hospital staff, new users, line management, on/offshore team members, etc.
• Guides user leadership in formulation of project plan, regular status reporting to IT and user management, issue management and escalation
• Develops business cases for new technology solutions. Confidently and professionally presents and defends recommended solution, approach, timeline, etc. to IT and user leadership and manages expectations accordingly
• Organizes and conducts regular project status meetings and design reviews sessions leveraging appropriate project artifacts
• With little supervision, performs analysis of the scope and requirements for projects
• Prepares specifications, designs, data models and diagrams from which databases can be developed
• Develops, tests, and deploys data structures using Entity Relationship Diagramming, SQL Server tools, and data modeling tools.
• Troubleshoots incidents surrounding supported databases and solutions.
• Tunes performance of databases, ETL processes and queries

Education Qualifications

• BS/BA Degree in information technology, information systems, business management, business analytics, business administration or a directly-related field from an accredited college or university. Required

Experience Qualifications

• Two (2) to Five (5) years of experience in analytics, business intelligence or healthcare technology. Required
• One (1) year experience with SQL in an Oracle and/or SQL Server environment. Required

Required Knowledge, Skills and Abilities

• Proficient with complex SQL (multi joins, subqueries, unions) and creation of database objects (tables, views, materialized views, etc.). Ability to utilize performance tuning utilities (Explain Plans, etc.) to optimize queries.
• Delivers high quality Reporting & Analytics solutions that meet user requirements with minimal on-going maintenance and a low volume of production incidents (production failures, help desk calls, etc.).
• Proficient with best practices and common processes for developing solutions with SHC tools (i.e., SSIS, Crystal Reports, WebI, Qlikview, etc.) utilized in role.
• Troubleshoots incidents and enhancement requests surrounding supported applications. Recommends improvements to supported applications.
• Ability to perform basic performance tuning to optimize queries to meet user needs.
• Demonstrated proficiency with Data Warehousing and ETL concepts, including: source to target mapping, transformations, error handling, job control, logging, alerting, and scheduling.
• Demonstrated proficiency in Data Definition Language (DDL) , Data Manipulation Language (DML), and Extraction, Transformation and Loading (ETL) design and development using SQL Server tools (SQL Management Studio, T-SQL, SSIS, Team Foundation, etc.) and/or Epic Clarity Compass.
• Complex Report writing & some metadata (universe) creation with SHC standard tools.
• Operates with minimal supervision.
• Accountable interaction up to Tier 4 levels of the organization
• Demonstrated ability for completing moderately complex projects and/or multiple assigned projects.
• Highly capable individual with expanded skill sets
• Understands SHC's vision and communicates it to others. Appropriately questions how their assigned work relates and supports this vision.
• Mastered one domain and learning others.
• Ability to anticipate design or technical problems and suggest viable alternatives.
• Partner with multidisciplinary teams with limited supervision.
• Track record of consistently good work with only occasional problems or defects.
• Utilizes strategic A3s and is proficient with Lean methods
• Makes reliable operational internal decisions with limited supervision.
• Can present ideas to peers and peer-group end-users. Effective verbal, written, and interpersonal communication skills.

Licenses and Certifications

• None .

These principles apply to ALL employees:

SHC Commitment to Providing an Exceptional Patient & Family Experience

Stanford Health Care sets a high standard for delivering value and an exceptional experience for our patients and families. Candidates for employment and existing employees must adopt and execute C-I-CARE standards for all of patients, families and towards each other. C-I-CARE is the foundation of Stanford's patient-experience and represents a framework for patient-centered interactions. Simply put, we do what it takes to enable and empower patients and families to focus on health, healing and recovery.

You will do this by executing against our three experience pillars, from the patient and family's perspective:

• Know Me: Anticipate my needs and status to deliver effective care
• Show Me the Way: Guide and prompt my actions to arrive at better outcomes and better health
• Coordinate for Me: Own the complexity of my care through coordination

Equal Opportunity Employer Stanford Health Care (SHC) strongly values diversity and is committed to equal opportunity and non-discrimination in all of its policies and practices, including the area of employment. Accordingly, SHC does not discriminate against any person on the basis of race, color, sex, sexual orientation or gender identity and/or expression, religion, age, national or ethnic origin, political beliefs, marital status, medical condition, genetic information, veteran status, or disability, or the perception of any of the above. People of all genders, members of all racial and ethnic groups, people with disabilities, and veterans are encouraged to apply. Qualified applicants with criminal convictions will be considered after an individualized assessment of the conviction and the job requirements.

Base Pay Scale: Generally starting at $52.64 - $69.74 per hour

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training. This pay scale is not a promise of a particular wage.