Senior DATA MODELER---------------Need GC,USC,GC-EAD,TN

Senior DATA MODELER

6+ Months

Columbus, Oh.

Need GC,USC,GC-EAD,TN

MUST HAVE SKILLS – Create data models from scratch, OLTP, SQL (very complex) and relational

Top Three Skills:

advanced SQL (join tables, what is an interjoin, group buys, subqueries, windowing functions (analytics)), OLTP (online transactional processing) and relational modeling

Job Description:

The Data Modeler advises the enterprise application teams on data architecture, relational and dimensional database design and modeling, efficient SQL development, and best practices for the IT data development staff as it relates to data management. The position assists IT staff as well as business partners in profiling and understanding their data. The position must communicate clearly and effectively, collaborating with IT and business teams in order to deliver timely and effective solutions. The Data Modeler is expected to be creative and provide lateral thinking, all the while being proactive in finding solutions to the enterprises data needs.

Responsibilities:

- Develops and maintains data models (logical and physical) for operational and analytical systems in the Enterprise

- Maintains the ERWIN model repository and ensures the models are current

- Creates and executes DDL in development environments for any new and/or revised database objects

- Works closely and communicates effectively with the IT development staff on providing the best data design solutions for their needs

- Documents data mappings for integration development teams.

- Works to promote the enterprise’s data governance standards

- Reviews and Approves requests pertaining to database objects in a timely manner.

If you are interested in the below position please forward your profile to preethib@usmsystems(dot)com or call me on 703 468 0398.