Data Architect

Located in the metropolitan area of Sacramento, the Adventist Health corporate headquarters have been based in Roseville, California, for more than 40 years. In 2019, we unveiled our WELL-certified campus - a rejuvenating place for associates systemwide to collaborate, innovate and connect.

Whether virtual or on campus, Adventist Health Roseville and shared service teams have access to enjoy a welcoming space designed to promote well-being and inspire your best work.

Job Summary:

Provides support in all aspects of the design, mapping, development, and testing of the data warehouse environment, with emphasis on the database modeling and the creation of appropriate database structures, including development and maintenance techniques surrounding data movement to exploit technologies such as Oracle and Informatica. Designs, builds and tests deliverables for complex ETL process and interfaces spanning multiple applications. Assists in data acquisition and transformation delivery and may provide oversight and technical checkpoints to enforce standards and quality of Business Intelligence solutions.

Job Requirements:

Education and Work Experience:

• Bachelor's Degree in computer science, management information systems, applied mathematics or equivalent combination of education/related experience: Required
• Master's Degree: Preferred
• Three years' experience as an applications developer or data architect within a business intelligence or analytics environment: Preferred
• SQL and database management experience within common DBMS platforms such as Oracle, SQL Server, MySQL, etc.: Preferred
• Understanding of the Software Development Life Cycle (SDLC), knowledge of ETL fundamentals and experience with ETL tools and experience with data quality tools and data quality approaches and techniques: Preferred

Essential Functions:

• Accesses organizations, processes, channels, applications and data to identify practical solutions. Designs data architectures and designs and builds relational databases. Utilizes current strategy in the design of new data models and solutions.
• Implements strategies for data acquisitions, archive recovery, and new database builds.
• Creates standard methodologies for maintaining current and future database systems.
• Maintains and creates enterprise logical and physical data modeling across source, target and external systems. Develops and maintains technical and data model documentation.
• Cleans and maintains the database by removing and deleting old data.
• Performs other job-related duties as assigned.

Organizational Requirements:

Adventist Health is committed to the safety and wellbeing of our associates and patients. Therefore, we require that all associates receive all required vaccinations, including, but not limited to, measles, mumps, flu (based on the seasonal availability of the flu vaccine typically during October-March each year), COVID-19 vaccine (required in CA, HI and OR) etc., as a condition of employment, and annually thereafter. Medical and religious exemptions may apply.

Adventist Health is a faith-based, nonprofit, integrated health system serving more than 90 communities on the West Coast and Hawaii with over 400 sites of care, including 26 acute care facilities, clinics, home care, and hospice agencies in both rural and urban communities. Our compassionate and talented team of 37,000 includes employees, physicians and volunteers driven in pursuit of one mission: living God's love by inspiring health, wholeness and hope.