Senior Technical Lead

Mphasis; New Jersey; On-site; USD 75,000 - 150,000; Full time

Job summary

Mphasis is seeking a Data Modeler to design, implement, and maintain conceptual, logical, and physical data models across enterprise systems. The role focuses on data integrity, scalability, and alignment with business objectives across RDBMS, NoSQL, data lakes.

Responsibilities include designing OLAP/OLTP models, collaborating with analysts and developers, and ensuring standards. Requires strong SQL/NoSQL skills and data governance knowledge, with a Bachelor’s degree in CS or related field.

Qualifications

• Strong SQL/NoSQL and dimensional modeling experience.
• Experience with data architecture, performance tuning, and POC development.
• Knowledge of ETL, data governance, and compliance standards.
• Experience with non-relational data models and data lakes.

Responsibilities

• Develop and maintain conceptual, logical, and physical data models for enterprise systems.
• Understand requirements and design efficient data models to fit client needs.
• Validate and reconcile models for accuracy and standards compliance.
• Collaborate with analysts, developers, and architects to translate requirements into data structures.
• Design and govern enterprise-wide data models for large-scale ecosystems.
• Align data architecture with long-term business objectives ensuring scalability & security.
• Architect OLAP and OLTP models for warehouses and data lakes.
• Collaborate with Data Governance on stewardship, MDM, and lineage mapping.
• Design non-relational models (Graph, JSON) for unstructured data.
• Analyze physical models and optimize queries, indexing, and materialized views.
• Create and enforce database development standards and best practices.
• Prepare DB design documents, DDL scripts, and metadata repositories.
• Optimize database performance and troubleshoot issues.
• Support ETL processes, data governance, and security compliance.
• Provide training and consultation on data modeling principles.

Skills

SQL/NoSQL & dimensional modeling

Data architecture & performance tuning

Data visualization & analytics tools

Data modeling tools & CMS

ETL frameworks, data governance &/or "

Education

Bachelor's degree in CS/Software Eng

Tools

Data modeling tools

Content management systems

ETL frameworks

Job description

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).

Role Description

Job Description

ROLE: DATA MODELLER

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

Other Details

Salary range $74500 to $150000