Senior Data Modeler / Senior Data Modeling / 14+yrs only

Visionary Innovative Technology Solutions LLC; Virginia (MN); On-site; USD 120,000 - 180,000; Full time

Job summary

Visionary Innovative Technology Solutions LLC seeks a Senior Data Architect with 10+ years of experience to design enterprise data models and support analytical needs. You will gather requirements from business and technical stakeholders and create logical and physical models.

Responsibilities include data profiling, lineage analysis, mapping, quality remediation, and documenting data architectures. Collaborative cross-functional work ensures scalable, high-quality data solutions.

Qualifications

• 10+ years in Data Modeling, Data Architecture, or Data Management.
• Strong stakeholder communication and collaboration with business teams.
• Proficient in relational and NoSQL modeling, including schema design and DDL creation.

Responsibilities

• Design, develop, and maintain enterprise data models for business and analytical needs.
• Gather and document data requirements from 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, workflows, and technical documentation.
• Support data governance, metadata management, and standardization initiatives.
• Collaborate with cross-functional teams to deliver scalable data solutions.
• Ensure data models are optimized for performance, scalability, and maintainability.
• Participate in peer reviews and contribute to data architecture best practices.

Skills

Data modeling

Dimensional modeling

Data warehousing

Data profiling

Data quality analysis

Data mapping

Data lineage

Metadata management

Agile

Tools

ER Studio

Snowflake

Job description

Employment Type :- Contract / Full Time

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.

Experience: 10+ years in Data Modeling, Data Architecture, or Data Management.