Data Modeler Analyst

Sonsoft Inc; New Jersey; On-site; USD 80,000 - 100,000; Full time

Job summary

A growing tech firm in New Jersey is looking for a Data Modeler to interact with stakeholders, develop data models, and ensure data quality. The ideal candidate should have at least 4 years of IT experience, a bachelor's degree, and experience with data modeling tools. Strong skills in databases like Teradata and Oracle are required. This is a full-time position for U.S. citizens and Green Card holders only.

Qualifications

• At least 4 years of experience in the IT industry.
• At least 2 years of experience with DW/BI and related tools.
• Understanding of Data Modeling architectural principles.

Responsibilities

• Interact with stakeholders to understand requirements.
• Validate data models for accuracy and completeness.
• Develop and maintain all documentation for data models.

Skills

Data Modeling

Communication

Data Quality

Team Collaboration

Education

Bachelor’s degree or foreign equivalent

Tools

Teradata

Netezza

Oracle

Erwin

Job description

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

• Person needs to Interacting with Project stake holders to understand functional as well as technical requirements and documenting, publishing to Team.
• Experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating, publishing, maintaining PHYSICAL data models
• Evaluate existing data models and physical databases for variances and discrepancies
• Experience with managing meta data for data models
• To develop, publish, maintain all documentation for data models
• Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.
• Take part Data Quality, Data governance processes .
• Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models.
• Validate business use cases for accuracy and completeness of proposed data models.
• Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels.

Qualifications

Basic

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education
• At least 4 years of experience in IT industry.
• At least 2 years of experience with DW/BI and related tools
• At least 3 years of experience with Data Modeling related tools
• Understanding of Data Modeling architectural principles

Mandatory Technical Skills

• Have strong experience in databases like Teradata, Netezza or Oracle
• Good Experience in Unix Environment
• Good experience in Industry standard data modelling tools like Erwin.
• Experience in Performance tuning in DW environment.
• Experience in Datware house/Data Mart EDW Models.
• Experience on data modeling using Dimensional as well as ER-Model
• Have working Knowledge of Industry Standard Reporting/ETL tools.

Preferred/Good to have

• Worked in both OLTP and DW implementation
• Have good understanding of the new technologies i.e. No SQL, Open source Technologies, Columnar databases.

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 Full Time job opportunity.
• Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN VIsa can apply.
• No OPT-EAD and H1B for this position.
• Please mention your email id in your email or resume.