Senior Data Modeler
- Sage IT Inc.
18 Hours Ago
NA
W2, C2C
Mclean-VA
10-20 Years
Required Skills: Data Mapping, Data Lineage, Data Profiling, Data Quality Analysis, schema design, DDL creation, XML, JSON data structures,
Job Description
Required Skills:
• Strong experience in Data Modeling using relational and NoSQL databases.
• Expertise in Conceptual, Logical, and Physical Data Model design.
• Hands-on experience with Dimensional Modeling (Star/Snowflake Schemas) and Data Warehousing.
• Experience in Data Mapping, Data Lineage, Data Profiling, and Data Quality Analysis.
• Proficiency in schema design, DDL creation, XML/JSON data structures, and metadata management.
• Experience with data modeling tools such as ER Studio or equivalent.
• Knowledge of Snowflake and cloud-based data platforms.
• Familiarity with Agile development methodologies.
• Strong analytical, problem-solving, and stakeholder communication skills.
Key Responsibilities:
• Design, develop, and maintain enterprise data models to support business and analytical needs.
• Gather and document data requirements from business and technical stakeholders.
• Create and enhance logical and physical data models, schemas, and database objects.
• Perform data profiling, lineage analysis, and source-to-target mapping.
• Analyze and resolve data quality issues through root cause analysis.
• Develop data flow diagrams, process workflows, and technical documentation.
• Support data governance, metadata management, and data standardization initiatives.
• Collaborate with cross-functional teams to deliver scalable, high-quality data solutions.
• Ensure data models are optimized for performance, scalability, and maintainability.
• Participate in peer reviews and contribute to data architecture best practices.
