Data Modeler Architect

Reposted 19 Days Ago
Be an Early Applicant
Livingston, NJ, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, validate, publish, and maintain logical (and physical) data models for DW/BI. Collaborate with BAs, architects, developers, and DBAs; manage metadata, documentation, naming standards, data governance and quality; validate business use cases and communicate architecture to stakeholders.
Summary Generated by Built In
Company 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:-

  1. This is a Full time job opportunity for you.
  2. Only US Citizen, Green Card, EAD-GC, H4-EAD, L2-EAD, TN Visa can apply.
  3. Please do mention your current US Visa Status in your resume to submit your resume soon.

Skills Required

  • Bachelor's degree or foreign equivalent (or three years progressive experience in lieu of each 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
  • Experience developing, validating, publishing, and maintaining logical data models (and exposure to physical data models)
  • Experience evaluating existing data models and physical databases for variances and discrepancies
  • Experience managing metadata for data models
  • Experience documenting and publishing data model documentation
  • Experience working with Business Analysts, Data Architects, Software developers, DBAs
  • Participation in data quality and data governance processes
  • Enforce standards for data naming conventions and ensure consistency/reuse
  • Validate business use cases for accuracy and completeness of proposed data models
  • Ability to communicate data modeling strategies and architecture to cross-functional groups and senior levels
  • Strong experience with databases such as Teradata, Netezza, or Oracle
  • Good experience in Unix environment
  • Experience with industry-standard data modeling tools such as Erwin
  • Experience in performance tuning in DW environments
  • Experience in Data Warehouse/Data Mart/EDW models
  • Experience doing data modeling using Dimensional and ER models
  • Working knowledge of industry standard reporting and ETL tools
  • Worked in both OLTP and DW implementation
  • Understanding of NoSQL, open source technologies, and columnar databases
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

Data Architect

Information Technology • Professional Services • Software • Consulting
In-Office
Hoboken, NJ, USA
87 Employees

Atria Group LLC Logo Atria Group LLC

Architect

Information Technology • Professional Services • Software • Consulting
In-Office
Princeton, NJ, USA
125 Employees

CrowdStrike Logo CrowdStrike

Sales Engineer

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
2 Locations
11000 Employees
75K-115K Annually

CrowdStrike Logo CrowdStrike

Senior Machine Learning Engineer

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
140K-215K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account