Data Modeler Architect

Sonsoft Inc; Livingston (NJ); On-site; Full time

Job summary

A growing technology firm in Livingston, New Jersey is seeking an experienced Data Modeler to interact with stakeholders, develop and maintain logical data models, and manage metadata. The ideal candidate will have at least 7 years in the IT industry, with 5 years focused on DW/BI tools and 3 years on Data Modeling tools. Responsibilities include validating business use cases and ensuring standard practices in data management. This is a full-time position requiring U.S. citizenship or work authorization.

Qualifications

• 7+ years in IT industry required.
• 5+ years in DW/BI and related tools.
• 3+ years with Data Modeling tools.

Responsibilities

• Interact with stakeholders to document functional and technical requirements.
• Develop and maintain logical data models.
• Evaluate existing data models and physical databases for discrepancies.
• Manage metadata for data models.

Skills

Data Modeling

Teradata

Netezza

Oracle

Unix Environment

Erwin

Performance Tuning

OLTP Implementation

Education

Bachelor’s degree in a related field

Tools

Industry standard reporting/ETL tools

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 7 years of experience in IT industry.
• At least 5 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 for you.
• Only US Citizen, Green Card, EAD-GC, H4-EAD, L2-EAD, TN Visa can apply.
• Please do mention your current US Visa Status in your resume to submit your resume soon.