Senior Data Modeler

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.