Job summary

Metro Detroit, United States, North America
Career Level:
Senior (5+ years of experience)
Bachelor's Degree
Job type:
Full time
$70K - $95K
Apply before:
05 Mar, 2018

Senior Data Warehouse Developer

  Bookmark this job About this job

Our client is a fast growing, private health care provider specializing in Medicaid, Medicare and Pharmacy benefit management based in Michigan serving multiple states. This company has an immediate opening for Sr. Data Warehouse Developer. This position is responsible for developing their healthcare subject matter expertise as it relates to building a new data warehouse on a Hadoop platform, supporting BI reporting, and analytics. The role will build an understanding of the correct business rules to apply, and is essential to assuring that only quality data enters the data warehouse. The senior developer will be concerned about data quality and will ensure that transformation processes properly treat and enrich the data. The senior developer will mentor and assist junior staff in developing SQL, ETL, and data warehouse designs.

The following are high level requirements for the role:    

  • 5+ Years of Experience with Data Warehouse Development in an Enterprise Environment
  • Expert Level Experience in ETL and SQL w/ Talend (or Datastage, Informatica, Pentaho) Tools
  • Healthcare (Payer) or Related Knowledge and Experience (Highly Preferred)


  • Facilitates meetings with business subject matter experts, decision makers, systems owners, and end users to define goals and requirements for a data warehouse.
  • Translates data warehouse goals and requirements into designs, utilizing best practice design patterns.
  • Develops best practice design patterns.
  • Develops warehouse designs with the end in mind, i.e., understands BI and reporting requirements that the warehouse will support.
  • Collaborates as an expert in the planning, design, development, and deployment of new BI applications, and enhancements to existing applications.
  • Collaborates with source system developers to identify relevant data to be included in the warehouse
  • Develops junior level resources so that they learn the craft.


  • 5+ Years of Experience with Data Warehouse Development .
  • 2-3 Years of Experience with Talend Development.
  • Bachelor’s degree in Computer Science/Business Information/Business Administration is required.
  • Extensive experience in data warehousing environments with both Inmon and Kimball methodologies
  • Expert knowledge of ETL processes and data warehouse design, developing both star schema and 3rd normal form warehouses.
  • Expert level SQL knowledge
  • Sophisticated in eliciting and gathering business requirements, developing technical specifications per requirements, and translating requirements into elegant designs.
  • Experience in planning, designing, development, and deployment of BI applications, and enhancements to existing applications.
  • Extensive healthcare experience and related business knowledge.
  • Demonstrated experience mentoring and developing junior colleagues.
  • SQL Knowledge of at least 4/5 or better.
  • ETL Tool knowledge like Talend / Informatica / Datastage, Pentaho of at least 4/5 or better.
  • Phenomenal communication skills, both written and verbal
  • Excellent, expert analytical skills
  • Demonstrated expertise with BI tools, such as Zoomdata, Tableau, and building data cubes
  • Demonstrated expertise with reporting tools, such as Cognos, Crystal, or Business Objects
  • Exposure to or hands on knowledge of Big Data technologies, such as Hadoop, HBASE, Hive, Impala, Hawq, and the knowledge to know when to use them
  • MS Word and Visio expertise
  • Expert ability and desire to mentor and teach others
  • Expert ability to troubleshoot and manage problems independently and with a team

Job keywords/tags:  Data Warehouse Developer , Data Warehouse , Talend , Cloudera , Datastage , Informatica , Pentaho , Scala , Python , Java , Healthcare , Enterprise Environment , ETL , SQL