Job Title: Data Analyst II Description: The Data Analyst II is responsible for reviewing and validating data requirements, providing technical data solutions, and designing logical and physical data structures in support of business data needs. The Data Analyst II must demonstrate the ability to analyze business requirements to develop high-level and detailed data, and access models, conduct business and technical data assessments, and document business metadata. Must have the ability to create and maintain medium to high complexity logical and physical data models and assist in the transformation of these models to physical database implementation.
Responsibilities: • Create, document, and maintain logical and physical data models for medium to large size or complexity projects. • Reverse engineer source system data structures for model sourcing • Participate in definition, communication and governance of data modeling standards • Convert logical data model into first cut physical database models and coordinate generation of DDL with Data Base Administrators (DBAs). • Conduct model reviews with project team members • Work with IT application staff to define source-to-target mappings • Facilitate collection and documentation of the source-to-target transformation and business rules • Provide project estimation support. • Select appropriate data modeling technique • Create high-level scoping models that facilitate a cross-system view of data requirements for the medium to large projects. • Lead diverse individuals to come to an agreement about the definition, representation, sourcing , and delivery of data • Review and support data architecture strategy. • Promote and support data needs of the enterprise as well as the data needs of the project. • Assist in planning data migration and conversion strategies. • Assist in requirements gathering and facilitate technical walkthrough sessions • Provide analysis support and recommend solutions of the data access requirements • Provide assessments and recommendations for data sourcing. • Assist in identification of data integrity problems and recommend solutions Skills, knowledge and experience needed: 3+ years of work experience in a Database management position (or equivalent). 2+ years using data modeling tools such as CA ERwin, ER Studio, Sybase PowerDesigner supporting IT development projects Experience supporting one major RDBMS platform (DB2, Oracle, or SQL Server) College degree in a software development discipline or equivalent work experience. Must work effectively in a team environment Must be able to manage multiple priorities and meet accelerated timelines. Must possess adequate verbal and written communication skills Must possess adequate leadership skills in order to lead and facilitate data design and enhancements efforts. Knowledge of the transportation industry and related business disciplines are preferred Regards Ram r...@power-it.net -- -- Introduce business in 3800 cities. How? ===================================================== Thanks for using group. Moderator 1) This group is managed by www.BRCIndex.blogspot.com 2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business. 3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club) 4) Reply to two message before posting new one. 5) Donot post same message in all 3800 business Referral Club. You received this message because you are subscribed to the Google Groups "Outsource" group. To post to this group, send email to Outsource@googlegroups.com To unsubscribe from this group, send email to outsource-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Outsource --- You received this message because you are subscribed to the Google Groups "Outsource" group. To unsubscribe from this group and stop receiving emails from it, send an email to outsource+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
