Enter a job title or keyword
Data Modeling
Job Location:
Job Location:
Columbus, OH - USA
Hourly Salary:
USD 70 - 75
Hourly Salary:
Posted:
9 September 2026 (10 hours ago)
Posted:
Application Deadline:
7 December 2026
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Title: Data Modeling
Location: Columbus OH
Pay: $70/hr-$75/hr on c2c
JD:
Define entities relationships and keys (primary/foreign keys) and document cardinalities
Specify table grain (row-level meaning) for each fact/event/feature table
Create dimension tables with consistent codes descriptions and hierarchy attributes where applicable
Create fact/event tables with measures timestamps and join keys to relevant dimensions/entities
Represent time using standard date/time fields and when needed effective start/end dates for history
Standardize naming conventions data types units and allowed values (domains) across models
Add metadata and documentation (field definitions source system refresh cadence owner)
Implement basic validation checks (nullability uniqueness referential integrity value ranges)
Design outputs for common access patterns (joins filters aggregations) used by OLAP and AI pipelines
Maintain versioning/change history for models and update downstream dependencies when schemas change
Optimize the models for performance of AI/BI use cases
Good understanding of Databricks concepts
Good understanding of tools like Erwin
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Location: Columbus OH
Pay: $70/hr-$75/hr on c2c
JD:
Define entities relationships and keys (primary/foreign keys) and document cardinalities
Specify table grain (row-level meaning) for each fact/event/feature table
Create dimension tables with consistent codes descriptions and hierarchy attributes where applicable
Create fact/event tables with measures timestamps and join keys to relevant dimensions/entities
Represent time using standard date/time fields and when needed effective start/end dates for history
Standardize naming conventions data types units and allowed values (domains) across models
Add metadata and documentation (field definitions source system refresh cadence owner)
Implement basic validation checks (nullability uniqueness referential integrity value ranges)
Design outputs for common access patterns (joins filters aggregations) used by OLAP and AI pipelines
Maintain versioning/change history for models and update downstream dependencies when schemas change
Optimize the models for performance of AI/BI use cases
Good understanding of Databricks concepts
Good understanding of tools like Erwin
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
