DATA ARCHITECT 2  
  DEFINITION:
Under general supervision of a supervisory officer within an Information  Technology unit of a State Department or Agency,  serves as a senior  Data Modeler and supervisor; is responsible for logical data modeling,  analysis, design, development, and implementation of Data Modeling,  Data Integration, or Data Warehousing  solutions using Data Management  technologies; administers technologies related to Data Modeling, Data  Integration, and Data Warehousing; works independently on higher-level,  more complex modeling projects; does other related duties as required. 
DISTINGUISHING CHARACTERISTICS
Positions at this level independently work on complex projects or  assignments; receive general, sporadic supervision and work is reviewed  for technical adequacy, conformance with practice and policy, and to  ensure deadlines are met.
NOTE: The examples of work for this title are for illustrative purposes only.   A particular position using this title may not perform all duties listed in this  job specification.  Conversely, all duties performed on the job may not be listed.
 EXAMPLES OF WORK
Supervises a Data Modeling, Data Integration, or Data Warehousing team  or other designated staff. 
Leads work efforts by acting as liaison between Subject Matter Experts  (SMEs) and Data Management Developers to ensure successful design  and implementation of data processing components for data warehouses;  identifies work efforts involved inside and outside of the scope of a particular  project.
Participates in and/or leads Joint Application Development (JAD) meetings  or business requirements gathering sessions with all levels of Information  Technology and/or Information Management staff, business management,  and business users, to enable the development of fully-attributed logical  business and data models in support of Data Management solutions.
Develops data models for more complex, higher-level data projects; provides  guidance to other data modelers working on complex tasks.
Creates logical models as entity-relationship diagrams to document the  entities, attributes, relationships, and business rules of a business domain  or subject area using an Entity-Relationship (ER) modeling tool.
Produces physical data models from the logical data and business models  adding metadata, system attributes, de-normalized columns, and  physical-only tables as required. 
Generates data description language (DDL) from physical data models for  database administrators to use in creating the physical database. 
Maintains data models, metadata documents, and data processing  document files that are essential for project design and implementation  for all Data Management solutions.
Creates business rules and requirements for data integration processes;  provides guidance and support to data integration developers by documenting  rules and procedures required to transform, process, and load data from  multiple source systems; creates and maintains the data dictionary and  source-to-target data mapping documentation as necessary; creates data  conversion plans including data mapping rules and conversion QA/QC  procedures for the converted data.
Provides technical guidance for the integration of data from multiple  independent, heterogeneous data sources; documents the integration  and matching of information from different sources; serves as a subject  matter expert in the resolution of data quality conflicts.
Presents recommendations and reports to higher levels of staff, including  management; prepares project status documentation as needed; develops  and monitors project schedule and deliverables.
Analyzes data integration errors and works with data integration teams to  provide solutions and improve data quality.
Analyzes reporting requirements and assists Business Intelligence developers  in the design and implementation of data warehouse reporting environments.
Creates, reviews, and maintains Data Management naming standards  and best practices; periodically reviews the State's Common Information  Architecture document for efficiency and effectiveness, and recommends  revisions as necessary; assists in designing new policies and standards as  required; makes recommendations for new Statewide Data Management  policies and standards as necessary.
May participate in Logical and Physical Architecture Review (LSAR and  PSAR) meetings to guide logical and physical development of Data  Management solutions. 
Supervises work operations and/or functional programs, and has responsibility  for performance evaluations and for effectively recommending the hiring, firing,  promoting, demoting, and/or disciplining of personnel.
Prepares clear, accurate, and informative statistical and narrative reports  containing findings, analysis, conclusions, and recommendations; maintains  or supervises the maintenance of essential records and files; prepares  correspondence in the course of official duties. 
Maintains current knowledge of Data Management technologies and the  latest trends by reading journals and attending seminars and webinars in  order to support information system needs. 
Will be required to learn to utilize various types of electronic and/or  manual recording and information systems used by the agency, office,  or related units.
 REQUIREMENTS:
NOTE: Applicants must meet one of the following or a combination of both experience and education. Thirty (30) semester hour credits are equal to one (1) year of relevant experience.     
Eight (8) years of professional experience in systems analysis and design, data modeling, and/or data warehousing solutions delivery, two (2) years of which shall have been primarily in logical data modeling.
OR
Possession of a bachelor's degree from an accredited college or university; and four (4) years of the above-mentioned professional experience, two (2) years of which shall have been primarily in logical data modeling.
OR
Possession of a bachelor's degree in computer science or computer/information technology; and three (3) years of the above-mentioned professional experience, two (2) years of which shall have been primarily in logical data modeling.
OR
Possession of a master's degree in computer science or computer/information technology; and three (3) years of the above-mentioned professional experience, two (2) years of which shall have been primarily in logical data modeling.
OR
Possession of a bachelor's degree in computer or computer/information technology plus a master's degree in computer science or computer/information technology; and two (2) years of professional experience which shall have been primarily in logical data modeling.
OR
Possession of an associate's degree in computer science or computer/information technology; and six (6) years of the above-mentioned professional experience, two (2) years of which shall have been primarily in logical data modeling.
NOTE: "Professional experience" refers to work that is creative, analytical, evaluative, and interpretive; requires a range and depth of specialized knowledge of the profession's principles, concepts, theories, and practices; and is performed with the authority to act according to one's own judgment and make accurate and informed decisions.
LICENSE:
Appointees will be required to possess a driver's license valid in New Jersey only if the operation of a vehicle, rather than employee mobility, is necessary to perform the essential duties of the position.
KNOWLEDGE AND ABILITIES
Knowledge of the differences between logical (conceptual) data modeling  and physical database design, and the purpose and proper application of  logical data modeling in an enterprise.
Knowledge of the rules of data normalization, the various normal forms  of data, and the purpose of generalization and sub-typing in logical data  modeling.
Knowledge of information technology and familiarity with information design  patterns, technology practices, policies, and procedures.
Knowledge of and ability to use various Data Modeling, Data Management,  and general productivity tools and technologies.
Knowledge of techniques used to evaluate and analyze the capabilities of  existing and proposed Data Management solutions.
Knowledge of multiple modeling techniques, such as Entity-Relationship,  Object-Relational, and Dimensional modeling, and different modeling  perspectives such as Conceptual, Logical, and Physical.
Ability to analyze operational business processes and determine critical  data needs, translate these needs into the logical normalized data model,  and determine/resolve the data/process  gaps necessary to ensure both  system process and data flow.
Ability to produce fully normalized and fully attributed logical business  and data models independent of a physical database design or technology,  and to capture all known business rules, including relationships and domain  constraints.
Ability to supervise subordinates and lead Data Management projects, including coordinating activities with other information technology staff  in the development of complex Data Management solutions.
Ability to communicate effectively between subject matter experts and  developers to ensure accurate translation of business needs to  implementation initiatives. 
Ability to identify and communicate risks to project timetables, deliverables,  or scope.
Ability to analyze problem conditions affecting data quality or the performance  of Data Management solutions, and then arrive at realistic solutions.
Ability to prepare clear, sound, and accurate documentation of business  rules and source-to-target mapping necessary to share with developers and  business units for Data Management initiatives.
Ability to prepare clear, accurate, and informative reports and documentation  on Data Modeling and Data Management matters.
Ability to give assignments to employees and supervise their performance.
Ability to give clear and complete oral and written directions and explanations.
Ability to supervise the maintenance of essential records and files.
Ability to read, write, speak, understand, and communicate in English  sufficiently to perform the duties of this position.  American Sign Language  or Braille may also be considered as acceptable forms of communication.
Persons with mental or physical disabilities are eligible as long as they  can perform essential functions of the job with or without reasonable  accommodation.  If the accommodation cannot be made because it  would cause the employer undue hardship, such persons may not be  eligible.