Data modeling is at the heart of modern analytics, especially as companies shift to cloud data warehouses like Snowflake. Organizations in the Washington DC metro area are aggressively hiring senior talent to design robust, enterprise‑wide data structures. This Sr Data Modeler contract role offers a chance to lead critical data initiatives for a fast‑growing engineering firm.

Job Summary

We are seeking an experienced Sr Data Modeler to design, develop, and maintain enterprise‑level data models (conceptual, logical, and physical) on Snowflake. You will collaborate daily with both business and technical stakeholders, translate complex requirements into scalable schemas, and handle semi‑structured data formats such as JSON.

Top 3 Critical Skills Table

Interview Preparation

1. Explain the differences between conceptual, logical, and physical data models.
   What the interviewer is looking for: Ability to articulate modeling phases, abstraction levels, and how each informs the next.
2. How would you optimize a Snowflake query that is performing poorly?
   What the interviewer is looking for: Knowledge of clustering keys, micro‑partition pruning, caching, and query profiling.
3. Describe a strategy for modeling semi‑structured JSON data in Snowflake.
   What the interviewer is looking for: Understanding of VARIANT columns, Snowflake’s native JSON functions, and schema‑on‑read vs. schema‑on‑write approaches.
4. How do you gather and validate requirements from both business and technical stakeholders?
   What the interviewer is looking for: Communication skills, use of workshops, data dictionaries, and traceability matrices.
5. What governance practices do you embed in your data models to ensure data quality and security?
   What the interviewer is looking for: Experience with data lineage, access controls, naming conventions, and documentation standards.

Resume Optimization

• SQL
• Snowflake
• Enterprise Data Modeling
• Conceptual Modeling
• Logical Modeling
• Physical Modeling
• JSON
• Semi‑structured Data
• Business Stakeholder Collaboration
• Technical Stakeholder Collaboration

Application Strategy

When reaching out to the recruiter, send a concise email that starts with a friendly greeting, attaches your updated resume, and clearly highlights your top relevant skills. Make sure to mention related skills you possess, such as SQL, Snowflake, and Enterprise Data Modeling, and reference any projects where you built end‑to‑end data models or worked with JSON data. Emphasize your 13+ years of experience and your ability to work onsite full‑time.

Career Roadmap