Data Architect (Virtual Position)
Company: Civica Rx
Posted on: November 22, 2021
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 Job
DescriptionExpert SQL writer with a 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 workers considered. 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 the 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
- 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
- Perform other duties as required. Basic Qualifications and
- 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 EnvironmentThe
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.NOTEThis 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.
Keywords: Civica Rx, Richmond , Data Architect (Virtual Position), Other , Petersburg, Virginia
Didn't find what you're looking for? Search again!