A.C. Coy

  • Sr. Data Modeler

    Job Locations US-PA-Pittsburgh
    Posted Date 1 month ago(5/23/2018 10:23 AM)
    Job ID
    # of Openings
    Information Technology
  • Overview

    Our client located in Pittsburgh, PA is hiring a Sr. Data Modeler. Our client is developing a new software package that will require the expertise of requires a Sr. Data Modeler during the creation and launch. The ideal candidate for this role will have a minimum of ten years of experience in the Information Technology industry.


    • Leads business information modeling and ensures that project information conforms to corporate information architecture standards in a SAS platform.
    • Collaborates with business clients, IT and Business Intelligence staff, and management to assess information and resource needs, identifies data sourcing, application, and maintenance, determines project impact, and ensures integration across projects.
    • Researches and evaluates alternative solutions and recommends the most efficient and cost-effective data management solutions.
    • Identifies researches and recommends new methods for supporting information management as it relates to data management.
    • Develops high-level database architectures and ensures that database designs are consistent with client’s information architecture and information management standards as well as industry standards.
    • Works with the Data Warehouse Architect to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas.


    • Eight to ten years of information technology experience including a minimum of seven years’ experience designing, deploying, and maintaining relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence.
    • Extensive experience integrating disparate systems into conformed dimensions
    • Strong hands-on ERwin data modeling tool experience
    • Experience with a range of relational database management systems (RDBMS) and RDBMS tuning
    • Minimum of three years deploying and supporting large, complex data warehouse/business intelligence solutions (full life cycle)
    • Five years of MS Azure experience
    • Preferred experience in manufacturing, financial services and retail industries


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