Senior Data Modeler

Strategio; McLean (VA); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Strategio is seeking a Senior Data Modeler in McLean, VA, for a hybrid role that involves architecting and optimizing data structures for financial systems. The ideal candidate should have strong experience in data modeling, advanced SQL expertise, and hands-on experience with Snowflake. Responsibilities include maintaining ETL pipelines, translating business requirements into data structures, and developing SQL queries for analytics. Join a high-performance team committed to impactful data solutions.

Qualifications

• Strong experience in data modeling within financial services environments.
• Confident working with both structured and semi-structured data.
• Ability to translate business requirements into scalable data solutions.

Responsibilities

• Design, build, and maintain scalable ETL pipelines supporting structured data.
• Translate business requirements into scalable and efficient data structures.
• Develop and optimize SQL queries for analytics and reporting.
• Build and manage data models within Snowflake environments.
• Implement JSON-based modeling for semi-structured data.

Skills

Data modeling within financial services

Advanced SQL expertise

Hands-on experience with Snowflake

Experience with JSON and semi-structured data

Understanding of data integration and ETL processes

Strong communication skills

Job description

Strategio - Senior Data Modeler - Hybrid, McLean, VA

The Opportunity:

We are looking for a Senior Data Modeler to help architect and optimize data structures that power complex financial systems. This role is ideal for someone who thrives at the intersection of business and data, translating requirements into scalable, high‑performing models that enable advanced analytics and informed decision‑making.

You’ll collaborate with cross‑functional teams, working hands‑on with modern data technologies to ensure data is structured, accessible, and impactful.

About you

You have strong experience in data modeling within financial services environments and are confident working with both structured and semi‑structured data. You bring advanced SQL expertise and hands‑on experience with Snowflake, enabling you to design and optimize data models that support complex analytical needs.

You are comfortable translating business requirements into scalable data solutions and have a solid understanding of data integration and ETL processes. You communicate effectively with both technical and non‑technical stakeholders, and you are detail‑oriented, analytical, and take ownership of your work in fast‑paced, collaborative environments.

As a Strategio Senior Data Modeler, you will:

• Design, build, and maintain scalable ETL pipelines supporting structured and design and maintain conceptual, logical, and physical data models for enterprise‑scale systems
• Translate business requirements into scalable and efficient data structures
• Develop and optimize SQL queries for analytics and reporting
• Build and manage data models within Snowflake environments
• Implement JSON‑based modeling for semi‑structured data
• Collaborate with technical and non‑technical stakeholders to align data solutions with business goals

Core Skills

• Strong experience in data modeling within financial services environments
• Advanced SQL expertise
• Hands‑on experience with Snowflake
• Experience with JSON and semi‑structured data modeling
• Understanding of data integration and ETL processes
• Strong communication skills across technical and business teams

Nice‑to‑Haves

• Experience with mortgage or housing finance data (especially multi‑family)
• Knowledge of data governance and data quality frameworks
• Exposure to additional cloud data platforms
• Experience in consulting or client‑facing roles

Your job search ends here.

If you’re eager to contribute to cutting‑edge projects and want to work with a high performance team, Apply Here