DATA MODELLER

ROLE: DATA MODELLER

Berkeley Heights, NJ

Contract

Role Overview:

The Data Modeler will design, implement, and maintain conceptual, logical, and physical data models to support enterprise data strategies. This role ensures data integrity, scalability, and alignment with business objectives across multiple platforms (RDBMS, NoSQL, data lakes).

Key Responsibilities:

• Develop and maintain conceptual, logical, and physical data models for enterprise systems.
• Understand the requirement and plan to design efficient data model that fits into client expectation
• Validate and reconcile models to ensure accuracy and compliance with standards.
• Collaborate with business analysts, developers, and architects to translate requirements into data structures.
• Design and govern enterprise-wide Conceptual, logical and physical data models supporting complex, large-scale data ecosystems
• Partner with stakeholders to align data architecture with long-term business objectives, ensuring scalability, security, and compliance
• Architect highly optimized OLAP (star/snowflake schemas) and OLTP models for data warehouses, data lakes, and normalization
• Collaborate with Data Governance teams to implement data stewardship, master data management (MDM), and data mapping/lineage
• Design non-relational data models (e.g., Graph databases, JSON structures) to support unstructured and semi-structured data.
• Analyze physical data models and collaborate with ETL/ELT/Program developers to optimize query performance, indexing, and materialized views etc..
• Create and enforce database development standards and best practices.
• Prepare DB design documents, DDL scripts, and maintain metadata repositories.
• Optimize database performance and troubleshoot issues.
• Support ETL processes, data governance, and security compliance.
• Provide training and consultation to teams on data modeling principles.

Required Skills & Qualifications:

• Strong expertise in SQL/NoSQL and relational/dimensional modeling.
• Hands-on experience with data architecture, performance tuning, and sandbox POCs.
• Familiarity with data visualization, analytics, and machine learning tools.
• Proficiency in data modeling tools and content management systems.
• Knowledge of ETL frameworks, data governance, and compliance standards.

Preferred Certification:

• Oracle Certified Professional – Database Modeling & Design.
• Data Modeling Certification (DMC).

Behavioral Skills:

• Excellent communication and collaboration skills.
• Analytical mindset with strong attention to detail.
• Ability to work independently and manage multiple priorities.
• 5 days WFO
• Ability to work in a changing environment
• Strong problem solving and analytical skills    
• Ability to work independently or within a team
• Manage day-to-day challenges and communicate developmental risks with the technical team 
• Manage day-to-day challenges and communicate developmental risks with the technical team 

Qualifications & Experience:

• Bachelor’s degree in computer science, Software Engineering, or a related field.
• Proficiency in business process modeling and documentation tools.
• Product implementation experience is preferred