• Data Modeler (Ohio Candidates Only)

    TEKsystems (Dublin, OH)


    Description

    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.

    Required Qualifications

    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.

    Skills:

    Preferred Skills

     

    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.

     

    Job Type & Location

     

    This is a Contract position based out of Dublin, OH.

    Pay and Benefits

    The pay range for this position is $65.00 - $80.00/hr.

     

    Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: • 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)

     

    Workplace Type

     

    This is a hybrid position in Dublin,OH.

     

    Application Deadline

     

    This position is anticipated to close on Jan 29, 2026.

    h4>About TEKsystems:

    We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

     

    The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

    About TEKsystems and TEKsystems Global Services

    We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

     

    The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.