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 as a condition of employment and annually thereafter, where applicable. Medical and religious exemptions may apply.

Adventist Health participates in E-Verify. Visit https://adventisthealth.org/careers/everify/ for more information about E-Verify. By choosing to apply, you acknowledge that you have accessed and read the E-Verify Participation and Right to Work notices and understand the contents therein.

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