CURRENT OPENINGS

Sr. Data Modeler

3263
Remote
Contract to Hire
6 months
DOE

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.
  • 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.

Benefits of a Career at Keller Schroeder