*HI,*
*Please find below Position matching to your profile and let me know if you are interested.* * Location is Indianapolis, IN *Must be GC or Citizens * Phone interview* *Job Description:* The Data Analyst is responsible for developing the logical and physical data base design and documentation for both mainframe and client/server systems within Sallie Mae. The Data Analyst is also responsible for providing metadata management and support to various departments within systems as well as throughout Sallie Mae. The individual provides subject matter expertise in a broad range of Data Management disciplines, including data normalization techniques and data rationalization. *A Data Analyst will have:* ¨ A working understanding of data administration concepts, principles, and industry "Best Practices" ¨ Experience developing logical and physical data models and associated meta data in accordance with corporate guidelines and naming standard conventions ¨ Strong written and verbal communication skills ¨ A thorough understanding and experience with normalization techniques ¨ Experience with Entity Relationship (ER) Diagramming tools ¨ Actively participates in the development and implementation of policies and procedures related to development and support of new and ongoing systems to ensure the integrity of data. ¨ Coordinates data models, dictionaries, and other database documentation across multiple applications. ¨ Ability to work in a high volume environment. ¨ Works with development teams, migration manager and database administrator to ensure that the model design and development is properly updated, loaded and communicated. ¨ Maintains data integrity by working to eliminate redundancy and adhering to requisite data governance rules set forth by the Bank. ¨ Stays informed of the ways the organization uses its data. *Functions:* ¨ Logical Data Model Development 20% o Work closely with development teams to identify the data required by the application and business processing. Data requirements gathering may be through individual meetings or through conducting Joint Application Development (JAD) sessions. o Responsible for developing the logical data model which consists of developing the entity-relationship diagram (ERD), creating entity and data item business names and descriptions as well as defining data item valid values, type and length, and physical target names. o Meta data management including the enforcement of standards and naming convention. o Document all deliverables within the ER diagramming tool ¨ Physical Data Model Development 30% o Responsible for the process of data normalization as well as working closely with the DBA to reach a consensus on the physical data base design. o Document all primary and foreign keys, indexes and constraints o Generate DDL/Alter table scripts for implementation by the DBAs ¨ Meta Data Support 25% o Respond to ad hoc requests regarding metadata information on the various systems that DM supports. o Establish and maintain constructive user relationships to better manage user expectations. o Support data rationalization efforts and develop data models using Select SE and ERWIN. o Determine appropriate enterprise-wide data strategy and articulate tasks to help move the organization towards the strategy. ¨ Customer Service 15% o Coordinate the completion of data base change requests within the Data Management team o Work with clients to complete data base change requests in a timely manner. o Complete deliverables that are consistent, accurate, and follow all corporate naming conventions and guidelines. ¨ Project Management 10% o Keep management informed of critical issues. o Complete metrics and auditing information for reporting purposes. o Commit to and meet deadlines in both quality and time. o Develop department procedures and standards. o Develop corporate naming guidelines and standard abbreviations. *Mandatory Skills and Requirements: * o Experience with configuration management concepts, practices, and procedures relative to data modeling in a high volume environment. o Experience with data modeling tools, practices, approaches. o Ability to operate a PC or CRT o Ability to understand business problems and translate these problems into automated and non-automated solutions o Knowledge of data administration principles o Knowledge of logical and physical data base design techniques o People management skills, including the ability to direct, counsel, lead, and motivate staff in a matrix environment. o Strong technical skills required to ensure technical solutions are efficient and optimal o Strong written and oral communication skills o Knowledge and support of departmental standards and guidelines o Ability to multi-task o Demonstrated proficiency in the use of structured analysis and design techniques including normalization o Must be familiar with ER diagramming tools. *Thanks & Warm Regards,* *AMIT BAJPAI,* *United Software Group Inc.* <http://www.usgrpinc.com/images/usg_logo.jpg> * 565 Metro Place S. Suite # 110* *Dublin, OH 43017 * *Phone: 614-588-8476* *Fax: 1-866-764-1148* *[email protected]* <[email protected]> *www.usgrpinc.com* <http://www.usgrpinc.com/> *Gtalk: bajpai.recruiter | YIM: amitbajpai000 | Skype: amitbajpai_USG * To unsubscribe from this mailing, please reply to this email with the word UNSUBSCRIBE <[email protected]?subject=UNSUBSCRIBE%E2%80%9D.> in the subject line, or click here. -- You received this message because you are subscribed to the Google Groups "IT RECURITER" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/it-recuriter. For more options, visit https://groups.google.com/d/optout.
