Job Description :
Please contact your "eDataForce " recruiter (SAI KIRAN ) for immediate consideration.
================================================ =========
_
* “US citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1b candidates at this time. ” *


Face to Face interview is a MUST

The qualified candidate will be responsible for designing and developing ETL (extract/transfer/load), RTM (real time messaging), reporting, and BI solutions. Using Microsoft BI suite, SP (stored procedures),

Description:
The Sr. Data Analyst 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 Sr. Data Analyst 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 conceptual data models, high complexity logical and physical data models and assist in the transformation of these models to physical database implementation.


Responsibilities:
Create, document, and maintain conceptual, logical and physical data models for large size or high complexity projects.
Reverse engineer source system data structures for model sourcing
Define, communicate and govern 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 large and/or complex projects.
Lead diverse individuals to come to an agreement about the definition, representation, sourcing , and delivery of data
Participate in data architecture sessions and promote integrated systems and controlled data redundancy.
Determine 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:
5+ years of work experience in a Database management position (or equivalent
3+ 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 strong verbal and written communication skills
Must be able to guide junior level data analysts in their work effort
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



Must have Excellent Communication is a MUST