Data Architect

Data ArchitectThe Virginia Department of Transportation's Information Technology Division is seeking a team member to function as a Data Architect. The Data Architect will analyze business needs, and develop appropriate data deliverables, such as, data models, data flow diagrams, data dictionary and glossaries to meet them. The Data Architect will also assist in issue resolution, in operationalizing data governance, in assessing, measuring and tracking data quality, and in creating and socializing data management artifacts, such as, SOP’s, standards and guidelines, control processes etc. This position will also assist in extending the scope of enterprise data warehouse and the analytics program.Responsibilities:Create data models and xml schemas at all levels including conceptual, logical, and physical for both relational and dimensional solutions. Models will include objects, entities, attributes, their inter-relationships and dependencies in 3N and/or dimensional formats.Integrate disparate data models into coherent enterprise data models.Forward engineer physical models to create DDL scripts to implement new databases or database changes. Reverse engineer databases and synchronize data models with actual data implementations.Create data dictionaries and business glossaries to document data lineages, data definitions and metadata for all business-critical data domains.Identify and reconcile inconsistencies in data definitions, e.g., synonyms and homonyms.Work to identify master data (entities and attributes) and capture how data is interpreted by users in various parts of the organization.Capture business rules that govern how data is transformed, integrated, and used.Develop canonical models and data transformation rules using XMLRequirements:Broad understanding of Data Architecture and Data Management approaches and implementation methodologiesAbility to work with business as well as IT stakeholdersMinimum of 5+ years of experience designing large scale data models for functional, operational and analytical environmentsDemonstrated experience in Conceptual, Logical, Physical and Dimensional ModelingHands-on experience with data modeling toolsKnowledge of BI tools, such as Power BI, TableauExperience with Agile/Scrum is valuableAbility to work creatively and analytically in a team environmentExcellent communication and documentation skills5+ years of experience as Data Modeler/Data Architect creating data models and working in Data Architecture and Data Management solutions.