Senior Data Modeler

We welcome Corp-to-Corp and W2 Candidates NO DIRECT CALLS OR EMAILS WILL BE RETURNED. We are seeking a Senior Data Modeler for our client. This role will architect and operationalize scalable, governed data structures that transform raw, disparate data into trusted, analytics-ready assets. This position demands mastery of data modeling principles, normalization, and SQL-based transformations within modern cloud ecosystems (e.g., Snowflake). This senior-leveled individual will set modeling standards, influence cross-functional teams, and ensure data integrity, consistency, and performance across the enterprise. Responsibilities: • 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. • 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. Requirements: • Bachelor’s or Master’s degree in Computer Science, Engineering, or related field. • More than 5 years’ 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). • Ability to travel to Baltimore, MD, as needed. • 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. • Ability to transfer knowledge and experience to junior staff. Nice to Have: • 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. We look forward to receiving your resume in PDF format.