Senior Data Modeler (Baltimore)

Senior Data Modeler

6 Month Contract (Possible Extension or Contract-to-Hire )

Location : 100% Remote (Client located in Baltimore, MD)

• Must be able to work on a W-2
• Must be able to work EST hours

Job Description

Seeking a seasoned Data Modeler to architect and operationalize scalable, governed data structures that transform raw, disparate data into trusted, analytics-ready assets. This role demands mastery of data modeling principles, normalization, and SQL-based transformations within modern cloud ecosystems (e.g., Snowflake). As a senior individual contributor, you will set modeling standards, influence cross-functional teams, and ensure data integrity, consistency, and performance across the enterprise.

Ability to collaborate closely with technical and business leaders to understand data requirements and deliver impactful solutions.

Ability to design data quality, data lineage, and data governance practices across the organization.

Ability to advocate for advanced data engineering tools, platforms, and technologies.

Ability to transfer knowledge and experience to junior staff.

Key Responsibilities

Data Architecture & Modeling

Design and maintain conceptual, logical, and physical data models that enable high-performance analytics and transactional workloads.

Normalize and optimize complex, raw, and semi-structured data into relational structures aligned with business and analytical requirements.

Own metadata and lineage : document entity relationships, definitions, and transformation logic to ensure transparency and reusability.

Collaboration & Influence

Partner strategically with data engineers, analysts, and business stakeholders to translate requirements into scalable models and influence upstream design decisions.

Serve as SME for data modeling best practices; evangelize standards and mentor peers to elevate modeling maturity across teams.

Implementation & Governance

Implement models in Snowflake and other cloud platforms, ensuring compliance with performance, security, and governance frameworks.

Champion automation : leverage dbt, Python, or orchestration tools to streamline model deployment and enforce version control.

Conduct proactive data profiling and quality checks to validate accuracy and integrity before production rollout.

Innovation & Continuous Improvement

Lead POCs for modern modeling approaches-including semantic layers, ML-ready schemas, and hybrid architectures-and institutionalize successful patterns.

Continuously refine modeling standards, naming conventions, and governance policies to support evolving business needs.

Mandatory Skills

5+ years of experience in data modeling or database design, with proven ability to normalize complex datasets into optimized relational models.

Advanced SQL skills and strong understanding of ETL / ELT processes.

Hands-on experience with modern cloud data platforms (Snowflake preferred).

Education

Bachelor's or Master's degree in Computer Science, Engineering, or a related field.

Desired Skills

Familiarity with data governance and cataloging tools (e.g., Collibra, Alation).

Experience with dbt or scripting (Python) for automated transformations and CI / CD workflows.

Strong communication skills to translate technical concepts into business language and influence stakeholders.

You Will Receive The Following Benefits :

Motion Recruitment provides IT Staffing Solutions (Contract, Contract-to-Hire, and Direct Hire) in major North American markets. Our unique expertise in todays highest-demand tech skill sets, paired with our deep networks and knowledge of our local technology markets, results in an exemplary track record with candidates and clients.