Data Architecture

» Data Architecture
Information Technology
in Orlando
, FL
Reference: 19-03669

Main Duties & Responsibilities:

  • Provide subject matter expertise with data exchange challenges with Cloud SaaS/PaaS providers
  • Analyze data sources (including data profiling), requirements and business rules, and perform logical data modeling mapping and gap analysis
  • Assume the role of subject matter expert (SME) on emerging data related technologies
  • Develop logical data models, metadata definitions and models
  • Ensure development and maintenance of robust data architecture documentation using ER/Studio and ER/Business Architect
  • Design and develop solutions that identify data issues and report errors for further analysis
  • Collaborate with other data architects for data model management, version control, and potential system interactions
  • Partner with data architects to instill industry best practices and generally accepted procedures across the enterprise
  • Provide guidance on steering existing data dependencies into future API based interaction solutions
  • Analyze system architectures and their relationships to database needs
  • Collaborate with application teams to create source to target mapping documents
  • Collaborate with application and services teams to design databases and interfaces which fully meet business and technical requirements
  • Research, collect and document current state data architecture, data dependencies, and processes
  • Specify the approach(es) that will be used to address data migration requirements
  • Develop and document a plan to evolve current data architecture to an improved future state data architecture which meets established, developing, and anticipated needs
  • Establish standards, policy, and processes for data architecture use concerning transport methods, platforms, monitoring standards, recovery requirements, data privacy, encryption, security and overall effectiveness/efficiency particularly with respect to cloud dependencies.19)
  • Provide consultation on future data architecture strategies

Qualifications:

  • Experience working with cloud to on-premise data dependencies
  • Demonstrated ability to handle multiple priorities and stakeholders
  • Working experience with SalesForce.com is desired
  • Experience in reverse engineering of existing source system data structures
  • Experience in conducting data model reviews with project team members
  • Experience in providing API based data access solutions around “eventual consistency ” concepts
  • Experience designing data model solutions for various transactional and/or analytical databases
  • Strong data analysis skills
  • Experience with data modeling tools, such as ER Studio
  • Expert understanding of RDBMS and ETL concepts
  • Experience in application software development methodologies, techniques, processes and tools