Data Modeler

Kellton is a seeking a senior Data Modeler to help us support our global financial services client. This is a long-time contract position out of their midtown Manhattan location. Position: Senior Data Modeler Location: New York. NY Duration: 12 months + Mode: Hybrid (3 days per week onsite) Rate: up to $65/hr. on a w2 or $75/hr. C2C This is a high-visibility, hands-on role ideal for individuals who combine strong business engagement skills with technical fluency in data modeling, SQL, Python, and modern analytics platforms. Primary Responsibilities -Partner with bankers, operational leaders, and senior stakeholders to capture workflows, entities, and data requirements. -Design and maintain logical and semantic data models aligned to the firm’s enterprise architecture. -Define attributes, hierarchies, and business rules for core domains (e.g., funds, sponsors, deals, coverage). -Explore and validate datasets in SQL, Python, and Databricks, shaping raw data into business-ready domain tables. -Collaborate with data engineers on ingestion, transformations, and enrichment of data for business consumption. -Prototype transformations and pipelines in Python/Databricks, then hand off to Engineers implement in production. -Present domain models and outputs to stakeholders, gather feedback, and iterate to ensure alignment. -Serve as a trusted bridge between business stakeholders and technical teams, ensuring that models are both accurate and usable. Qualifications -5+ years of experience in data architecture, solution design, or hybrid business/data roles within financial services or consulting. -Strong proficiency in: • SQL (querying, joining, validating relational datasets). • Python (data wrangling, prototyping, APIs, Pyspark). • Databricks or equivalent data platforms -Deep understanding of data modeling, semantics, ontologies, and master data management (MDM). -Familiarity with data integration patterns (ETL/ELT, APIs, third-party data sources). -Strong communication skills, with proven ability to translate complex data concepts for business and technical audiences. -Highly organized, proactive, and able to balance big-picture design with hands-on prototyping.