Data Modeller Consultant

Reposted 20 Days Ago
Be an Early Applicant
Minneapolis, MN, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, validate, and maintain logical and physical data models for data warehousing. Collaborate with stakeholders, BAs, architects, DBAs and developers; enforce naming standards, manage metadata, support data governance and quality, and document models. Focus on performance tuning, DW concepts, and banking/financial domain requirements.
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

mandatory Technical Skills
• Have strong experience in databases like Teradata, Netezza or Oracle etc.
• Good Experience in Unix Environment
• Good experience in Industry standard data modelling tools like Erwin.
• Have good working knowledge of Data warehousing concepts. 3+ experience is required.
• 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.
• Having good PL SQL Skills
• Have good Banking and Financial Domain Knowledge is Must.
Preferred/Good to have
• Worked in both OLTP and DW implementation
• Experience on Ab Initio.
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
• Good hands on knowledge on Erwin knowledge is must require.

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

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 Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holder, TN Visa, GC-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.

Skills Required

  • Experience with Teradata, Netezza or Oracle databases
  • Experience in Unix environment
  • Experience with Erwin data modeling tool
  • Working knowledge of data warehousing concepts (3+ years)
  • Experience in performance tuning in a DW environment
  • Data modeling using Dimensional and ER models
  • Working knowledge of industry-standard reporting and ETL tools
  • PL/SQL skills
  • Banking and financial domain knowledge
  • Experience developing, validating, publishing, and maintaining logical and physical data models
  • Manage metadata for data models and maintain documentation
  • Bachelor's degree or equivalent (or progressive experience in lieu)
  • At least 2 years of experience with DW/BI and related tools
  • At least 1 year of experience with data modeling tools
  • Understanding of data modeling architectural principles
  • Experience with OLTP and DW implementations
  • Experience with Ab Initio
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.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
Minneapolis, MN, USA
87 Employees

Cloudflare Logo Cloudflare

Senior Customer Engineer - Nashville

Cloud • Information Technology • Security • Software • Cybersecurity
Remote or Hybrid
United States
4400 Employees

Samsara Logo Samsara

Artificial Intelligence Engineer

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
131K-176K Annually

Zeta Global Logo Zeta Global

Senior Product Manager

AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
Easy Apply
Remote or Hybrid
United States
2429 Employees
170K-190K 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