shieldshealthsolutions Remote Full-time 2024-02-09

At Shields, we pride ourselves on our culture of inclusion and kindness and the difference we make in patients' lives every day. We are tremendously proud to be certified as a ‘Great Place to Work’ two years in a row. In 2022, we were awarded US Fortune Best Workplaces in Health Care™, Fortune Best Workplaces for Millennials™ & Fortune Best Workplaces for Women™.

Improving lives and elevating performance are at the heart of everything we do. That’s why more health system leaders trust Shields to elevate access, outcomes and growth within specialty pharmacy — delivering value throughout the entire health system. Leveraging our proven Shields Performance Platform – we deliver the financial results that health systems demand and the superior outcomes patients deserve. With the foremost leaders in specialty pharmacy on our team; proven success partnering with more than 70 health systems; and a vested interest in delivering measurable results – we are the partner health systems trust to transform their specialty pharmacy into a powerful growth engine and elevate performance where it matters most.

 

Shields Health Solutions in Massachusetts is hiring a Database Engineer with solid RDBMS experience notably in a Linux-based production environment. As part of the Engineering team, this role involves application programming, production support, and PostgreSQL object management/performance tuning/RBAC.

Engineering integrates partner and reference data daily to drive Shields' Legendary Care model for delivering specialty pharmaceutical therapies to patients and hospital systems. The Database Engineer role is central to Shields’ informatics that drive positive patient outcomes and increased resources for hospitals.

The role involves regular collaboration with end-users, analysts, devOps, and other engineers.  Creative approaches and knowledge transfer have created a tightly knit, collegial team. The ideal candidate will have a background working with a RDBMS in a Linux production environment supporting APIs, ETL processing, and UI applications. Useful experience includes but is not limited to data warehousing, machine learning, reporting, and nightly batch processing.

Engineering uses certain technologies daily and hands-on experience in the following is essential:

  • SQL (PostgreSQL, Oracle, or other RDBMS)
  • pgSQL, PL/SQL, Transact-SQL
  • Bash/Linux

Experience with the following differentiates candidates:

  • Preferred: Python including Pandas and SQLAlchemy
  • Preferred: Git/Bitbucket or other source code control
  • Nice-to-Have: Java (Springboot and Hibernate)

Engineering is Agile and regularly deploys code according to established SDLC principles in a HIPAA regulated business.  Consideration will be given to knowledge/experience with:

  • HIPAA-compliant data management of PHI
  • Atlassian Jira
  • Atlassian Confluence

Experience/ Education:

  • Bachelor's degree from an accredited college or university required with major course work in computer science, a related field, or equivalent work experience.
  • 7+ years SQL Development and RDBMS optimization preferably PostgresSQL (indexing, permissions, query tuning, partitioning, etc.)
  • 3+ years working in an enterprise-grade production environment for SDLC deployments and issue support.

California residents employed by or applying for work at Shields have certain privacy rights. Please review our: California Workforce Privacy Notice and Privacy Policy.  

Shields Health Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.