Senior Data Modeling Lead - Remote, Enterprise DW

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

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.