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 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.
...Part-Time Office Administrative Assistant (Contractor)&##128205; Downtown Boston Financial District We are a fast-growing AI language technology startup seeking a reliable and proactive Administrative Assistant to support our management team and keep our office...
...Warehouse Associate Contract-to-Hire Location: Costa Mesa, CA JOB DESCRIPTION A food and beverage company in Costa Mesa is... ...team for a contract role with the opportunity to be brought on full time. Our client is moving inventory from one warehouse to another...
The Area Loss Prevention Manager (ALPM) protects company profits and promotes safety in their assigned areas. This individual will effectively exhibit DTLRs core values of Customer, People, Winning, Community, and Financial Responsibility in everything they do by performing...
...part of a team. Results-oriented with a focus on achieving and exceeding sales targets. Willingness to travel as needed. Must live in Orlando, Florida This position is salaried exempt, meaning that the successful candidate will not be eligible for overtime...
...SBX Technologies, LLCis seeking an experienced Heavy Equipment Operator to support remediation, industrial civil construction, and similar projects. This role is field-focused and best suited for operators who take pride in precision, safety, and productivity on complex...