Data Engineer

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 data movement for a data warehouse environment, with emphasis on the Extract-Transform-Load (ETL) process. Develops techniques surrounding data movement to exploit technologies such as DB2, Oracle and Informatica. Participates in data acquisition and transformation delivery and provides oversight and technical checkpoints to enforce standards and quality of BI solutions.

Job Requirements:

Education and Work Experience:

• Associate’s/Technical Degree in computer science, management information systems, applied mathematics or equivalent combination of education/related experience: Required
• Bachelor's Degree in computer science, management information systems, applied mathematics or equivalent combination of education/related experience: Required
• Three years' ETL development and architecture or equivalent work experience using Informatica or other ETL tools: Preferred
• Healthcare experience: Preferred

Essential Functions:

• Moderates discussions between technical and non-technical end users including the aptitude to take non-technical requirements and convert them into technical requirements.
• Develops ETL source and target mapping design/specifications based on the business requirements and ETL standards and architecture.
• Develops and executes SQL/stored procedures/ server scripts as needed to support ETL code.
• Designs and executes Unit Test plans and documents results. Designs, builds and tests deliverables for ETL process and interfaces spanning multiple applications. Assesses organizations, processes, channels, applications and data to identify practical solutions.
• Participates in the on-call rotation schedule as needed.
• 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.