About Civica

Civica is a 501(c)(4) social welfare organization established in 2018 by health systems and philanthropies to reduce chronic generic drug shortages and related high prices in the United States. Civica is led by an experienced team of healthcare and pharmaceutical industry leaders.

Today, more than 55 health systems have joined Civica. They represent over 1,500 hospitals and one-third of all U.S. hospital beds. Civica has also begun to supply the U.S. Department of Veteran’s Affairs, the U.S. Department of Defense and the U.S. Strategic National Stockpile of essential medicines.

Civica recently announced plans to expand its mission, via a unit called CivicaScript, to into the outpatient pharmacy space and to manufacture and distribute insulins that, once approved, will be available to people with diabetes at significantly lower prices than insulins currently on the market. The availability of Civica’s affordable insulins, beginning in 2024, will benefit people with diabetes who have been forced to choose between life sustaining medicines and living expenses, particularly those uninsured or underinsured who often pay the most out of pocket for their medications.

Civica’s mission is to ensure that quality generic medications are accessible and affordable to everyone. Since established, the #1 Policy for the Civica team has been “Do What Is in the Best Interest of Patients.” Civica’s manufacturing facility in Petersburg, Virginia, is the future home of affordable insulin and essential sterile injectable medicines. The facility is currently in late-stage construction and hiring for the site is well-underway.

To find out more about how Civica’s innovative model is directly impacting patient care, click here to read a summary from the New England Journal of Medicine. (https://catalyst.nejm.org/doi/full/10.1056/CAT.21.0189 )

To learn more about Civica’s plans to bring affordable insulin to Americans living with diabetes, click here to read an article in BioSpace.

(https://www.biospace.com/article/civica-is-rallying-leaders-to-make-insulin-affordable-by-2024-/)

Position Summary

Looking for a dynamic, top performer who can consistently produce a high volume of quality and timely data models and Tableau visualizations. Draw upon a full range of Tableau features to design, develop, enhance, and support visualizations including, but not limited to highly interactive dashboards, scorecards, and reports. Ability to develop optimized data models using SQL. Repeated and demonstrated success in continuous improvement efforts. Company located in Lehi, UT and Petersburg, VA but remote/virtual work is an option.

Essential Duties and Responsibilities

• TABLEAU – Design, maintain and automate business visualizations/dashboards/KPIs in Tableau using advanced SQL. Follow company standards in dashboard development. At a minimum, you must have a demonstrated track record of professional (not only academic) experience with such things as Writing Custom SQL (not GUI), LOD, Parameters, Data Sources, Actions, Row Based Security and Table Calculations. Must have proven track-record of high-level execution in a fast-paced environment , delivering quality, insightful dashboards on-time and in-spec.
• SQL – Use SQL to pull data from enterprise data warehouse (EDW) to develop data models that follow standards. You must have a demonstrated track record of professional (not only academic) skills including such things as ** : Partitioning, Aggregating, CTEs, Optimization and Automating Data Reconciliation**. You must be able to quickly troubleshoot and develop accurate data models using SSOT tables and effectively and promptly conduct peer SQL reviews.
• COMMUNICATION - Ability to communicate effectively orally and in writing for required customer support, requirements gathering, validation and training.
• CONTINUOUS IMPROVEMENT - Contribute to the continuous improvement of the overall data infrastructure. You must have demonstrated experience of identifying, implementing, and measuring ways data and visualizations can be more accurate, trustworthy, and timely.
• Perform other duties as required.

Minimum Qualifications (Knowledge, Skills, and Abilities)

• 2+ years full-time, professional (not only academic) experience with Tableau and structured query language (SQL) – requirement.
• 3-5 years of technical business analytic experience – requirement.
• Ability to execute a high-volume of on-time and in-spec projects in a rapidly changing environment – requirement.
• Extreme attention to detail and data accuracy – requirement.
• Bachelor’s degree in analytics, mathematics, computer science, engineering, business, or related field.
• Bckground in finance or accounting or experience in managing financial and accounting data desired.
• Strong interpersonal and communication skills.
• Ability to balance multiple tasks simultaneously.