Senior Data Modeler

Job Title: Senior Data Modeler Location: McLean, VA (Onsite) Onsite Interview Work Type: Contract Role Overview We are seeking a Senior Data Modeler to design and optimize enterprise-scale data models supporting complex financial systems. This role involves translating business requirements into scalable data structures, enabling high-quality analytics and data-driven decision-making. The ideal candidate will have strong expertise in SQL, Snowflake, and modern data modeling techniques, along with experience in financial services environments. Key Responsibilities • Design and maintain conceptual, logical, and physical data models for enterprise data platforms • Collaborate with business and technical stakeholders to translate requirements into scalable data solutions • Develop and optimize SQL queries to support analytics and reporting needs • Implement and manage data models within Snowflake environments • Apply JSON-based data modeling techniques for handling semi-structured data • Support data integration and ETL processes to ensure data consistency and availability • Ensure adherence to data quality, governance, and modeling best practices • Document data models, relationships, and transformation logic clearly Required Qualifications • Proven experience as a Data Modeler in financial services environments • Strong proficiency in SQL and hands-on experience with Snowflake • Experience with data modeling techniques (conceptual, logical, physical) • Experience working with JSON and semi-structured data formats • Understanding of ETL processes and data integration workflows • Strong communication skills to work with both technical and non-technical stakeholders