Data Modeller Consultant

Reposted 21 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 using Erwin for data warehousing. Collaborate with stakeholders, BAs, architects, developers and DBAs; manage metadata, enforce naming standards, perform DW performance tuning, support data governance and data quality, and document models for banking/financial domain projects.
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
  • Experience in Unix environment
  • Hands-on experience with Erwin
  • Data warehousing concepts (3+ years)
  • Performance tuning in DW environment
  • Data modeling using dimensional and ER models
  • Working knowledge of industry standard reporting/ETL tools
  • PL/SQL skills
  • Banking and financial domain knowledge
  • Bachelor's degree or equivalent (or progressive experience in lieu)
  • At least 2 years' experience with DW/BI and related tools
  • At least 1 year experience with data modeling tools
  • Understanding of data modeling architectural principles
  • Stakeholder interaction, documentation and publishing deliverables
  • Metadata management for data models
  • Participation in data quality and data governance processes
  • Ability to communicate data modeling strategies to cross-functional and senior stakeholders
  • Worked in both OLTP and DW implementation
  • 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

PwC Logo PwC

US Tech - FTO Senior Associate

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
46 Locations
370000 Employees
151K-187K Annually

PwC Logo PwC

Executive Concierge

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
45 Locations
370000 Employees
109K-124K Annually

General Motors Logo General Motors

Sales Manager

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
124K-165K 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