Lead Data Modeler----------------Need Full GC and USC--------Need Locals

Job description

Job Title: Lead Data Modeler Location: Reston, VA (travel to DC once a week) Duration: 12 months + Need Full GC and USC Need Locals Project Description: These individuals will work as part of the Informatics Team supporting the Enterprise Data Foundations Operational Data Stores (EDF ODS) and Enterprise Data Foundations NextGen On-Demand Operational Reporting (EDF ODR) Project which aims to improve operational reporting through implementing the EDF. Responsibilities The Lead Data Modeler is responsible for creating, and maintaining, conceptual, logical and physical data models to support EDF ODS and EDF ODR. They will work with the business architects and data architects to fully understand the business requirements and be able to translate them into data structures. They will also work with the DBA’s to establish naming conventions and optimization standards for the database objects. Key Responsibilities • Work with the business and product owners to understand new functionality in products. • Closely work with Data Architects to manage conceptual/logical/physical data models. • Develop and communicate data standards • Effectively communicate with other technology and product team members Other Responsibilities • Build referential integrity into the models. • Work with developers and data architects to design data schemas. • Profile existing databases to thoroughly understand all data. • Standardize database object naming and domains. Required Skills • Bachelor’s Degree in related technical field of study. • 12+ year’s data modeling experience with large scale models. • 10+ years’ experience with data modeling tools (Erwin / ER Studio). • 10+ years’ experience in Data Architecture and Database design patterns. • 10 + years’ experience mapping data elements for ETL purposes. • 10 + years’ experience generating physical DDL to deploy to databases Ability to reverse engineer existing databases. • Ability to build both transactional as well as dimensional models. • Thorough understanding of database technologies (UNIX, DB2, SQL, Data Quality). Preferred: • Experience with Healthcare data a big plus. If you are interested in the below position please forward your profile to preethib@usmsystems(dot)com or call me on 703 468 0398. USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers. Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services. Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps. USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.