Data Modeler Lead Consultant

Jobgether; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Remote work (fully remote)

Leadership opportunities

Professional development

Technical impact

Cross-functional collaboration

Job summary

Jobgether seeks a senior data modeler to lead enterprise data modeling efforts, translating business needs into scalable models and collaborating with data engineers and analytics teams.

You will design 3NF relational structures, develop dimensional models, and build robust data warehouse architectures while optimizing SQL queries and driving governance, standards, and mentorship in a fully remote setup.

Qualifications

• At least 8 years of experience in data modeling, data architecture, data warehousing, or related enterprise data disciplines.

Responsibilities

• Design, develop, and maintain enterprise data models (conceptual to physical).
• Apply 3NF principles to relational structures across systems.
• Develop dimensional models using star and snowflake schemas.
• Design and optimize data warehouse architectures for efficient data integration and access.
• Write and optimize complex SQL queries for validation and performance.
• Collaborate with stakeholders to capture reporting requirements and translate them into models.
• Establish naming conventions, metadata, and design best practices.
• Collaborate with data architects, engineers, ETL/ELT teams, and analytics staff.
• Evaluate architectures and recommend improvements for scalability and data quality.
• Lead data modeling discussions and mentor team members.

Skills

Data modeling

3NF modeling

Dimensional modeling

Data warehousing

SQL development

Data governance

Stakeholder collaboration

Analytical problem-solving

Leadership

Education

Bachelor's degree in a relevant field

Tools

ERwin

ER/Studio

Snowflake

Databricks

Microsoft Fabric

SAP data environments

Job description

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.