Data Modeler Architect

Posted Yesterday
Be an Early Applicant
Irvine, CA, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design, validate, publish and maintain logical and physical data models; evaluate existing models and metadata; collaborate with BAs, architects, developers and DBAs; enforce naming standards; support data governance and data quality; communicate modeling strategies 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 equivalent experience (or three years progressive experience in lieu of each year of education)
  • At least 7 years of experience in the IT industry
  • At least 5 years of experience with Data Warehouse / BI and related tools
  • At least 3 years of experience with data modeling tools
  • Understanding of data modeling architectural principles
  • Experience with Teradata, Netezza or Oracle databases
  • Experience in Unix environment
  • Experience with industry-standard data modeling tools such as Erwin
  • Experience in performance tuning in DW environment
  • Experience with data warehouse/data mart/EDW models
  • Data modeling using Dimensional and ER models
  • Working knowledge of industry-standard reporting and ETL tools
  • Experience working with business analysts, architects, developers and DBAs; strong communication skills
  • Experience in data governance and data quality processes
  • Authorization to work in the U.S. (US Citizen, Green Card, EAD, H4-EAD, L2-EAD, TN Visa)
  • Experience with OLTP implementations and familiarity with NoSQL, open source technologies, 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

USM Business Systems Logo USM Business Systems

Data Architect

Artificial Intelligence • Information Technology • Internet of Things • Software • Automation
In-Office
San Francisco, CA, USA
580 Employees

General Motors Logo General Motors

District Manager Parts and Service

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
81K-109K Annually

General Motors Logo General Motors

Senior Product Manager

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Hybrid
3 Locations
165000 Employees
107K-163K Annually

General Motors Logo General Motors

Analytics Report Developer

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Hybrid
3 Locations
165000 Employees
139K-207K 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
Fintech • Software
New York, New York
6 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