Data Modeler
AME IT Solutions
McLean, United States of America
4 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
McLean, United States of America
Tech stack
Data Architecture
Data Governance
Data Integration
ETL
Data Structures
JSON
SQL Databases
Cloud Platform System
Snowflake
Semi-structured Data
Physical Data Models
Data Pipelines
Job description
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 queries 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
Requirements
- 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
Experience:
- data modeling within financial services environments: 10 years (Required)
- hands-on with Snowflake: 10 years (Required)
- JSON data modeling and semi-structured data formats: 10 years (Required)