*Requirement for Data Warehouse Data Modeler consultant*
*Location:* MI *Duration:* 6 Months *Essential Duties:* - Implement logical and physical models for all layers of the data warehouse data model - Develop and implement data migration scripts - Participate in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization - Map data elements of data sources into the domain data models. - Determine and document business rules to be applied to data cleansing. - Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues. - Plans and implements strategies for bundling software for loads into multiple environments. - Assists in all aspects of implementation of normalized Relational and Multi-dimensional Data Models. *Responsibilities:* - Documents and provides insight into Best Practices for Data Warehousing based on expertise and years of experience in data warehouse design and/or data modeling. - Participates in Cross Functional Reviews/Peer Reviews as an Author or Reviewer. - Follows configuration and change management processes as defined by the Project Manager and Technical Manager. - Coordinates with the Requirements Team to understand requirements, provide feedback, and request clarification as needed. - Provides timely, complete and relevant input into schedule and planning for the implementation of the Data Warehouse. Identifies possible risks and solutions. - Performs other duties as assigned by the Modeling and ETL Manager *Education and Experience:* Bachelor’s degree in related discipline plus five (5) years of relevant industry data modeling experience. *Computing Skills:* MS Office tools (MS Word, MS Excel, MS Project) Data modeling tools such as ERwin Extensive knowledge of Data Integration and BI topics Synthesize complex or diverse information Read, analyze, interpret general business periodicals, professional journals, technical procedures or government regulations Identify and resolve problems in a timely manner *Leadership and Communication Skills:* Speak clearly and persuasively in positive or negative situations Listen and seek clarifications; respond well to questions Write clearly and informatively; vary writing style to meet needs Solicit and apply stakeholder feedback Improve processes, products, and services Find ways to improve and promote quality; demonstrate accuracy and thoroughness Thanks & Regards *Ajay * *(469-713-1976 (M)* * 972-607-9595 Ext- 6 (O))* ePower. Inc, 7423 Las Colinas Blvd, Suite 102, Irving, Texas 75063. a...@epowerus.com Fax: (972) 409-9018 www.epowerus.com