Medfax

SQL Database Developer

US-CA-Glendale
4 months ago
ID
2017-1011
# of Openings
1
Category
Information Technology

Overview

Our mission is to be the world’s single, most- trusted source of truth regarding healthcare institutions, providers, pharmaceuticals and devices to improve outcomes through transparency and accountability.

 

We believe access to accurate, complete information is at the center of healthcare.  MedFax continually ingests data from more than 10,000 sources, creating the first truly validated, trustworthy, actionable tool for the healthcare industry to understand and leverage data in real-time. 

 

About this Opportunity

This is a position that requires someone who genuinely enjoys working with data and applies creativity in the process. The work largely consists of interactive use of SQL to perform ETL processes. We require someone with excellent attention to detail, who takes pride in ensuring that data is correct and consistent. Some of our ground-breaking work includes:

  • Building the world’s most accurate dataset on healthcare providers 

  • Furthering true transparency in healthcare 

  • Creating SQL based infrastructure to feed cross-platform capabilities 

  • Developing real-time monitoring of over 10,000 data sources which are ingested into SQL Databases



Responsibilities

  • Implementation of new data schema, fields, etc.
  • Work with data architecture and development team to come up with optimal database designs and methodology for acquiring, cleansing and integrating data into the MedFax data set
  • Importing data from various sources into an MS SQL Server database with an eye for repeatability and automation
  • Writing complex stored procedures
  • Analyzing, cleaning and de-duping data and building stored procedures to do the same
  • Transforming source data into standardized formats for inclusion in the master database
  • Validating processed results generated by other developers
  • Generating data analytics reports
  • Researching and comparing medical and other information sources

Qualifications

  • 2 to 5 years of hands-on experience working with Microsoft SQL Server, preferably in the field of healthcare.
  • Strong facility with SQL language and significant experience working with one or more relational databases, preferably Microsoft SQL Server
  • General understanding of database theory, and database design.
  • Ability to write and deploy effective triggers, stored procedures and user defined functions
  • Knowledge and experience with various data transfer formats such as csv, pdf, etc.
  • Knowledge and experience with Python would be a plus, although not a requirement
  • Some experience with basic web development technologies (html, php, etc.) would be useful although not necessary
  • Experience working within a cloud based environment, preferably Microsoft Azur
  • Must have very strong verbal and written communication skills in English. The nature of our business is such that our data must be error free in all respects, and this requires that our developers have exceptional command of English vocabulary, spelling, grammar, punctuation, etc.

Education requirements

  • BS degree in Computer Science or another related field
  • Certification in SQL Server
  • Some quantity of healthcare education or background would be a plus.
  • Prefer someone comfortable in both Windows and Mac environments.

 

This is a full-time position with competitive salary plus benefits.

 

MedFax provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity or national origin, citizenship, veteran’s status, age, disability status, genetics or any other category protected by federal, state, or local law.

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed