Data Modeler Consultant

Posted 12 Days Ago
Be an Early Applicant
Charlotte, NC, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, validate, publish, and maintain logical and physical data models for DW/BI systems; evaluate existing models, manage metadata, enforce naming standards, collaborate with BAs, architects, developers and DBAs, and support data quality and governance processes.
Summary Generated by Built In
Company Description

SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

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 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.
• Ability to work in team in diverse/ multiple stakeholder environment.
• Analytical skills.
• Experience and desire to work in a Global delivery environment.
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
The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face. Travel may be required as per the job requirements.

Qualifications

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 4 years of experience with DW/BI and related tools
• At least 2 years of experience with Data Modeling related tools
• Understanding of Data Modeling architectural principles

Additional Information

** U.S. citizens and those who are authorized to work independently in the United States are encourage to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Full Time & Permanent job opportunity.
  2. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD can apply.
  3. H1B Visa Transfer can also apply for this position.
  4. No OPT-EAD and TN Visa candidates please.
  5. Please mention your Immigration Status while applying .
  6. All your information will be kept confidential according to EEO guidelines.

Skills Required

  • Strong experience with Teradata, Netezza or Oracle
  • Experience in Unix environment
  • Experience with industry-standard data modeling tools like Erwin
  • Experience in performance tuning in a data warehouse environment
  • Experience in data modeling using Dimensional and ER models
  • Working knowledge of industry-standard reporting and ETL tools
  • Bachelor's degree or equivalent (or 3 years progressive experience per year of education)
  • At least 4 years of experience in IT industry
  • At least 4 years of experience with DW/BI and related tools
  • At least 2 years of experience with data modeling related tools
  • Understanding of data modeling architectural principles
  • Experience in OLTP and DW implementation
  • Familiarity with NoSQL, open source technologies, and columnar databases
  • Experience/desire to work in a global delivery environment
  • Ability to work in diverse teams and strong analytical skills
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

Babylist Logo Babylist

Editor

eCommerce • Healthtech • Kids + Family • Retail • Social Media
Easy Apply
Remote or Hybrid
United States
300 Employees
120K-144K Annually

PwC Logo PwC

Supply Chain Consulting - Warehouse Automation Sr. Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
29 Locations
370000 Employees
124K-280K Annually
In-Office
New London, NC, USA
10000 Employees
42K-48K Annually

CrowdStrike Logo CrowdStrike

Sr. Mgr, Operational & Productivity Strategy and Assessment

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
10000 Employees
130K-200K 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