REQUIRED SKILLS
·Data Architecture. 15 Years
·AWS Cloud Architecture. 15Years
·Operational Data Modeling Skills.15 Years
·Analytical Modeling Skills. 15 Years.
·Canonical Modeling. 10 Years
·Information Governance. 10Years
·Master Data Management. 15years
·Metadata Management. 10 Years.
·Data Cataloging. 15 Years
·Data Engineering and ETL.15Years
·Data Quality. 15 Years
·Excellent written and verbal communication skills. 5years
·Proficiency in MS Office, 5 years
·Strong attention to detail. 5 years
·Ability to write in explanatory and procedural styles for multiple audiences. 5 years
·Skilled at prioritization and multi-tasking. 5 years
·Mainframe Technologies including Cobol, Db2,IMS DB/DC, VSAM, JCL and other middleware tools.
·Knowledge of working in Federal, State and Local Government.
DUTIES and RESPONSIBILITIES
·Conduct Current State Assessment of Data Systems.
·Define System of Record and Data Dictionary for Data Systems Develop Enterprise Conceptual, Logical and Physical Data Models.
· Creates and builds Conceptual, Logical and Physical Models.
·Facilitates Business Sessions and validates business taxonomy and use cases aligned to data models.
·Provide initial design solution for core data model as well as for additional upcoming data sources and required models supporting.
·Support Project Needs to design Conceptual Logical and Physical Models to Modernization Efforts.
Define the NJDOL architecture from Conceptual, Logical to Physical layers. Provide solution expertise to cross functional delivery teams.
·Provide architecture thought leadership and actively participate in the design, implementation, and roll-out efforts.
·Develop and maintain Conceptual, logical and physical data models using best practices and DOL standards to ensure high data quality, reduced data redundancy, and good query performance.
·Reverse and forward engineer data models in Erwin or other Data Modeling Tools.
·Optimize and update Conceptual, logical and physical data models to support new and existing projects and ensure business users are working in a clean safe data environment.
·Assist in the creation of best practices for standard naming conventions and coding practices to ensure consistency of data models.
·Coordinate activities with the rest of the EDL team including developers and testers.
Assist in promoting database objects from lower to higher environments.
·Lead design reviews of data models and other relevant metadata to ensure consistency, quality, accuracy and integrity.
·Recommend opportunities for reuse of data models in new projects.
·Consult with Database Administrators concerning the creation of physical data schema from the logical model by making recommendations, designing referential integrity, and ensuring business requirements are satisfied.
·Consult with ETL developers, report developers, end users concerning how to use the database as designed and how to navigate efficiently within the database.
·Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces, and system integration challenges and solutions.
·Mentor DOL team members on all aspects of Data Modeling.