Demo

Sr. Data Modeler

Revel IT
Columbus, OH Full Time
POSTED ON 4/18/2025
AVAILABLE BEFORE 5/17/2025

We have a direct client in Columbus, Ohio who is seeking an experienced and highly skilled Senior Data Modeler to join their data engineering team.

REMOTE!

Must be able to work on our direct payroll.

This role will be responsible for designing and implementing data models to drive analytics, reporting, and data-driven decision-making. The ideal candidate will have hands-on experience with industry-standard data modeling methodologies (Kimball, Inmon, Data Vault 2.0) and have applied them in modern data architectures, including Medallion Architecture on Databricks for Delta Live Tables (DLT). You will work closely with business stakeholders to gather requirements and create effective data flows that support enterprise-level data solutions.

Key Responsibilities

  • Data Modeling : Develop, implement, and maintain high-quality data models using methodologies such as Kimball (dimensional), Inmon (3NF), and Data Vault 2.0, tailoring each approach to fit specific business use cases.
  • Medallion Architecture : Design and optimize data models following the Medallion Architecture (Bronze, Silver, Gold layers) on Databricks, particularly for Delta Live Tables (DLT) to facilitate data ingestion, transformation, and consumption.
  • Data Flow : Develop good understanding of existing data flows and pipelines.
  • Stakeholder Engagement : Partner with business stakeholders to understand their data needs and translate business requirements into robust data models and workflows.
  • Optimization and Performance : Continuously optimize models and workflows for performance, scalability, and reliability. Troubleshoot and resolve data and model-related issues to ensure efficient data processing.
  • Documentation and Best Practices : Develop and maintain detailed documentation for data models, data flows, and data governance processes, promoting best practices across the data modeling function.
  • Collaboration : Collaborate with data engineers, data analysts, and data scientists to integrate models seamlessly into the broader data platform, ensuring alignment with organizational data standards.

Required Qualifications

  • Minimum of 10 years in data modeling or data architecture roles, with a strong portfolio of designing and implementing data models across various methodologies (Kimball, Inmon, and Data Vault 2.0).
  • 2 years of Data Vault 2.0 experience is a must have
  • Technical Expertise :

  • Proven experience with Databricks, particularly in building and managing Delta Live Tables (DLT).
  • Proficient in Medallion Architecture (Bronze, Silver, Gold layers) and how it applies to scalable, modern data warehousing solutions.
  • Hands-on experience with data integration, data quality, and data transformation on cloud platforms (e.g., Azure, AWS, GCP).
  • Business Acumen : Demonstrated ability to work with business stakeholders to gather requirements, translate them into data models, and design data solutions that meet their needs.
  • Tools & Technologies :
  • Proficient with SQL, Python, and / or PySpark for data manipulation and modeling.
  • Familiarity with ETL / ELT tools, data warehousing platforms, and data modeling tools (e.g., ERwin, Lucidchart).
  • Soft Skills : Excellent communication, documentation, and interpersonal skills. Ability to work collaboratively in cross-functional teams.
  • Education :
  • Bachelor’s degree in Computer Science, Information Systems, or a related field. Advanced degrees or relevant certifications (e.g., CDMP, Databricks certification) are a plus.
  • Preferred Qualifications

  • Experience with data governance and data quality frameworks.
  • Familiarity with Agile methodologies and DevOps practices, including CI / CD pipelines for data engineering.
  • Knowledge of BI and data visualization tools (e.g., Power BI, Tableau) for downstream reporting.
  • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Sr. Data Modeler?

    Sign up to receive alerts about other jobs on the Sr. Data Modeler career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $81,769 - $104,543
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $103,228 - $139,671
    Income Estimation: 
    $103,228 - $139,671
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $170,841 - $219,163
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Revel IT

    Revel IT
    Hired Organization Address St. Louis, MO Full Time
    Our St. Louis, MO client is looking for intelligent, creative, motivated software developers to join their software team...
    Revel IT
    Hired Organization Address St. Louis, MO Full Time
    Our St. Louis, MO client is looking for intelligent, creative, motivated software developers to join their software team...
    Revel IT
    Hired Organization Address Columbus, OH Temporary
    Our direct client, located in Columbus, Ohio, has a 6 month contract need for a Procurement Analyst. The Procurement Ana...
    Revel IT
    Hired Organization Address Columbus, OH Full Time
    Job Description A Senior Data Engineer is needed for a contract-to-hire opportunity with our Columbus, Ohio client. Shou...

    Not the job you're looking for? Here are some other Sr. Data Modeler jobs in the Columbus, OH area that may be a better fit.

    Sr. Data Modeler and Analyst

    Cognizant North America, Columbus, OH

    Data Modeler

    TALENT Software Services, Columbus, OH

    AI Assistant is available now!

    Feel free to start your new journey!