Previous Job
Data Modeler
Ref No.: 18-04050
Location: Hoboken, New Jersey
Timesheet Submission Frequency:Weekly
Invoice submission frequency:Monthly
Timesheet Instructions for Consultants:Time/Expenses are to be entered on Kaygen s JobDiva Portal

The data modeler will be part of the FIS BI team, working on primarily revenue and billing projects but contributing to other reporting projects as needed. The candidate must have prior knowledge of billing systems and models within a data warehousing environment. The position requires working with business analysts, ETL developers, and OBIEE developers to document and update data models for enhancements of existing subject areas, as well as design and development of new subject areas and models. The candidate must be able to quickly pick up existing technical and business domain knowledge. The position will require working with project teams to analyze requirements, design, and development data models, and review with data architect to ensure conformance to internal standards.
Required Experience
  • 8 years of relevant data modeling experience
  • 8 years of experience with Oracle 11g, 12c. MS SQL Server experience is a plus.
  • 8 years of experience in data warehouse environment on financial services projects
  • 5 years of experience with Erwin Data Modeler (Release 9.X) and Oracle SQL Developer Data Modeler
  • 5 years of experience with Oracle EBS R12
  • Bachelor's degree in Computer Science, Information Systems, or related field
  • Experience with conversion of legacy models to enterprise models
  • Development of, documentation, and adherence to modeling standards
  • Working directly with end users, business analysts, and development to team to provide modeling solutions for new and existing projects
  • In depth knowledge of Kimball Design methodology
  • Strong working knowledge of PL/SQL
  • Functional knowledge of revenue and billing systems
Preferred Experience
  • Familiarity with Informatica PowerCenter 9.5, 10.2
  • Familiarity with OBIEE 12c
  • Agile Development Methodology

At KAYGEN, we are always looking for dynamic, talented and experienced individuals. We invite you to join our team of talented IT professionals, consulting at client locations across the globe. Our culture is team-orientated; we strive to stand by our core values of respect, honesty and integrity. Our team of experienced staffing experts will work with you to find you the best opportunity. For more information please visit us at