Senior Data Modeler

Artech Information System LLC; McLean (VA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading IT staffing company is seeking a Senior Data Modeler in Virginia to work closely with project teams and provide expertise in data modeling. The ideal candidate will have 8-10 years of experience, especially in the mortgage or finance industry, and proficiency in SQL and various database management tools. This position offers the chance to develop logical and physical data models and ensure data accuracy and reliability across systems. Join a dynamic environment where your analytical skills will thrive.

Qualifications

• 8-10 years of data modeling and metadata management experience.
• Experience with relational and dimensional data modeling.
• Experience with data management standards and practices.

Responsibilities

• Develop logical and physical data models.
• Map entities to the enterprise Canonical Data Model.
• Implement scripts to manage metadata.

Skills

Data modeling

SQL

Visual Basic macro development

Problem-solving

Critical thinking

Education

Bachelor Degree in Business, Information Technology, or Engineering

Tools

DB2

Oracle

SQL Server

ER/Studio DA

ERwin

Job description

Artech Information Systems is the #12 Largest IT Staffing Company in the U.S. and an employer of choice for over 7,000 consultants. We recruit world‑class talent for IT, engineering, and other professional jobs at 70+ Fortune and Global 500 companies coast‑to‑coast across the U.S., India, and China. We are one of the fastest‑growing companies in the US and we welcome you to search the thousands of jobs in our cutting‑edge GEM system for employment opportunities that fit your qualifications. At the forefront of the staffing industry, Artech is a minority and women‑owned business enterprise (MWBE) committed to maximizing global workforce solutions on behalf of its clients. Artech's deep heritage, proven expertise and insightful market intelligence has secured long‑term partnerships with Fortune 500 and government clients seeking world‑class professional resources.

Job Description

The Sr. Data Modeler will work closely with project teams to understand business requirements and provide data modeling subject matter expertise. Strong quantitative and analytic skills are required.

• The Sr. Data Modeler will:
• Develop logical and physical data models
• Map logical entities to the enterprise Canonical Data Model
• Develop, test, and implement scripts, programs, and related processes to collect, manage, and publish DEV and PROD metadata from data models
• Promote data models into production metadata environments
• Support post‑production validation of DDL
• Provide Level of Efforts (LOEs), activity status, identify dependencies impacting deliverables, identify risks and mitigation plans, identify issues and impacts

Qualifications

• Bachelor Degree from an accredited university with coursework in Business, Information Technology, or Engineering.
• 8-10 years of data modeling and metadata management experience.
• Experience with both relational and dimensional data modeling
• Experience with data management standards and data model practices
• Experience with query capabilities such as Visual Basic macro development and SQL
• Experience with physical data structure design in DB2, UDB, Oracle, Sybase, and/or SQL Server using ER/Studio DA or ERwin
• Mortgage/finance industry data modeling experience

Additional Qualifications

• Proven ability to quickly earn the trust of key stakeholders
• Thrives in an environment with changing priorities
• Sound business and technical acumen
• Focused and versatile team player that is comfortable under pressure
• Excellent problem‑solving and critical‑thinking skills
• Able to navigate through a large corporate environment and ensure appropriate processes are met