Data Architect/OLTP Data Modeler
Listed on 2026-01-11
-
IT/Tech
Data Engineer, Data Analyst
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 DescriptionRequisition Details:
Essential Job functions:
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.
Experience with data modeling within healthcare insurance 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.
**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
.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).