Previous Job
Senior Data Modeler
Ref No.: 18-07244
Location: New York, New York
Position Type:Contract
Start Date / End Date: 09/18/2018 to 09/18/2019
 Genesis10 is currently seeking a with our client in the financial industry in their New York, NY location. This is a 12 month + contract position.

Seeking a Senior Data Modeler 

  • Spend Management Technology supports the Re-Engineering and Expense Mgmt businesses which are responsible for the Firm's sourcing, contracts, procurement, invoicing, and accounts and third part risk functions
  • The goal of Spend Mgmt Technology team is to provide an effective and integrated end-to-end solution for the Source to Pay process and to enable transparency into the Firm's spend on goods and services in order to identify opportunities for saving and cost reduction
  • The Senior Data Modeler is responsible for Logical and Physical Modeling in Power Designer/Erwin for a highly scalable data warehouse
  • Understand the dimensional/relational modeling techniques and bridge the gap between the OLTP developers, data warehouse developers and DBA teams
  • Translates and transforms business requirements into data models (Conceptual, Logical and Physical) 
  • Analyze source system data using profiling tools
  • Capability to design models for OLTP and Dimensional modelling 
  • Interacts with OLTP systems and translate relational models into dimensional models
  • Maintains Data Model repository
  • Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance
  • Executes and provides feedback for data modeling policies, procedure, processes and standards
  • Evaluates Database and data and develop the data model appropriately 
  • Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems 
  • Design data models in Data Modeling in Power Designer 
  • 10+ years of data modeling experience
  • Database experience in DB2 preferred 
  • Power Designer is a must 
  • Ability to develop stored procedures and SQL scripts as required 
  • Any Informatica skills a plus 
  • Experience with unit testing, release procedures, coding design and documentation protocol; 
  • Knowledge of IT fields and computer systems; 
  • Understanding of the systems development life cycle
  • Ability to manage tasks independently. 
  • Knowledge of basic Agile terminology and practices such as User Stories, Backlog, Scrum, and Acceptance Criteria
  • Experience with an Agile Tool, specifically JIRA is a plus 
  • Previous Brokerage experience a Plus
  • Excellent written and oral communication skills for managing interactions both within the team and without
  • Very strong attention to detail and organizational skills
  • Strong work ethic
  • Able to work as a W2 employee of Genesis10 (no Corp-to-Corp)
If you have the described qualifications and are interested in this exciting opportunity, please apply!

About Genesis10:

Genesis10 is a leading U.S. business and technology consulting firm with hundreds of clients needing proven talent and solutions to power their strategic initiatives.  If you are a high performing business or IT professional with solid, referenced experience, we want to meet you.  Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience and aspirations.  We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement – project after project.   To learn more about Genesis10 and to view all our available career opportunities, please visit us at  "Genesis10 is an Equal Opportunity Employer, M/F/D/V”