Senior Data Modeler
GDIT is actively pursuing an immediate opportunity to continue the modernization of the Provider Enrollment Chain of Ownership System (PECOS) for the Centers for Medicare & Medicaid Services (CMS). If awarded, GDIT will implement CMSs new vision of PECOS modernization efforts, with a heavy emphasis on ensuring that the end-user experience for provider and administrators meets the high standards set by Medicare, Americas most popular healthcare brand. GDIT is seeking truly knowledgeable talent that understand the provider lifecycle, are knowledgeable with the data structures and are highly skilled in their technical execution.Position DescriptionThe Data Modeler will be responsible for designing, building, and implementing large scale data models. In addition, the Data Modeler will be responsible for gathering, understanding, documenting, and communicating the data requirements needed to perform business processes. The Data Modeler will also help to support the delivery of products or components that he or she designed. The Data Modeler will work within a Scrum team to support various technical aspects of the PECOS 2.0 project. The selected candidate will be expected to pick up multiple tasks and to support workload when demand spikes. He or she must be able to consistently deliver while meeting expectations for quality and deadlines. The candidate must be technically adept and well organized with strong communication and analytical skills. The candidate must possess experience with, and an understanding of, all functional layers of large data systems. (Past experience with enterprise systems or big data warehouses is preferred.)Roles and ResponsibilitiesWork within a Scrum team to for gather, understand, document, and communicate the data requirements needed to perform business processesSupport new and existing development projects through the completion of logical data and process modeling activities Create and Maintain entity, logical, and physical data models, especially for an OLTP applicationDevelop, document, and maintain technical solutions and design artifacts for various system components Prepare high quality design documentation, including visual diagrams and processing flows Maintain and updates Database Design Documents (DDDs), Data Dictionary, Data Flow Diagrams.Participate in data governance processes related to data quality and information managementIdentifies and recommends potential system improvements for the existing processing and data flows Define data sources and data models; documents actual data flows, data exchanges, system interconnections, and systems interfaces; ensures that these are aligned with the enterprise data model Bachelors degree in Computer Science, Information Systems, or Computer Engineering, or equivalent experience Required Education, Experience, and SkillsBachelors degree in Computer Science, Information Systems, or Computer Engineering, or equivalent experience7 years of experience with data modeling, data mapping, logical and physical models, data dictionary creation and DDL scripts. Defining and implementing conceptual, logical, and physical data models. Defining Data Sources and data models, documenting actual data flows, data exchanges, and systems interconnections and interfaces. Ensuring these are aligned with the enterprise data model7 years of experience of development/design work with commercial relational databases, such as IBM DB2 or Oracle (Note: This experience should include writing SQL Queries to analyze the data.)5 years of experience working with an enterprise system or another big data warehouse3 years of experience working in an Agile environmentUnderstanding of key technical aspects of large data processing systemsAbility to define and to implement conceptual, logical, and physical data modelsAbility to drive detail design and to engage with technical leads and developersAbility to analyze and/or define detailed data flows through a system (with an emphasis on data ingestion, validation, error handling, storage, and dissemination)Understanding of Informatica PowerCenter ETL Tool, data mappings, transformations, and data flowsDesired Education, Experience, and SkillsUS citizen or a Green Card holderHealth Care Industry or Centers for Medicare and Medicaid Services (CMS) experience Ability to actively contribute and to explain ideas in technical meetingsExperience working with Provider, Beneficiary, Medicare, Claims, and/or state Medicaid dataPrior experience with SAFe Agile Process for Government (A4G)Experience using CAs Erwin data modeling toolExpert level Microsoft VisioConditionsCandidate must be able to obtain Public Trust clearance and must have lived in the United States at least three (3) out of the last five (5) years For more than 50 years, General Dynamics Information Technology has served as a trusted provider of information technology, systems engineering, training and professional services to customers across federal, state, and local governments, and in the commercial sector. Over 40,000 GDIT professionals deliver enterprise solutions, manage mission-critical IT programs and provide mission support services worldwide. GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.