logo

View all jobs

Information Data/Architect

Columbia, SC · Information Technology
The Data Architect is responsible for the strategy, vision, and technical approach to managing the data across transactional, relational, and operational data stores.  The Data Architect will interact with Enterprise Architects and Solution Architects that are responsible for integrating data from trading partners across the Medicaid Enterprise into a data hub.  The data hub leverages NoSQL document and semantic stores that serves as the source of truth and integration platform that connects source and target systems for data exchange.  The Data Architect also needs to support tactical activities such as establishing a canonical model and mapping from source structures or target structures.
The Data Architect will be relied upon to:
  • Design databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and security as well as customer-defined deliverables
  • Collaborate with internal and external personnel, including solution architects, software developers, database administrators, design analysts and information modeling experts to determine project requirements and capabilities, and strategize development and implementation timelines
  • Develop architectural strategies for data modeling, design and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environments
  • Create and test physical data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
  • Support database administrators, network designers and IT personnel to create effective and secure methods for data backup and recovery
  • Review existing data architectures to determine overall effectiveness and compliance with original objectives, develop comprehensive strategies for improving or replacing under-performing areas and present these plans to managers and executives
  • Research new technologies, data modelling methods and information management systems to determine which ones should be incorporated into company data architectures, and develop implementation timelines and milestones
  • Perform data mapping between the canonical models and data formats (both input and output) such as X12 EDI, FHIR, and other structured JSON, XML, or proprietary formats.
  • Manage metadata models that drive data processing such as data quality routines and data mastering routines
  • Participate on Data Governance Council meetings, representing the architecture and development teams
Required Experience and Skills:
  • Bachelor’s degree in data architecture, information management or similar field; relevant experience acceptable in place of degree
  • 7+ Years of experience in Data Modeling (Conceptual, Logical and Physical). Must be able to design and explain using entities, attributes, hierarchies, inheritance, relationships and their associated meta data.
  • At least 3 years of data architecture experience
  • Proficient with relational databases
  • Proficient with NoSQL databases
  • Creative problem-solver with strong communication skills
  • Candidates should also have:
    • Data visualization experience
    • Data warehouse design and implementation experience, specifically related to the data models
    • Transactional data store data modelling design using relational and document data patterns
    • Master Data modelling techniques using relational and document data patterns
    • REST API data modeling experience
    • Data transformation experience
    • Domain Driven Design experience
Desirable Technologies:
  • JSON, XML schema definition
  • Python
  • Experience with MarkLogic, MongoDB, Hadoop, Redshift, or other big data platforms

Share This Job

Powered by