Data Modeler Lead Consultant

Jobgether; India; A distancia; INR 2.800.000 - 4.200.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote work

Leadership opportunities

Professional growth

Cross-functional collaboration

Enterprise impact

Descripción de la vacante

Jobgether, on behalf of a partner, is seeking a Data Modeler Lead Consultant based in India. You will lead the design of enterprise data models (conceptual, logical, physical) using 3NF and dimensional modeling, driving data warehousing, SQL optimization, and governance across finance and BI domains.

Bring 8+ years of experience in data modeling, strong stakeholder collaboration, and leadership to mentor teams.

Formación

• 8+ years in data modeling, architecture, or warehousing.
• Strong 3NF and relational design expertise.
• Dimensional modeling with star/snowflake schemas.
• Solid data warehouse concepts and performance tuning.
• Advanced SQL for validation and optimization.
• Translate business requirements into scalable models.
• Establish modeling standards, metadata, and docs.
• Lead modeling discussions and mentor teammates.
• Experience with ERwin/ER/Studio and cloud platforms.
• Familiarity with data governance and MDM.

Responsabilidades

• Lead enterprise data modeling across projects and teams.
• Design conceptual, logical, and physical data models.
• Develop 3NF relational structures and dimensional models.
• Architect scalable data warehousing solutions.
• Write and optimize complex SQL for validation and issues.
• Collaborate with stakeholders to capture requirements.
• Set standards, naming conventions, and metadata.
• Mentor engineers and guide technical decisions.
• Assess architectures and drive governance initiatives.
• Lead data modeling reviews and cross-team alignment.

Conocimientos

8+ yrs exp

3NF modeling

Dimensional modeling

Data warehousing

SQL proficiency

Enterprise data architecture

Stakeholder mgmt

Analytical thinking

Leadership

Cloud data platforms

Herramientas

ERwin/ER/Studio

Snowflake

Databricks

Microsoft Fabric

SAP data environments

Descripción del empleo

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a Data Modeler Lead Consultant based in India.

We are seeking an experienced data modeling professional to lead the design and development of scalable, enterprise-grade data architectures that power financial reporting, business intelligence, and data-driven products. In this role, you will transform complex business requirements into robust conceptual, logical, and physical data models. You will leverage your expertise in Third Normal Form (3NF), dimensional modeling, data warehousing, and SQL to ensure data accuracy, consistency, and performance. Working closely with business stakeholders, data architects, and engineering teams, you will drive effective data integration and governance practices. You will also establish modeling standards, optimize existing architectures, and provide technical leadership across complex data initiatives. This remote opportunity is ideal for a strategic, hands-on professional who enjoys solving challenging data problems and shaping enterprise data solutions.

Accountabilities

• Enterprise Data Modeling: Design, develop, and maintain conceptual, logical, and physical data models that support enterprise applications, financial reporting, analytics, and data products.
• Relational Data Design: Apply Third Normal Form (3NF) modeling principles to build normalized relational structures, reduce redundancy, and maintain data integrity across systems.
• Dimensional Modeling: Develop and maintain dimensional models using star and snowflake schemas, including facts, dimensions, and hierarchies, to support business intelligence and analytical reporting.
• Data Warehousing: Design and optimize data warehouse architectures to enable efficient data integration, storage, transformation, and retrieval.
• SQL Development and Optimization: Write, review, and optimize complex SQL queries to validate models, investigate data discrepancies, troubleshoot issues, and improve query performance.
• Business Requirements Analysis: Collaborate with stakeholders to understand business processes, reporting requirements, and data relationships, translating them into scalable and effective modeling solutions.
• Modeling Standards and Documentation: Establish and maintain data modeling standards, naming conventions, metadata, documentation, and design best practices to promote consistency and maintainability.
• Cross-Functional Collaboration: Work closely with data architects, data engineers, ETL/ELT teams, and analytics professionals to ensure accurate implementation of data models across enterprise platforms.
• Architecture Assessment: Evaluate existing data structures and architectures, identify gaps, and recommend improvements to scalability, performance reliability, and data quality.
• Data Governance: Support data governance, master data management, and data quality initiatives to maintain consistent definitions and reliable information across business domains.
• Technical Leadership: Lead data modeling discussions, conduct design reviews, mentor team members, and provide technical guidance to stakeholders throughout the development lifecycle.

Requirements

• Professional Experience: At least 8 years of relevant experience in data modeling, data architecture, data warehousing, or related enterprise data disciplines.
• 3NF Modeling: Strong hands-on expertise in Third Normal Form modeling and relational database design, including normalization, data integrity, and relationship management.
• Dimensional Modeling: In-depth knowledge of dimensional modeling techniques, including star and snowflake schemas, facts, dimensions, and hierarchies.
• Data Warehousing: Solid understanding of data warehouse concepts, architecture, implementation, and performance optimization.
• SQL Expertise: Advanced proficiency in SQL, including complex queries, database structures, data validation, troubleshooting, and query optimization.
• Enterprise Data Architecture: Demonstrated ability to translate complex business requirements into scalable, maintainable, and high-performance enterprise data models.
• Stakeholder Management: Strong communication and collaboration skills, with the ability to work effectively with business stakeholders, architects, engineers, and technology leaders.
• Analytical and Problem-Solving Skills: A structured, detail-oriented approach to resolving data challenges, evaluating architectures, and improving data quality and performance.
• Data Modeling Tools (Preferred): Hands-on experience with ERwin or ER/Studio for enterprise data modeling and documentation.
• Cloud Data Platforms (Preferred): Familiarity with Snowflake and other enterprise cloud data platforms.
• Modern Data Ecosystems (Preferred): Exposure to Databricks, Microsoft Fabric, and SAP data environments.
• Data Integration and Governance (Preferred): Understanding of ETL/ELT processes, metadata management, data integration, data governance, and master data management.
• Leadership and Ownership: The ability to lead modeling initiatives, establish technical standards, communicate design decisions, and guide teams in complex enterprise environments.

Benefits

• Remote Work: Fully remote, full-time opportunity based in India.
• Leadership Opportunities: Lead enterprise data modeling initiatives and influence data architecture decisions.
• Professional Development: Expand your expertise in data modeling, cloud data platforms, and modern data engineering practices.
• Technical Impact: Contribute to reliable, scalable data architectures that support financial reporting, business intelligence, and data-driven products.
• Cross-Functional Collaboration: Work with business stakeholders, data architects, data engineers, and analytics teams on complex enterprise challenges.
• Compensation: Salary and additional benefits were not specified in the original job description and can be clarified during the recruitment process.