Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Architect/ OLTP Data Modeler

SonSoft Inc

Data Architect/ OLTP Data Modeler

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.

Job Description

Essential Job Functions: Determines business information needs and identifies systems requirement. Responsible for creating the Entity relationship 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. Experience with datamodeling within healthcare insurance is preferred.

Qualifications

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.
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Data Architect/ OLTP Data Modeler in Hoboken, NJ vacancy
  • A growing tech company in Hoboken, NJ is seeking a skilled Data Architect with over 8 years of experience in data design and modeling. The role involves determining business needs, creating diagrams, and managing projects within a dynamic team. Solid experience in relational... 
    Suggested
    Full time

    Sonsoft Inc

    Hoboken, NJ
    3 days ago
  •  ...Request ID: 68774-1 Title: Data Architect Locations: Jersey City NJ Duration: 6 Months...  ...& Integration Architect to lead data model design and downstream integration...  ...architecture and system integration within OLTP / transactional domains (insurance, banking... 
    Suggested

    Artech

    Jersey City, NJ
    2 days ago
  •  ...Job Summary ********************* Job Description -Design, maintain, and improve data architecture, including data models, structures, and standards -Develop and manage data pipelines, ETL/ELT processes, and data integration workflows... 
    Suggested

    CESNA GROUP INC

    New York, NY
    2 days ago
  •  ...Data Warehouse Developer - (Position B) Preferred Qualifications While not required, OSC will...  ...for the PARIS application; • performing database modeling in the context of an online transaction processing ("OLTP") system; • performing database modeling in the... 
    Suggested

    Compu-Vision Consulting

    New York, NY
    4 days ago
  • A leading technology firm in New York seeks an experienced Technical Architect/Data Engineer to design and implement large-scale data solutions focusing on data quality and governance. The ideal candidate will possess over 15 years of software engineering experience, with... 
    Suggested

    Quantum Technologies. LLC

    New York, NY
    3 days ago
  •  ...help design their future state AI enabled Data Architecture. Day to day: 1. End-to-...  ...: Establish a consistent data onboarding model with measurable SLAs for speed, quality,...  ...Databricks and AWS, with the ability to architect and execute within already-selected strategic... 
    Contract work
    Immediate start

    Insight Global

    New York, NY
    3 days ago
  •  ...Job Description: As a Data Architect, you will provide technical leadership, data architecture, and data analysis for key projects by leveraging...  ...teams to deliver detailed data architecture, domain data models, and discovery documents that will feed the Data Engineering teams... 

    TechDigital Group

    New York, NY
    2 days ago
  • $165k

     ...Responsibilities Establish and maintain enterprise data warehouse (EDW) architecture...  ...integration development frameworks, including architecting elegant technical solutions that meet...  ...enforce data standards, canonical data models, and integration patterns aligned to... 

    MAXIMUS

    New York, NY
    2 days ago
  •  ...Robots & Pencils, we harness the power of data to help our clients achieve meaningful...  ...transformation. We’re seeking a Senior Data Architect/Strategist who blends advanced data...  ...seamlessly between developing predictive models and translating complex data into clear,... 

    Robots and Pencils

    New York, NY
    2 days ago
  • $80k - $100k

     ...Data Architect New York, New York, United States About the Job Industry: Financial Services - Commercial Banking Job Category:...  ...Consultant- Data Architect Location: New York, NY (Hybrid Model) Role Full-time (Looking for only local candidates) Responsibilities... 
    Full time
    Local area
    Relocation package

    Staffworthy

    New York, NY
    3 days ago
  • $85 - $90 per hour

     ...Data Architect (Actimize aware data domain) Location: NYC, Midtown Manhattan (5 days onsite). Visa: Independent - first preference...  ...Ensure proper mapping to: Actimize Canonical Data Model (CDM) Real-Time & Big Data Processing Architect streaming... 
    Fixed term contract
    Immediate start

    Diverse Lynx

    New York, NY
    1 day ago
  •  ...Data Architect Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow...  ...across all relevant systems, including existing data model designs, data integrations, and data flow Validate and document... 
    Flexible hours

    Barrow Wise Consulting, LLC

    New York, NY
    3 days ago
  •  ....S. are encouraged to apply. Tax Terms: W2, 1099 Corp-Corp or 3rd Parties: Yes Education: Bachelor's Degree Skills: On Data Architect role – python is not mandatory. Look for someone strong in: Writing complex oracle PL/SQL queries Performance tuning of... 

    Keylent Inc

    New York, NY
    1 day ago
  •  ...Majesco Migration-Data Architect- Choosing Capgemini means choosing a company where you will be empowered to shape your career in the...  ...Architect with strong expertise in enterprise data architecture data modeling and integration within the insurance domain. Experience... 
    Permanent employment
    Full time
    Contract work
    Local area
    Flexible hours

    Capgemini

    New York, NY
    1 day ago
  •  ...Data Architect We are seeking an experienced Data Architect to lead the design and implementation of our enterprise data architecture...  ...Design and implement scalable data architecture, pipelines, and modeling strategies that power our enterprise data warehouse on GCP (... 
    Full time
    Part time
    Summer work
    Casual work
    Immediate start

    American Eagle Outfitters

    New York, NY
    6 days ago
  • $85k - $130k

     ...information, please visit VISION Finalsite will transform the way school communities engage with their schools. Summary Of The Role The Data Architect will play a crucial role in managing an enterprise data lakehouse and a team of data professionals, driving the design and... 
    Permanent employment
    Remote work
    Worldwide

    Finalsite

    New York, NY
    2 days ago
  • $110k - $120k

     ...Data Architect Join to apply for the Data Architect role at Feed the Children . At Feed the Children, we recognize the value of outstanding...  ..., Purview, SQL, Python, Spark, DAX, ETL/ELT processes, data modeling, Copilot, Git, and CI/CD practices. Familiarity with data... 
    For contractors
    Work at office
    Remote work

    Feed The Children

    New York, NY
    2 days ago
  •  ...ERWIN data architect : Onsite 5 days a week in NYC NY or Boston MA Duration : 6 months - 12 months Deep Knowledge of data modeling/data architecture Understanding of ML Ops and how it leverages data Experience implementing a data architecture... 

    Suncap Technology

    New York, NY
    5 days ago
  • $64k - $225k

     ...team of engineers, ensuring best practices and high performance. Collaborate with stakeholders to define and implement scalable data solutions. Ensure data integrity, security, and performance optimization. Stay updated on industry trends and emerging tech to... 
    Full time

    Photon

    Jersey City, NJ
    1 day ago
  • $138k - $210k

     ...GTM Data Architect Austin | Chicago | New York City | Salt Lake City | San Francisco Gong harnesses the power of AI to transform how...  ...rules align to segmentation, territories, verticals, and coverage models. Partner closely with Marketing Ops, Field Ops and GTM... 
    Remote work
    Work from home
    Flexible hours

    Gong.io

    New York, NY
    1 day ago
  •  ...A boutique data management consultancy is seeking an experienced data architect and data modeler to steer data architecture efforts for clients. The role emphasizes strong competencies in data warehousing, data modeling, and engagements with stakeholders, along with a... 
    Remote work
    Home office

    Global Data Strategy, Ltd

    New York, NY
    2 days ago
  •  ...Data & Integration Architect Location: New York, NY (Hybrid – 3 days onsite) or Alpharetta, GA Type: Contract US Citizens, GC visa holders preferred...  ..., Cloud platforms (AWS, Azure, GCP), Enterprise data modeling, ETL/ELT, and real-time data pipelines, Data governance,... 
    Contract work

    Staffing the Universe

    New York, NY
    1 day ago
  •  ...Job Title: MDM Big Data Architect Location: New Jersey; Remote Duration: 6+ Months Contract Please review the entire JD and send...  ...appropriate vision to meet the needs. • Knowledge in LifeScience data models: IDMP, HCP/HCO, CDISC(BRIDG) as well as GxP rules are required... 
    Contract work
    Remote work

    Navtech

    Jersey City, NJ
    1 day ago
  •  ...Data Modeler / Informaitional Architect Head count: 1 at Jersey City (Primary) Jersey City NJ - 07310, Columbus office (Secondary) - Columbus OH 43240 Start date: October 15, 2025 Job Responsibilities Executes data architecture solutions and technical troubleshooting... 
    Work at office

    E-Solutions

    Jersey City, NJ
    2 days ago
  •  ...Data Architect 12+ years of relevant experience in Data Management, Big Data (Hadoop, Scala, Spark, Hive), ETL – Talend, AWS Technical expertise in financial services industry and/or regulatory environments Excellent knowledge and experience on solutioning cloud... 

    Omni Inclusive

    Jersey City, NJ
    2 days ago
  •  ...Data Masking Architect 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... 
    Full time
    H1b

    SonSoft

    New York, NY
    1 day ago
  •  ...Data Architect Join our innovative team and play a pivotal role in designing and maintaining scalable, high-performance data architectures...  ...multi-cluster warehouse configurations Expertise in data modeling techniques (dimensional, normalized, data vault) and metadata... 
    Local area

    Artech

    Jersey City, NJ
    1 day ago
  • $70 per hour

     ...Snowflake Data Architect at The Ash Group W2 Contract Only – No C2C – No 3rd Parties Summary The Ash Group is hiring an experienced Snowflake...  ...and adhering to medallion-layer principles and scalable data modeling standards. Drive significant cost optimization efforts by... 
    Hourly pay
    Contract work
    Immediate start
    Remote work

    The Ash Group, Inc.

    New York, NY
    2 days ago
  • $135k - $140k

     ...experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate...  ...best at Ascendion. About the Role: Job Title : Snowflake Data Architect Job Description: Responsibilities: 15+ years’ experience in data... 
    Full time
    Temporary work
    Part time
    Remote work

    Ascendion

    New York, NY
    2 days ago
  • $70 per hour

     ...Role Name: Strong Data Architect Location: New York / Hybrid / FACE TO FACE INTERVIEW IS MANDATORY Start date: 2026-05-08 Rate: $7...  ...Snowflakebased data platforms including logicalphysical data models ingestion patterns batch streaming Snowpipe storage layers raw... 

    Scout Exchange

    New York, NY
    2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Architect/ OLTP Data Modeler. Be the first to apply!