Senior Data Modeler: Snowflake, SQL & Mortgage Analytics

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

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.