Shields Health Solutions
  • 10-Aug-2017 to 09-Oct-2017 (EST)
  • Quincy, MA, USA
  • Full Time

Business overview:

One of the fastest growing companies in America, Shields Health Solutions partners with hospital leaders on every aspect of specialty pharmacy creation and management. The company provides the fastest, lowest risk model for hospital leaders to create a hospital-owned specialty pharmacy business, whether starting from scratch or adding specialty capabilities to a hospital's existing pharmacy programs.


General description:

The Company is seeking a highly motivated, self-starter who is looking for a challenging career with a fast-growing company in the specialty pharmacy management services.  Applicant should be results-oriented with a positive outlook, and a clear focus on high quality. A natural forward-planner who critically assesses their own performance.  Mature, credible, well-presented, professional and comfortable in dealing with others both in-person and on the phone.  Critical to this position is a person who is able to work well under deadlines and time pressures.  Applicant must be reliable, tolerant, and determined; an empathic communicator, able to see things from the other person's point of view.  Most importantly, person must be able to work as a member of a close-knit team.


Job Purpose:

We are looking for a SQL Engineer who will be responsible for designing complex SQL solutions using scripting stored procedures for reporting and web back end processes. They will also work with other developers optimizing   SQL statements as necessary, and establishing best practices.

The ideal candidate will be comfortable working with internal and external customers to understand their information needs and have the ability rapidly prototype solutions. They will also be able to clearly communicate new features and issues at all levels in the organization.


Specific Skills/Qualifications:

  • Strong proficiency with SQL preferably with Postgres or Oracle
  • Skilled at optimizing complicated SQL statements knowledge of best practices when dealing with relational databases
  • Capable of troubleshooting common database issues
  • Familiar with tools that can aid with profiling server resource usage and optimizing it
  • Proficient understanding of code versioning tools such as {{Git / Mercurial / SVN}}
  • Proficiency with linux scripting and tools  - crontab, bsh, python, Javascript
  • Understanding of ETL design, data cleansing and processing
  • Experience developing, maintaining, or writing stored procedures  is required, preferably in a healthcare industry
  • Experience in Data Mining (i.e., SQL, ETL, complex data warehouses)
  • EMR and Healthcare claims data experience
  • Comfortable with building analytics using BI tools, such as Qlikview or Tableau
  • Familiarity working in a lean entrepreneurial environment where continuous innovation is desired and ambiguity is the norm.


Required Licensure/Certification: Bachelor's degree from an accredited college or university required with major course work in computer science, business information systems, or a related field required

Years of Experience: Required 3-5 years, Preferred 5+ years experience

Traits: Organized, high-integrity, attention to detail, dependable, quality focus, empathetic, good listener/communicator

Other:  energetic, highly motivated, team player with strong personal and communication skills; discretion and confidentiality essential as position deals with highly sensitive and private data


 Job Duties:

  • Develop SQL queries and stored procedure to satisfy data and reporting requirements.
  • Design, build and maintain ETL pipelines to support data and analytical needs.
  • Design and develop data warehouse platform, capabilities, data schemas, and models
  • Build integrations with third-parties to link their data to our systems based on standardized formats such as HL7 using tools such as python
  • Manage multiple concurrent database and software development projects using a Software Development Life Cycle (SDLC), such as Agile Scrum
  • Troubleshoot data issues, validate result sets, recommend and implement process improvements
  • Identify and correct issues relating to database performance, reliability, and scalability
  • Ensure the quick implementation of mass data change requests and complex report/data extraction requests ensuring the impact on existing applications is adequately analyzed
  • Participate in all aspects of the software development lifecycle including requirements, design, coding, user acceptance testing, quality assurance, deployment, and administration
  • Addresses data integrity issues as they arise
  • Document production process flows
  • Other duties as assigned;

Shields Health Solutions
  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

    By clicking the button above, I agree to ApplicantPro's Applicant Information Use Policy.

  • Sign Up For Job Alerts!

  • Share this Page
  • Facebook Twitter LinkedIn Email
Logo Home Services About Partnerships