Senior Data Architect and Modeler

Gwynn Oak, MD
Dec 25, 2017
Feb 28, 2018
IT, IT Architect
Full Time
AboutWeb is looking for a Senior Data Architect and Modeler for the Baltimore, MD. The candidate supports the full range of IT integration services supporting a multi-platform computing environment, including: information systems modernization initiatives, software engineering, project management, infrastructure services, data warehousing, database administration, research, planning, security, federal enterprise architecture initiatives, and all levels of Internet, Intranet and Web portal initiatives and migrating legacy architecture to web-based platforms.
The Senior Data Architect/Modeler will support the development and hands on implementation of the Disability Case Processing System (DCPS) application using the latest open source server side java script technologies on the Node platform and other related open source products accessing a PostgreSQL database.
Specifically, the successful candidate will be a member of an Agile Database and Infrastructure Team working with other Agile development teams, System Architects, Test Architects, Database Engineers, Implementation team, and External System Owners to develop and maintain the DCPS data model and database.
Required Skills:
  • Experience analyzing database changes requested by the Agile development teams for impacts to interfacing systems, Naming Standards, Design standards, Data Conversions and update corresponding documentation.
  • Coordination and collaboration skills to work with teams to devise a data strategy that addresses Disability Case Processing requirements, translating business requirements into data designs, and maintain a data inventory.
  • Experience with ERwin Relational data modeling tools for logical and physical data models.
  • Ability to Identify and evaluate current data management technologies and research new opportunities for data acquisition and expand the vision for how data will flow through the distributed offices.
  • Experience developing data strategies, data models, databases in an Agile development process and ceremonies including scrums, planning events, backlog grooming, retrospectives and demos.
Desired Skills
  • Integrate technical functionality (e.g. scalability, security, performance, data recovery, reliability, etc.)
  • Ability to derive data designs and identifies opportunities to re-engineer data structures, and recommends efficiencies as it relates to data storage and retrieval
  • Constantly monitor, refine and report on the performance of data management systems
  • Experience with installation, development, maintenance and enhancement of physical PostgreSQL RDBMS to support the Agile development teams.
  • Experience with developing and maintaining OLTP, data warehouses and operational data stores and concepts.
  • Create SQL scripts for Conversion, Reports, Data Analysis and Data Corrections.
  • Knowledge of installation, maintenance and administration of Oracle, DB2 or other RDBMS.
  • Experience with Data Conversion and ETL Strategies on various databases (PostgreSQL, Oracle, DB2)
  • Experience with performance and tuning of applications on various databases (PostgreSQL, Oracle, DB2)
  • Experience with Dimensional Modeling for Business Information/OLAP systems.
  • Operating System and Infrastructure experience with RedHat Linux, Windows, Unix, etc.
  • Ability to meet deadlines, concentrate and to pay attention to detail.
  • Strong customer interface skills.
  • Good interpersonal and communication skills necessary to work effectively with customers and other team members.

Bachelor's degree from an accredited college in a related discipline or equivalent experience with 11 years of professional experience.


Similar jobs