Job Description

Join us to make quality medicines available and affordable SQL ETL Developer / Data Engineer 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 savingsto bepassed 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. Lookingfor an ETL developer to automate the ingestion and transformation of data tothe 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. Lead 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 arerepresentative of those that must be met by an employee to successfully performthe essential functions of this position. Reasonable accommodations may be madeto enable individuals with disabilities to perform the functions. Whileperforming the duties of this position, the employee is regularly required totalk or hear. The employee frequently is required to use hands or fingers,handle or feel objects, tools, or controls. The employee is occasionallyrequired to stand; walk; sit; and reach with hands and arms. Theemployee must occasionally lift and/or move up to 25 pounds. Specific visionabilities required by this position include close vision, distance vision, andthe ability to adjust focus. The noise level in the workenvironment is usually low to moderate. #J-18808-Ljbffr Civica Rx

Job Tags

Similar Jobs