Data Arch-Deerfield-3312 in Deerfield, IL at APEX Systems

Date Posted: 5/7/2018

Job Snapshot

  • Employee Type:
  • Location:
    Deerfield, IL
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

Job #:  828692

Site: Deerfield (ILBT11)

Business Unit: Global Information Technology - Global Commercial IT (118-158)

Description: Job Description:

Data Architect Responsibilities

* Understand and translate business needs into data models supporting long-term solutions.

* Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.

* Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.

* Optimize and update logical and physical data models to support new and existing projects.

* Maintain conceptual, logical and physical data models along with corresponding metadata.

* Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.

* Recommend opportunities for reuse of data models in new environments.

* Perform reverse engineering of physical data models from databases and SQL scripts.

* Evaluate data models and physical databases for variances and discrepancies.

* Validate business data objects for accuracy and completeness.

* Analyze data-related system integration challenges and propose appropriate solutions. * Develop data models according to company standards.

* Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.

Knowledge, Skills, and Abilities

* Proactively engage with the project stake-holders and understand requirements

* Good communication skills and ability to lead JAD sessions and discussions with business and actively participate in data mapping exercise

* String modeling experience - particular focus will be on physical modeling capabilities

* Good exposure and/or past experience in ETL and/or massively parallel database.

* data solutions attach and provide design solutions that will perform with Datastage ETL and Oracle databases.

* Hands on data analysis skills to understand the data

* Five or more years of experience in data modeling and design, coupled with strong knowledge of the software development life cycle.

* Five or more years of enterprise level data design and development involving dimensional modeling.

* Hands on experience with modeling tool such as (but not limited to) ERWIN, PowerDesigner

* Past experience with ETL technology

* Working knowledge of BI tools (Business Objects, Microstrategy, Cognos, Tableau)

Total Hours: 528.00