Hi,
Please find the below requirement from my client: Please take a look at the following opportunity I am working on. Please let me know if you have any consultants available for this position. *Note the portion in Red in the description*. These are the areas candidates will be scored on.. Thanks in advance for the help! *Title*: Data Modeler *Location:* Lansing, MI (the individual would have to be on site 5 days a week) *Duration:* Long Term *SCOPE OF WORK: * * * • The Data Warehouse Modeler will work with State and contract staff to ensure that the JET data warehouse model supports the functionality needed to extract the required data on a regular basis. • Work with State and contract staff to design and load the JET DW database model to support the reporting and analytic needs of DHS, LARA, and MWA. • Work closely with DTMB, DHS and LARA staff to ensure that they are fully aware of the decisions and impacts involved in the Data Warehouse Modeler’s designs and are able to support and extend them by the end of the contract. • As the operational JET Redesign project continues, work with DTMB staff to make the needed changes to the JET DW that may evolve from the operational JET system. * * * TASKS: * Technical support is required to assist with the following tasks: 1. The Data Warehouse modeler will be is responsible for the layout and navigability of a database. This involves defining the tables, keys and relationships that will allow an application to retrieve and update data correctly and efficiently. This may include tasks such as: • Working with end users and developers to understand the data needs of DHS clients. • Documenting the DHS data warehouse data including definitions, constraints and access needs. • Creating and maintaining DHS data warehouse logical designs, including Entity Relationship diagrams, which illustrate what data will be stored, how it is organized, how it can be retrieved (keys) and how it relates to other data in the database. • Creating and maintaining DHS data warehouse data definition language (DDL) that can be used to create and update the database. • Working with the DHS Data Warehouse DBA and ETL developers, modify the logical design to create a physical design most suited to the database environment and the applications that will use it. • Work with DHS Data Warehouse DBA and ETL developers to create and maintain database design standards. 2. The Data Warehouse modeler will be expected to work with agency requestors to define and develop new queries, and provide training and technical support to both DTMB developers and end user query developers. Their report development related tasks may include: • Working with end user requestors to understand their data needs and create and implement solutions for those needs. • Develop and present training classes for end user developers to help them learn how to most effectively use the data warehouse platform and the BI tools available to them to support their own data needs where possible. • Develop and present training classes for DTMB developers to better understand how to use the BI development tools to create and implement reporting solutions using the data warehouse. • Provide one on one support for developers and end users to assist them in accomplishing their data reporting needs. 3. The Data Warehouse modeler is also expected to be able to perform application development tasks in support of building business intelligence applications and integrating data warehouse resources into other Agency applications. Their development related activities may include tasks such as: • Creating data warehouse based applications including reporting, dashboards and other information analysis and delivery systems. • Extract, transform and load systems to move data from the various operational systems in which it is collected to a cleansed, consolidated data warehouse. • SQL development. • Work with developers and end user query developers to design and improve database queries. • Train developers in how best to design queries for a specific database. * * * REQUIRED KNOWLEDGE / SKILLS FOR THE POSITION:* • 6 Years of Data Warehouse Modeling • 4 Years Teradata utilities experience • 3 Years of Erwin experience • 3 Years SQL Assistant experience * * *ADDITIONAL KNOWLEDGE / SKILLS WILL BE BENEFICAL FOR THE POSITION:* * * • Teradata Version 13 experience • Data Warehouse DBA experience • Performance tuning • Business Analyst experience *Please let me know the below details:* Full Name: Contact Number: Email: Current Location: Relocation: Availability: Rate: Visa: SSN#: *Thanks & Regards,* *Pradeep Kumar * *SR. Recruiter* * * *459 Herndon Parkway Suite 10, Herndon, VA – 20170* *[email protected]** I **www.idexcel.com* <http://www.idexcel.com/>* * *Phone: (703) 230-2626 l Fax: (703) 880-7584 * [image: /versions/webmail/8.13.14-RC/images/blank.gif] Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message -- You received this message because you are subscribed to the Google Groups "International SAP Projects" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/international-sap-projects?hl=en.
