Senior Data Warehouse Data Analyst

Data Analyst, Technical Business Analyst, SQL, Teradata, Data Warehouse, Healthcare, Medicaid, BI Query, ERWIN, Data Modeling, ETL, JAD, STAR
Contract W2, Contract Independent, Contract Corp-To-Corp
Work from home not available Travel not required

Job Description

Clover Consulting has an immediate need for a senior level Data Analyst / Technical Business Analyst for our direct client located in Lansing, MI.  This is a long term, multi-year engagement.  Requirement details are listed below.  Qualified candidates should apply to this posting.  NO PHONE CALLS PLEASE.

Title: Senior Data Warehouse Data Analyst

Location: Lansing, MI

Length: long term (multi-year)


  • Design and development of large healthcare data warehouse systems
  • Subject Matter Expert for Master Data
  • Experience with Medicaid/Medicare Enrollment, Eligibility, Encounters, Provides, Capitated Payments and Third Party Liability
  • Expert level SQL skills
  • Work with developers and policy teams to design and develop data loads for data warehouse
  • Lead technical JAD design sessions to solve complex transformations
  • Experience using STAR schema design concepts
  • Create and maintain various technical files to support the Teradata ETL process and develop transformation rules
  • Create functional and technical requirements
  • System Testing and User Acceptance Testing
  • Document existing programming processes and direct new program design/development
  • Manage client expectations and create/maintain positive rapport
  • Facilitate customer meetings
  • Develop content and materials for User Group meetings
  • Develop and deliver training on BI-Query and advanced concepts
  • Write and troubleshoot SQL queries for developers and reporting
  • Provided Help Desk Support as a subject matter expert

Experience with the following technologies:

  • Teradata 15.1
  • SQL
  • SQL Assistant
  • ERWIN 9.2
  • Microsoft Office (Word, Excel, Access, PowerPoint, Visio, Project)
  • Oracle
  • SQL Developer
  • Business Objects
  • BI Query
Dice Id : 10108584
Position Id : KBT-MJO
Have a Job? Post it