SQL Database Developer

Location: Minneapolis, MN
Date Posted: 04-02-2018
NorthShore Resources has a Contract opportunity for a Database Developer in Minneapolis, MN!

We are recruiting for a Database Developer to enhance a database system that serves pharmacy operations.  This role will enhance the systems that support a 340B drug program, patient care, and a reporting environment.
 
1.  Enhance the system in a few ways; building out capability to manage / monitor 340B contracts (data flows with other health and pharmacy systems), and implement 3rd party pharmacy system data into the data flow.  In a very simple sense this has multiple software components and SQL queries that are very similar, but have some differences across different vendors.  The job is to standardize what can be, and create something as supportable as possible where it can't.  There are many components to this system, and some of the work can be extended on the existing framework, some will need to be original problem solving.  There are some OS level utilities but the majority of the work is in SQL logic, stored procedures, and probably new tables / data design.
 
There is additional work this role may also be asked to do, depending on the schedule and the rest of the team:
 
2.  Enhancements to the reporting environment to support additional third party data into a pharmacy data warehouse.  This is data design and programming to represent clinical data and therapy encounters to a reporting layer.
 
3.  Enhancements to data feeds to a pharmacy partner organization.  This is again data design, possibly new tables, and logic to verify data and feed it into an extract tool.
 
4.  Data delivery - The group this role is part of is also responsible for putting together extracts and reports to partners and business users / clinicians.  There could be some of this work over the course of the engagement depending on time and schedule.  The environment is mostly Microsoft technologies, the pharmacy data warehouse is Microsoft SQL, the dispensing database is Oracle.  Most of the work is done in the Microsoft SQL, some is done in Oracle (read only, not creating objects in Oracle).

5.  Work directly with business partners and clinicians (who are the SME's).
 
Skills: Skills Skill set and abilities:
--Knowing how to create SQL queries, creating database stored procedures, and creating / modifying tables for operational use as well as reporting and data warehousing.
--Be able to troubleshoot slow performance and other performance tuning


 
Why work for NorthShore Resources?
NorthShore Resources is a Minneapolis-based IT consulting firm, whose focus is to provide superior quality and unparalleled customer service in all aspects of our business. We offer great local jobs to local people, allowing us to build solid, long-term relationships with our clients and consultants.
 
While working as a consultant for NorthShore Resources, you’ll receive benefits such as medical, dental, and 401(k) with company matching. You’ll also receive one of the best benefits an employer can offer – support! Our staff is here to help you every step of the way, ensuring that all of your questions are answered and that you’re placed on a path to success.
 
this job portal is powered by CATS