Overview
On Site
Hybrid
USD 70.00 per hour
Full Time
Skills
Recruiting
Big Data
Microsoft SQL Server
Data Profiling
Relational Databases
Database Performance Tuning
Cloud Computing
Data Modeling
Snow Flake Schema
Data Lake
Modeling
Amazon Web Services
Amazon Redshift
Amazon S3
Amazon DynamoDB
PostgreSQL
Analytical Skill
Stored Procedures
Data Warehouse
Data Marts
Unstructured Data
Analytics
Application Development
Pega
Data Flow
Data Quality
Reverse Engineering
IBM DB2
SQL
Scripting
Database
System Integration
Business Intelligence
Interfaces
Job Details
Date Posted: 11/03/2025
Hiring Organization: Rose International
Position Number: 490872
Industry: Government/Staffing
Job Title: Senior Data Modeler
Job Location: Trenton, NJ, USA, 08625
Work Model: Hybrid
Work Model Details: Onsite a few times per month
Shift: Regular Hours
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In Weeks): 2
Min Hourly Rate($): 70.00
Max Hourly Rate($): 85.00
Must Have Skills/Attributes: AWS, Big Data, Data Modeling, Design, PostgreSQL, SQL, SQL Server
Experience Desired: Data Modeling for Databases like DB2, AWS' Redshift, Dynamo DB, Postgres, SQL Server (8 yrs); Database tuning techniques (4 yrs); Snowflake's Cloud Data Warehouse (2 yrs)
Required Minimum Education: Bachelor's Degree
**C2C is not available**
Job Description
*** Only qualified Senior Data Modeler candidates currently located in the Trenton, NJ area will be considered due to the position requiring an onsite Presence***
Required Education:
4 years College Degree or equivalent technical study
Required Skills:
Experience in Data Modeling for Databases like DB2, AWS' Redshift, Dynamo DB, Postgres, SQL Server (8 Years)
Data modeling software (6 Years)
AWS and Other Cloud Systems (3 Years)
Strong SQL and data profiling skills in various relational databases (8 Years)
Analyzing source databases, source data, source database referential integrity, and profiling source data (8 Years)
Experience in building Data Lakes for both structured and unstructured data (2 Years)
Preferred Skills:
Database tuning techniques (4 Years)
Exposure to Snowflake's Cloud Data Warehouse
This Senior Data Modeler position is for designing and implementing modern data modeling solutions using relational, dimensional, snowflake, star, and data lake that meet client needs using conceptual, logical, and physical data models. The Senior Data Modeler should be capable of modelling for various databases like AWS Redshift, S3, DynamoDB, DB2, and PostgreSQL.
Job Duties:
Responsible for the design, development, and implementation of Data Warehouse database structures and Analytical Database structures
Work with Business groups and Application Teams during pre- & post-assessment periods
Write complex SQL's, write and execute Stored Procedures for the analysis of data
Understand the needs of the Business team and BI team for building a proper Data Warehouse and DataMart
Develop structured and unstructured data models for BI and Analytics
Understand and translate business needs into data models supporting long-term solutions for different client systems
Work with the Application Development teams (ex, Pega Applications) to implement data strategies, build data flows, and develop conceptual data models
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
Optimize and update logical and physical data models to support the Data Initiative project for different phases of implementation
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
Recommend opportunities for reuse of data models in a new environment
Perform reverse engineering of physical data models from databases like DB2 and SQL scripts
Evaluate data models and physical databases for variances and discrepancies across the different source systems
Analyze data-related system integration challenges and propose appropriate solutions, and develop the model according to the client's Standards
Work with all IT teams, like System Analysts, Engineers, Programmers, BI, and others, on project limitations and capabilities, performance requirements, and interfaces
Review modifications to existing software to improve efficiency and performance
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Hiring Organization: Rose International
Position Number: 490872
Industry: Government/Staffing
Job Title: Senior Data Modeler
Job Location: Trenton, NJ, USA, 08625
Work Model: Hybrid
Work Model Details: Onsite a few times per month
Shift: Regular Hours
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In Weeks): 2
Min Hourly Rate($): 70.00
Max Hourly Rate($): 85.00
Must Have Skills/Attributes: AWS, Big Data, Data Modeling, Design, PostgreSQL, SQL, SQL Server
Experience Desired: Data Modeling for Databases like DB2, AWS' Redshift, Dynamo DB, Postgres, SQL Server (8 yrs); Database tuning techniques (4 yrs); Snowflake's Cloud Data Warehouse (2 yrs)
Required Minimum Education: Bachelor's Degree
**C2C is not available**
Job Description
*** Only qualified Senior Data Modeler candidates currently located in the Trenton, NJ area will be considered due to the position requiring an onsite Presence***
Required Education:
4 years College Degree or equivalent technical study
Required Skills:
Experience in Data Modeling for Databases like DB2, AWS' Redshift, Dynamo DB, Postgres, SQL Server (8 Years)
Data modeling software (6 Years)
AWS and Other Cloud Systems (3 Years)
Strong SQL and data profiling skills in various relational databases (8 Years)
Analyzing source databases, source data, source database referential integrity, and profiling source data (8 Years)
Experience in building Data Lakes for both structured and unstructured data (2 Years)
Preferred Skills:
Database tuning techniques (4 Years)
Exposure to Snowflake's Cloud Data Warehouse
This Senior Data Modeler position is for designing and implementing modern data modeling solutions using relational, dimensional, snowflake, star, and data lake that meet client needs using conceptual, logical, and physical data models. The Senior Data Modeler should be capable of modelling for various databases like AWS Redshift, S3, DynamoDB, DB2, and PostgreSQL.
Job Duties:
Responsible for the design, development, and implementation of Data Warehouse database structures and Analytical Database structures
Work with Business groups and Application Teams during pre- & post-assessment periods
Write complex SQL's, write and execute Stored Procedures for the analysis of data
Understand the needs of the Business team and BI team for building a proper Data Warehouse and DataMart
Develop structured and unstructured data models for BI and Analytics
Understand and translate business needs into data models supporting long-term solutions for different client systems
Work with the Application Development teams (ex, Pega Applications) to implement data strategies, build data flows, and develop conceptual data models
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
Optimize and update logical and physical data models to support the Data Initiative project for different phases of implementation
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
Recommend opportunities for reuse of data models in a new environment
Perform reverse engineering of physical data models from databases like DB2 and SQL scripts
Evaluate data models and physical databases for variances and discrepancies across the different source systems
Analyze data-related system integration challenges and propose appropriate solutions, and develop the model according to the client's Standards
Work with all IT teams, like System Analysts, Engineers, Programmers, BI, and others, on project limitations and capabilities, performance requirements, and interfaces
Review modifications to existing software to improve efficiency and performance
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.