Job Description

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:

• Medical & Dental Insurance
• Health Savings Account (HSA)
• 401(k)
• Paid Sick Time Leave
• Pre-tax Commuter Benefit
• Applicants must be currently authorized to work in the United States on a full-time basis now and in the future.

Motion Recruitment provides IT Staffing Solutions (Contract, Contract-to-Hire, and Direct Hire) in major North American markets. Our unique expertise in today’s 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.

Job Tags

Similar Jobs