Data Modeler

Cliff Services Inc; McLean (VA); On-site; USD 110,000 - 160,000; Full time

Job summary

Cliff Services Inc is seeking a Senior Data Modeler to design, develop, and optimize data models for complex financial systems. You will translate business requirements into robust structures supporting analytics and decision-making.

Expect strong SQL, Snowflake, and JSON data modeling capabilities, plus domain knowledge in financial services. You will collaborate with cross-functional teams and guide data governance and quality initiatives.

Qualifications

• Experience designing data models for financial services.
• Proficient with SQL and Snowflake data environments.
• JSON data modeling for semi-structured data.
• Understanding of ETL, data integration, governance and quality.

Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise-scale platforms.
• Collaborate with stakeholders to translate business needs into scalable data solutions.
• Develop and optimize SQL to support analytics and reporting requirements.
• Implement and manage data structures within Snowflake environments.
• Apply JSON-based data modeling techniques for flexible data architectures.

Skills

Data Modeling

SQL

Snowflake

JSON Modeling

Semi-Structured Data

ETL

Financial Services

Data Integration

Data Governance

Data Quality

Cloud Platforms

Stakeholder Mgmt

Mortgage Finance

Tools

Snowflake Tools

Job description

Senior Data Modeler

They should have exposure to mongodb and mortgage experience

The Role

We are seeking a Senior Data Modeler to design, develop, and optimize data models that support complex financial systems. You will work closely with cross-functional teams to translate business requirements into robust data structures, enabling high-quality analytics and data-driven decision-making.

This role requires strong expertise in SQL, Snowflake, and modern data modeling techniques, alongside domain knowledge in financial services.

What You'll Do

• Design and maintain conceptual, logical, and physical data models for enterprise-scale platforms.
• Collaborate with stakeholders to translate business needs into scalable data solutions.
• Develop and optimize SQL to support analytics and reporting requirements.
• Implement and manage data structures within Snowflake environments.
• Apply JSON-based data modeling techniques for flexible and modern data architectures.

What We're Looking For

• Proven experience in data modeling within financial services environments.
• Strong proficiency in SQL and hands-on experience with Snowflake.
• Experience with JSON data modeling and semi-structured data formats.
• Understanding of data integration and ETL processes.
• Ability to communicate clearly with technical and non-technical stakeholders.

Bonus Points For

• Experience with multi-family mortgage or housing finance data.
• Familiarity with data governance and data quality frameworks.
• Exposure to cloud-based data platforms beyond Snowflake.
• Experience working in consulting or client-facing environments.

Key Skills

• Data Modeling (Conceptual, Logical & Physical)
• SQL
• Snowflake
• JSON Data Modeling
• Semi-Structured Data
• ETL
• Financial Services Domain
• Data Integration
• Data Governance
• Data Quality
• Cloud Data Platforms
• Stakeholder Management
• Mortgage / Housing Finance (Preferred)