Tableau Developer, Contract

Treck Solutions

Business & Technology

4-6mos+, Contract, South Metro

(1)  Quality Competitive Intelligence data warehouse and analytic tool build

  • Automate downloads of publically available datasets from federal gov’t
  • Store in data warehouse within Teradata data lab
  • A previous resource has written initial processes for data downloads using Alteryx, and some MS Access to transpose files
  • Initial work is done, but this was never productionalized for ongoing automated downloads
  • Build out analytical tools looking at quality metric results
  • For internal ____ clients
  • For external competitors
  • A comparison of ____ clients to competitors, etc
  • Using Excel and Tableau
  • Current prototypes exist with code in SAS EG projects and output in Excel.  Need to replicate them in Tableau and perhaps with Alteryx, as well as build out other analytic reports and tools

(2)  Build data warehouse for quality program Master Intervention Grid

  • Use claims and other data to identify which quality measures each member is eligible for
  • Create inventory of intervention programs available for each member and quality measure to intervene with
  • Derive methodology for determining the best (of many) programs to intervene on a member with to maximize the number of measures we can successfully address while minimizing cost and abrasion
  • Data will be stored and manipluated in combination of SAS and Teradata
  • Alteryx also may be used in addition to or in lieu of SAS as appropriate
  • Data can be coming from multiple disparate sources
  • Create analytic tools based off of data using Tableau/Excel etc. to identify opportunities for programs to apply to members
  • Integrate this underlying data into the Excel version of the Master Intervention Grid summary tool Andrew has already been working on

(3)  In addition to and in conjunction with some of the above, we have existing reports built in PDF and Excel, etc. that could be transitioned to Tableau for a better look-and-feel and dynamic analysis capabilities.

  • Medicare/Medicaid/Commercial quality dashboards
  • etc.

Please send a Word resume and lets chat.

John Sturgeleski
Business & IT Recruiter

TRECK Solutions
612.310.4846 cell

connect with me:

To apply for this job email your details to