Senior Data Modeler

Globenet Consulting Corp; Bellevue (WA); Hybrid; USD 100,000 - 130,000; Full time

Benefits offered by this job

Competitive salary

Opportunity for advancement

Training & development

Flexible work from home options

Job summary

Globenet Consulting Corp is seeking a Senior Data Modeler to design and maintain data models for enterprise analytics in a hybrid work environment. The ideal candidate will have over 7 years of experience, expertise in data modeling tools, and a solid understanding of both relational databases and cloud data platforms. Responsibilities include collaborating with teams to optimize data structures and leading data model reviews. Competitive salary and opportunities for advancement are offered.

Qualifications

• 7+ years of experience in data modeling, data architecture, or a closely related discipline.
• Deep knowledge of dimensional modeling approaches (Kimball, Inmon) and Data Vault 2.0.
• Proven ability to work independently and manage competing priorities.

Responsibilities

• Design conceptual, logical, and physical data models for various data stores.
• Create and maintain ERDs, data flow diagrams, and modeling documentation.
• Collaborate with engineering teams to support efficient data pipelines.

Skills

Expert proficiency with modeling tools

Strong experience with relational databases

Advanced SQL skills

Strong communication skills

Tools

Erwin

ER/Studio

dbt

SQL Server

Oracle

PostgreSQL

Databricks

Snowflake

BigQuery

Redshift

Azure Synapse

Job description

Benefits:

• Competitive salary
• Opportunity for advancement
• Training & development

Role: Senior Data Modeler — Enterprise Analytics & Data Platforms

Location: Morristown, NJ (Hybrid — 3 days/week onsite)

We’re looking for a Senior Data Modeler (7+ years) to design, develop, and maintain scalable data models that power enterprise analytics, data warehousing, and modern application development. In this role, you’ll partner closely with engineers, architects, analysts, and business stakeholders to translate complex requirements into high-performing data structures, modeling standards, and documentation that improve usability, governance, and data quality across the organization.

What you’ll do

• Design conceptual, logical, and physical data models for relational, dimensional, and NoSQL data stores.
• Create and maintain ERDs, data flow diagrams, and modeling documentation aligned to enterprise standards.
• Collaborate with engineering and architecture teams to support efficient ingestion, transformation, and reporting pipelines.
• Translate business needs into optimized schemas that balance scalability, performance, and maintainability.
• Lead data model reviews, enforce standards, and mentor junior team members on best practices.
• Develop and maintain data dictionaries, metadata, and lineage documentation to improve discoverability and reuse.
• Design star/snowflake schemas for data warehouse and data mart environments in partnership with analytics teams.
• Identify and resolve data quality, redundancy, and integrity issues through effective modeling and normalization/denormalization strategies.
• Support governance initiatives, including standardization, cataloging, and stewardship alignment.
• Participate in Agile delivery, producing modeling artifacts iteratively within sprint cycles.

Required qualifications

• 7+ years of experience in data modeling, data architecture, or a closely related discipline.
• Expert proficiency with modeling tools such as Erwin, ER/Studio, and/or dbt.
• Strong experience with relational databases (SQL Server, Oracle, PostgreSQL) and cloud data platforms such as Databricks, Snowflake, BigQuery, Redshift, and Azure Synapse.
• Deep knowledge of dimensional modeling approaches (Kimball, Inmon) and Data Vault 2.0.
• Advanced SQL skills for schema design, query optimization, and data validation.
• Proven ability to work independently, manage competing priorities, and deliver in consulting/contractor-style environments.
• Strong communication skills and the ability to explain technical concepts to technical and non-technical audiences.

Nice to have

• NoSQL experience (MongoDB, Cassandra, DynamoDB).
• Lakehouse architecture familiarity (Delta Lake, Apache Iceberg, Apache Hudi).
• Exposure to governance/catalog tools (Collibra, Alation, Atlan).
• Understanding of data mesh concepts and federated ownership models.
• Experience in regulated domains such as finance, healthcare, or retail.

Ready to make an impact? Apply now and join us on our journey!

Flexible work from home options available.