Data Modeler (Ohio Candidates ONLY)
About The Position
We are seeking a highly experienced Data Modeler to design and implement enterprise-grade data solutions. This role requires deep expertise in data modeling principles, data architecture frameworks, and modern cloud-based platforms. The candidate will play a critical role in shaping our data ecosystem, ensuring scalability, performance, and alignment with business needs. Key Responsibilities Data Modeling: Design conceptual, logical, and physical data models for structured and semi-structured data. Define entity relationships, normalization/denormalization strategies, and dimensional modeling for analytics. Develop star and snowflake schemas for data warehouses and analytical workloads. Ensure data integrity, consistency, and compliance with governance standards. Data Architecture: Architect end-to-end data solutions leveraging modern frameworks and best practices. Implement Medallion architecture (Bronze, Silver, Gold layers) for scalable data pipelines. Optimize data storage and retrieval strategies for performance and cost efficiency. Collaborate with engineering teams to design data ingestion, transformation, and integration workflows. Technology Stack: Hands-on experience with Google BigQuery for large-scale analytics. Expertise in Databricks for data engineering and advanced analytics. Familiarity with cloud-native architectures, distributed systems, and data lakehouse concepts.
Requirements
- 10+ years of experience in data modeling and data architecture.
- Proven track record in designing enterprise data warehouses and analytical platforms.
- Strong understanding of Medallion architecture and modern data lakehouse design.
- Proficiency in SQL, data modeling tools (e.g., ERwin, PowerDesigner), and ETL/ELT frameworks.
- Hands-on experience with Google BigQuery and Databricks.
Nice To Haves
- Knowledge of data governance, metadata management, and master data management.
- Experience with performance tuning and query optimization in large-scale environments.
- Familiarity with data security and compliance standards.
Responsibilities
- Design conceptual, logical, and physical data models for structured and semi-structured data.
- Define entity relationships, normalization/denormalization strategies, and dimensional modeling for analytics.
- Develop star and snowflake schemas for data warehouses and analytical workloads.
- Ensure data integrity, consistency, and compliance with governance standards.
- Architect end-to-end data solutions leveraging modern frameworks and best practices.
- Implement Medallion architecture (Bronze, Silver, Gold layers) for scalable data pipelines.
- Optimize data storage and retrieval strategies for performance and cost efficiency.
- Collaborate with engineering teams to design data ingestion, transformation, and integration workflows.
Benefits
- Medical, dental & vision
- Critical Illness, Accident, and Hospital
- 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
- Life Insurance (Voluntary Life & AD&D for the employee and dependents)
- Short and long-term disability
- Health Spending Account (HSA)
- Transportation benefits
- Employee Assistance Program
- Time Off/Leave (PTO, Vacation or Sick Leave)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
