wwwLathaHR.com Urg: Need Sr. Data Warehouse/EDW Data Architect in Detroit, MI, 1 year contract, Client- HAP

Hi,

      Hope you had a great weekend, I have an opening for Data Warehouse/EDW Data Architect in Detroit, MI. Below here is the JD, I am looking forward to discuss this opportunity, please suggest me, if this Job is relevant match for your experience.

 

Client is looking for an enterprise Data Modeler (Data Architect is a good search term) that has designed 'payer' data warehouses and data marts (Dimensional models – stars and snowflakes) with ERWin.  They really need to know payer data and must have had this role at other payers. 

 

Role: Sr. Data Warehouse/EDW Data Architect
Client: HAP
Location: Southfield, MI
Length: 6- 12 months contract

Onsite daily (Monday-Friday)

Description:
• Provide oversight and validation of standard data architecture & ETL environment.
• Establish scalability of database environment.
• Establish standards for ETL, database storage, security, and data administration.
• Establish documented procedures for data movement, staging, and ongoing maintenance in conjunction with the enterprise architecture.
• Establish the enterprise model to support all data input and output requirements (conceptual, logical, and physical).
• Manage overall architecture of all aspects of the data infrastructure (technical and database)
• Determine hardware, software, and communication requirements.
• Validate ETL Requirements.
• Coordinate ETL procedure development to ensure conformity, compliance with standards and lack of redundancy
• Translate business rules and functionality requirements into ETL procedures.
• Establish documented procedures for data movement, staging, and ongoing maintenance in conjunction with the enterprise architecture.
• Analyze & document existing EDW ETL processes
• Profile and validate data in source systems through to the EDW
• Document Source to Target Mapping and business rules
• Capture metadata with assistance of data stewards
• Analyze data defects within the EDW and identify root cause and solutions
• Work with PMs to develop schedules and work plans
• Develop data extracts for data from the EDW and secondary sources

Requirements:
• IBM Data Stage Required
• Health Care Domain Experience Required
• Exceptional technical skills to evaluate the current work done to date by working WITH the RCG team
• Very strong health care expertise in EDW models, ETL, design trade-offs, data analysis, etc.
• Senior level business analysis skills
• Flawless communication and political skills including the ability to work harmoniously with other consultants (RCG), write technical documentation and present findings up to director-level executives and the CIO

 

Thanks & Regards,

Lav Yadav
Source Infotech Inc.
40 Brunswick Avenue, Suite # 200, Edison, NJ, 08817
EMAIL: lyadav@sourceinfotech.com
Phone: 646.216.8084 | Fax: 732-909-2282 |

      Gtalk: lav.okaya

--
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/groups/opt_out.