SQL ETL Developer / Data Engineer

Civica

Critical shortages of essential generic injectable drugs are an ongoing crisis in U.S. healthcare and have reached an all-time high. Over 300 essential medications are currently reported to be in shortage, according to industry and FDA reports.

Shortages put patients at risk and waste hospital resources.

Civica is a market-based nonprofit solution created in 2018 by health systems and philanthropies for the express purpose of preventing and mitigating drug shortages. Today, nearly 60 health systems have joined Civica, representing over 1,400 hospitals and approximately one-third of all U.S. hospital beds. Civica has also supplied the U.S. Department of Veteran’s Affairs, the U.S. Department of Defense and the U.S. Strategic National Stockpile with essential medicines. Civica currently supplies medicines to health system members in 49 states.

Civica’s mission has expanded beyond the hospital setting to reach consumers directly through CivicaScript, which is dedicated to making quality outpatient generic medicines affordable and available. CivicaScript works with trusted manufacturing partners to develop quality generic medicines and has forged partnerships with like-minded payors, pharmacy benefit managers and pharmacies to enable significant cost savings to be passed along to their customers.

Civica’s new 140,000 square foot state-of-the-art manufacturing facility in Virginia will soon produce a steady supply of more than three dozen sterile injectables, all drugs that are currently in or near shortage. The plant will also produce affordable biosimilar insulins, ensuring all Americans have access to lower cost, quality insulins, regardless of their insurance status.

The Civica Foundation is a 501(c)(3) organization that fosters philanthropic support for Civica’s work to manufacture and distribute affordable medications. The Foundation’s first commitment is to support Civica’s efforts to bring affordable insulin to all Americans. Leaders from nearly every corner of the diabetes ecosystem are partners in this initiative.

Civica is leading a movement for patients, not profits. Because eliminating shortages and stabilizing high prices are in the best interest of patients.

Join us. Learn more at www.civicarx.org

Position Summary

Looking for an ETL developer to automate the ingestion and transformation of data to the company’s enterprise data warehouse (EDW). Company located in Lehi, UT and Petersburg, VA– but position is remote.

Essential Duties And Responsibilities

• Build data systems and pipelines:
  • Scope, design, and document extract, transform, load (ETL) requirements to provide accurate data (mostly with SQL) in the EDW.
  • Exceptional, in-depth, professional experience with SQL is mandatory.
  • Provide production support to ensure stability, accuracy, and efficiency of datasets in the EDW.
  • Python and JSON would be very helpful.
• Agile: Work in monthly sprints to deploy a high volume of completed and thorough solutions in a fast-paced, dynamic environment with a team of talented and dedicated collegues.
• Adhere to work plans and track assignments with minimal guidance.
• EDW Management:
  • Manage enterprise data warehouse (EDW) architecture and improve performance.
  • This includes but is not limited to:
    • Establish and follow standards, processes, and tools for data management.
    • Develop automated systems to monitor data integrity/quality and data lineage.
    • Design and document processes/tools to manage users and permissions.
    • Develop, implement, and monitor database backup and recovery procedures.
• Document/write concisely and clearly.
• A spirit of collaboration, transparent and timely communication is a must.

Physical Demands and Work Environment

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions. While performing the duties of this position, the employee is regularly required to talk or hear. The employee frequently is required to use hands or fingers, handle or feel objects, tools, or controls. The employee is occasionally required to stand; walk; sit; and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus. The noise level in the work environment is usually low to moderate.

Experience and Education

• Bachelor’s degree. (Preference for analytics, mathematics, computer science, engineering, business, or related field).
• Domain experience in healthcare or pharma is a plus.
• Experience with Snowflake, Python, JSON and/or Bash a plus.