Go Back

Data Modeler

Cuyahoga, Ohio
10/15/19 15:50
0 Applications
Job Type:
Contract
Salary:
[n/a]
Start Date:
10/15/2019

CONTRACTOR REQUEST

 Data Modeler

 

Work Location:   Strongsville, OH, Cleveland, OH – with occasional travel between sites for meetings.

                    

 

Required:

  • Minimum of 5 years’ experience with Microsoft SQL Server, both as a developer and data modeler.
  • Minimum of 5 years’ experience with both transactional data modeling (OLTP) and analytical modeling (OLAP).
  • Minimum of 5 years’ experience with data modeling tools such as Toad Data Modeler, Er-WIN, ER Studio, etc.
  • Advanced understanding of relational database management systems and query semantics            
  • Desired:

  • Experience with Microsoft Team Foundation Server (TFS)
  • Experience with Hadoop (Hive or Apache Spark)
  • Exposure to Agile project methodologies
  •  

    Candidate Responsbilities

  • Participating in design meetings with other project team members
  • Creating, enhancing and validating the Product ODS Logical Data Model.
  • Creating, enhancing and validating the Product ODS Physical Data Model as originally created via the Logical Data Model.
  • Creating, enhancing and validating the SQL code used to create the Product ODS repository.
  •  

    Project detail

  • Product Operational Data Store (ODS) is a project designed to ingest  Benefits data (aka: Products) into the  ODS for downstream consumption by other systems.
  • Technologies include Microsoft SQL Server database, Toad Data Modeler, Microsoft SQL Server Integration Services (SSIS), Hadoop, and Visual Studio .Net.
  •  

     

     


    Contract to Hire:



    Email this job Save this job


    Login


    Email:
    Password:

    Forgotten password?