Motion Recruitment
Senior Data Modeler
Contract
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.
Key Responsibilities
Collaborate closely with technical and business leaders to understand data requirements and deliver impactful solutions.
Design data quality, data lineage, and data governance practices across the organization.
Advocate for advanced data engineering tools, platforms, and technologies.
Transfer knowledge and experience to junior staff.
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.
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.
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.
Benefits
Medical & Dental Insurance
Health Savings Account (HSA)
401(k)
Applicants must be currently authorized to work in the United States on a full‑time basis now and in the future.
#J-18808-Ljbffr
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.
Key Responsibilities
Collaborate closely with technical and business leaders to understand data requirements and deliver impactful solutions.
Design data quality, data lineage, and data governance practices across the organization.
Advocate for advanced data engineering tools, platforms, and technologies.
Transfer knowledge and experience to junior staff.
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.
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.
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.
Benefits
Medical & Dental Insurance
Health Savings Account (HSA)
401(k)
Applicants must be currently authorized to work in the United States on a full‑time basis now and in the future.
#J-18808-Ljbffr