• Data Architect

    Job Locations US-District Of Columbia-Washington, DC
    # of Openings
    1
    Category
    Information Technology
    Agency/Project
    DOL
    Job ID
    2018-2793
  • Overview

    Performs data modeling (conceptual, logical and physical model design) or case management systems/databases and data warehouses. Performs database replication, migration, and design. Translates business data from structured and unstructured resources into a usable enterprise information architecture, which may include data models, metadata schema, controlled vocabularies, ontologies and taxonomies.

    Responsibilities

    • Conducts an analysis of case management related systems/applications and process analysis.
    • Assists with the design of the agency’s overall information architecture across multiple data types accounting for both structured and unstructured content balancing security, analytics, and performance requirements.
    • Oversees the flow of data model development including conceptual, logical and physical models.
    • Translates business data from wide variety of structured and unstructured resources into a usable enterprise information architecture, which may include data models, metadata schema, controlled vocabularies, ontologies and taxonomies.
    • Supports for the design of corresponding search engine for data retrieval.
    • Works with to perform source system analysis, identification of key data issues, and data profiling.
    • Provides a consultative approach with business users, asking questions to understand the business need and deriving the data flow, logical and physical data models based on those needs.

    Qualifications

    • Eight (8) years of experience with data modeling (conceptual, logical and physical model design) to include support for data warehouse environments.
    • Working knowledge of database replication, migration, and design
    • Experience in data analysis for case management systems/databases
    • Knowledge of tools for automated data extraction and cataloguing of unstructured content in a metadata schema
    • Experience using DAX and MDX code expressions for the creation of complex queries
    • Experience using MS SQL Server Reporting on Oracle Discoverer for custom reporting.
    • Experience with structured query language PostgreSQL/SQL Server 2008
    • Experience securing data
    • Understands how to communicate difficult/sensitive information tactfully.
    • Proven ability to meet cost, schedule, and performance requirements for projects.
    • Exceptional verbal and written communication skills and leadership skills

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed