Job Description - Remote Data Architect Job: in Rochester
Return to jobs

Remote Data Architect Job:

Ref: US_EN_6_916327_1423617

Posted on 18 January 2022
Job Location
Rochester, New York
Contract Type
Information Systems

Remote Data Architect Job:

Long term contract

Periodic travel to Rochester, NY will be necessary

The Data Architect will lead the standard of a common business vocabulary, expresses strategic data requirements, drives high-level data model / ontologies, design and integration patterns, align with enterprise strategy and related business architectures, all in support of operations and research business needs.

Required Skills of the Remote Data Architect:

  • Strong data warehouse experience in MSFT SQL Server and Integration Services.
  • Expert in data modeling and specifically dimensional modeling concepts and principles.
  • Demonstrated experience in leading data modeling requirements, design, development and unit / integrated testing in at least one large data warehousing initiative.
  • Demonstrated ability to iterate between logical and physical data models.
  • Experience in using standard data modeling tools and practices.
  • Strong experience in implementing DataMarts and ODSs (Operation Data Stores).
  • Experience in SQL Server performance tuning and optimization.
  • Strong experience in designing and implementing metadata management systems.
  • Well versed in implementing a data lake / unstructured data processing.
  • Strong experience in designing and implementing security / access models.
  • Strong experience in applying information management principles and concepts.
  • Excellent communication skills, both written and spoken are a must.
  • Demonstrated ability to collaborate with other architects and lead resources.
  • Scrum/agile experience.
  • Preferred Skills of the Data Architect:

  • CDM (Common Data Model) database and underlying data integration patterns
  • Experience implementing Denodo data virtualization at enterprise scale
  • Background in designing Virtual Data warehouse solutions, possible using the Denodo toolset.
  • Experience in both on-premise and cloud implementations a plus.
  • Strong experience in SQL Server environment sizing, installation, configuration required.
  • Version control tools
  • Clinical research or academic research environment experience
  • Experience in enterprise scheduler integration inside and outside of Microsoft platforms.
  • Experience in both full (batch) and incremental (trickle) ETL/ELT design patterns.
  • For more information or to be considered for the Data Architect role please contact Thomas McCarthy at

    Equal Opportunity Employer/Veterans/Disabled

    To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to

    The Company will consider qualified applicants with arrest and conviction records


    Find your local office.

    Modis has over 100 offices in the United States, Canada and Europe. With both industry and location-specific expertise, our people know their area and their labor market and can find the right position for you.