SQL ETL Developer Data Engineer

Civica Rx; Petersburg (VA); Remote; USD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking an ETL Developer to automate data ingestion and transformation for their enterprise data warehouse. This role is pivotal in ensuring data accuracy and efficiency, requiring strong SQL skills and experience with ETL processes. The position offers the flexibility of remote work while contributing to a mission-driven organization focused on addressing critical healthcare challenges. Join a dynamic team dedicated to continuous improvement and innovation in the data and analytics domain, making a real impact on healthcare solutions across the nation.

Qualifications

• 2+ years of professional SQL experience and 1+ year writing ETLs.
• Excellent skills in complex SQL queries and problem-solving.

Responsibilities

• Build data systems and pipelines for the enterprise data warehouse.
• Manage EDW architecture and improve performance.

Skills

SQL

ETL Development

Problem Solving

Attention to Detail

Collaboration

Education

Bachelor’s degree in Analytics, Mathematics, Computer Science, Engineering, Business, or related field

Tools

Snowflake

Python

JSON

Bash

Job description

About 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 colleagues. 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.
• Continuous Improvement: Contribute to the continuous improvement of the overall data infrastructure. Identify ways data can be more accurate, trustworthy, and timely. Provide thought leadership around best practices and emerging concepts in Data & Analytics domain. Find opportunities for automating operational database activities to enable the organization to scale and reduce costs.
• Perform other duties as required.

Minimum Qualifications (Knowledge, Skills, and Abilities)

• 2+ years’ professional (not academic) SQL experience. 1+ year experience writing ETLs.
• Deliver on-time, complete and accurate work.
• Excellent SQL skills - Common Table Expressions (CTE), Complex Stored Procedures, Queries, Views, User Defined Functions.
• Must have demonstrated the ability to solve complex problems with minimal direction.
• Ability to balance multiple tasks simultaneously.
• Extreme attention to detail and data accuracy.
• Document/write concisely and clearly.
• A spirit of collaboration, transparent and timely communication is a must.
• 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.

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.