Lead Data Modeler

Wipro Limited
Woodbridge Township, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 158K

Job location

Woodbridge Township, United States of America

Tech stack

Data analysis
Databases
Data Architecture
Data Dictionary
Data Governance
Data Integration
ETL
Data Profiling
Data Structures
Data Systems
Data Warehousing
IBM DB2
Database Queries
IBM InfoSphere DataStage
Dimensional Modeling
Hadoop
Meta-Data Management
Metadata Repositories
Reference Data
SQL Server Integration Services
Talend
Teradata
Toad Data Modeler
Enterprise Software Applications
Informatica Powercenter
Snowflake
Oracle Designer
Data Lake
Data Lineage
Star Schema
Operational Systems
Data Management
Physical Data Models

Job description

We are looking for an experienced Senior Data Modeler to design and govern enterprise data models that support operational systems, analytics, reporting, and data warehousing initiatives. The ideal candidate will have strong expertise in conceptual, logical, and physical data modeling, along with a deep understanding of data architecture, governance, metadata management, and data quality practices., Design, develop, and maintain conceptual, logical, and physical data models for enterprise applications and data platforms. Translate business requirements into scalable, efficient, and governed data structures. Develop dimensional models, including Star Schema and Snowflake Schema designs, for enterprise data warehouses. Conduct data analysis, source system assessment, and data profiling activities. Create and maintain source-to-target mappings, data dictionaries, business glossaries, and metadata repositories. Define and enforce enterprise data standards, naming conventions, and governance policies. Partner with Business Analysts, Data Architects, DBAs, Data Engineers, and ETL teams to deliver data solutions. Support Master Data Management (MDM), Reference Data Management, Data Lineage, and Data Quality initiatives. Review and optimize data structures for performance, scalability, consistency, and regulatory compliance.

Requirements

10+ years of experience in Data Modeling, Data Architecture, or Data Warehousing.

Strong hands-on experience in: Conceptual, Logical, and Physical Data Modeling Enterprise Data Architecture Data Warehousing and Dimensional Modeling Star Schema and Snowflake Schema Design Metadata Management Data Governance and Data Quality Master Data Management (MDM)

Proficiency with data modeling tools such as: ERwin Data Modeler / Model Mart Oracle Designer or equivalent modeling tools Strong SQL skills and experience in data profiling and analysis.

Hands-on experience with enterprise databases like: Oracle SQL Server Teradata DB2 Snowflake Hadoop/Data Lake environments Understanding of ETL and data integration processes using tools such as Informatica, DataStage, SSIS, Talend, or similar platforms.

Mandatory Skills: Toad Data Modeler .

Experience: 8-10 Years .

Benefits & conditions

3.83.8 out of 5 stars Avenel, NJ 07001 $80,000 - $158,000 a year, Pulled from the full job description

  • Health insurance
  • Paid time off
  • Dental insurance
  • Disability insurance, The expected compensation for this role ranges from $80,000 to $158,000 .

Final compensation will depend on various factors, including your geographical location, minimum wage obligations, skills, and relevant experience. Based on the position, the role is also eligible for Wipro's standard benefits including a full range of medical and dental benefits options, disability insurance, paid time off (inclusive of sick leave), other paid and unpaid leave options.

About the company

Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients' most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.

Apply for this position