Data Architect/ OLTP Data Modeler
- Location
- Hoboken, NJ
- Work authorization
- US citizens or permanent residents only
- Job type
- Full-time
- Level
- Executive
- Experience
- 8+ years
- Listed
- Yesterday
Skills & highlights for this role
- ERwin
- entity relationship diagrams
- star schema
- dimensional modeling
Also useful
- Netezza
- Oracle
- SQL Server
- Db2
How well does your resume fit this job?
Upload your resume to see your score for this Sonsoft role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
Determines business information needs and identifies systems requirement
- Responsible for creating the Entity releationship diagrams, star schema and dimensional models
- Ensure Data integrity by analyzing, testing, validating and certifying data system tables that are consistent with business requirement and technical specification document
Key Responsibility
- Manage complex internal and external projects, handling tasks and deadlines, plans and prioritizes service request and assignments
- Designs and documents database structures for the data warehouse
- Confers with end user to gain understanding of needed changes or modifications of existing programs. Resolves questions of program intent, data input.
- Experience with Netezza in support of the data warehouse modeling is preferred.
Qualification
- 8+ years of experience in data design, data architecture and data modelling (both transactional and data analytic)
- 8+ years of experience in relational and dimensional data design and modelling in a large multi-platform data environment
- Experience with Oracle/Sql server/Db2 in support of transactional systems modelling is preferred
- Experience with Erwin/any other data modelling tool is must
- Must have good written and verbal communication skills and have experience of interfacing directly with program development, user and management personnel.
Additional Information
- U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note
- This is a Fulltime job for you
- Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
About the Company
Sonsoft, Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
From Sonsoft's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Data Architect/ OLTP Data Modeler role at Sonsoft, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
- Data ModellerSTEM Expert · Reston, VA
- Data ModelerKRG Technologies · Hudson, NY
- US - IT - Data Modeler IIIProcom · Mount Laurel, NJ
- Urgent Need Data ModelerUSM Business Systems · Dayton, OH
- Sr. Data Modeler/LeadUSM Business Systems · Reston, VA
- Lead Data Modeler----------------Need Full GC and USC--------Need LocalsUSM Business Systems · Reston, VA
More at Sonsoft
All Sonsoft jobsCommon questions
Where is the Data Architect/ OLTP Data Modeler job at Sonsoft located?
This Data Architect/ OLTP Data Modeler position at Sonsoft is located in Hoboken, NJ. Always check Sonsoft's application page for specific state eligibility or relocation policies.
What qualifications are required for Data Architect/ OLTP Data Modeler at Sonsoft?
For the Data Architect/ OLTP Data Modeler role, Sonsoft highlights 8+ years of relevant experience; experience with ERwin, entity relationship diagrams, star schema, dimensional modeling. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Data Architect/ OLTP Data Modeler position at Sonsoft?
This listing links directly to Sonsoft's SmartRecruiters application page. You can apply directly on Sonsoft's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.