WHY CIVICA?

Because patients should have the essential medicines they need when they need them. As a rapidly growing, entrepreneurial, nonprofit generic drug company created by hospital systems and philanthropies, Civica’s mission is to reduce and prevent drug shortages while assuring quality generic medicines are accessible and affordable to everyone.

Because the United States experiences chronic shortages of essential generic medicines used daily in hospitals, we are building a state-of-the-art sterile injectable manufacturing facility to combat these shortages. This new facility is part of our broad strategy to stabilize the supply of generic medicines for emergency rooms, surgeries, COVID-19 patient care, and an array of other serious conditions. 

WHO CIVICA SERVES

While serving 50 health systems and 1,350 hospitals (or 30% of all licensed U.S. hospital beds), Civica also supplies the U.S. Department of Veterans Affairs, the U.S. Department of Defense, and “340B” hospitals caring for vulnerable patients in some of the country’s most underserved areas. And recently, Civica contributed more than 2-million vials of essential medications to the strategic national stockpile. 

With 40 sterile injectable medications under contract to supply our member hospitals, Civica is growing and on track to have 100 drugs under contract by 2023.   As we continue to grow, we have many exciting opportunities for multiple types of roles and with opportunity to progress YOUR career. 

Commentary: The Health Care Utility Model: A Novel Approach to Doing Business

POSITION SUMMARY 

Expert SQL writer with successful ETL track-record. Manage the company enterprise data warehouse (EDW). Ensure data is sourced appropriately and data is cleaned, validated, reconciled and “ready to use” for analytics. Lead data governance efforts. Remote job. Company located in Lehi, UT.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• BUILD DATA SYSTEMS AND PIPELINES: Scope, define and document data warehousing/extract, transform, load (ETL) requirements through implementation and testing. Identify opportunities for data acquisition, such as writing application program interfaces (API).  Provide production support to ensure stability and efficiency.
• DATABASE ADMIN:  Design, maintain and document the process to manage users and permissions. Develop, implement, and monitor database backup and recovery procedures.  
• EDW PERFORMANCE ANALYSIS:  Establish measures to chart progress related to completeness and quality of data and meta-data for enterprise information, to support reduction of data redundancy and fragmentation, elimination of unnecessary movement of data, and improvement of data quality.  Stand up design review board for Analytics and Data platforms using industry best practices. 
• EDW MANAGEMENT: Manage enterprise data warehouse (EDW) architecture and improve performance.  Implement database technology solutions that are robust and scalable based on the business requirement.
• RECONCILE/QA DATA: Develop automated systems to monitor data integrity/quality and data lineage.  Able to validate and reconcile big data sets.
• DATA GOVERNANCE:  Establish standards, processes and tools for data strategy, data life cycle, data ownership, data definition and data classification to be used across the organization.  Define the process to resolve cross-organizational data management issues. Ensure departmental/software development standards are being followed by the team.
• DATA SOLUTIONS: Lead research, design, and implementation of maintainable, scalable, reusable and performant software solutions that meet functional and non-functional requirements and that are aligned with strategic direction.
• 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’ relevant experience.
• Must be a quick learner with demonstrated the ability to solve complex problems with minimal direction.
• Excellent programming skills in writing Queries, Views, User Defined Functions and Common Table Expressions using SQL. Experience with stored procedures a plus.
• Ability to balance multiple tasks simultaneously.
• Extreme attention to detail and data accuracy
• Strong interpersonal and communication skills.
• Bachelor’s degree in analytics, mathematics, computer science, engineering, business, or related field.
• Experience with Postgres, Snowflake, Talend, VBA, 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.

NOTE

This job description in no way states or implies that these are the only duties to be performed by the employee(s) incumbent in this position. Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments. All duties and responsibilities are essential functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this job successfully, the incumbents will possess the skills, aptitudes, and abilities to perform each duty proficiently. Some requirements may exclude individuals who pose a direct threat or significant risk to the health or safety of themselves or others. The requirements listed in this document are the minimum levels of knowledge, skills, or abilities. This document does not create an employment contract, implied or otherwise, other than an “at will” relationship.