ZipRecruiter

Log In

1

Kimball Schema Expert Jobs (NOW HIRING)

Atria Group LLC

Data Modeler

Dallas, TX

$54.25 - $70.25/hr

... schema designs. Basic Qualification: Experience with dimensional data modeling at an enterprise level. Expert level experience in ERWin 4.x data modeling Expert knowledge of Kimball and Inmon ...

DTCC

Data Modeling Senior Associate

Tampa, FL · On-site

$63.50 - $85/hr

... Kimball methodology. * Partner with business stakeholders, product teams, data engineers ... Expert-level proficiency with Erwin Data Modeler. * Extensive experience designing, implementing ...

Zoom

Software Engineer

San Jose, CA · On-site

$271K/yr

... schema mapping and natural-language query layers. * Designing and build data models (Kimball, Data ... Have expert proficiency in Python and advanced SQL, hands-on experience in cloud data warehouses or ...

Socket.dev

Software Engineer

San Jose, CA · On-site

$271K/yr

... schema mapping and natural-language query layers. * Designing and build data models (Kimball, Data ... Have expert proficiency in Python and advanced SQL, hands-on experience in cloud data warehouses or ...

Zoom

$271K/yr

... schema mapping and natural-language query layers. * Designing and build data models (Kimball, Data ... Have expert proficiency in Python and advanced SQL, hands-on experience in cloud data warehouses or ...

Globenet Consulting Corp

Senior Data Modeler

Lynnwood, WA · On-site

$50 - $55/hr

Expert proficiency with modeling tools such as Erwin, ER/Studio, and/or dbt. * Strong experience ... Kimball, Inmon) and Data Vault 2.0. * Advanced SQL skills for schema design, query optimization ...

Judge Group, Inc.

Sr. Data Architect

Washington, DC · On-site

$180K - $200K/yr

Design and implement conceptual, logical, and physical data models using Kimball dimensional ... Expert production experience with Army Vantage or Palantir Foundry, including pipelines, Ontology ...

V-CENTRIX-US LLC

Snowflake Data Engineer

Detroit, MI · On-site

$104K - $125K/yr

Expert-level proficiency in Snowflake, DataStage, and dbt (data build tool) . These are mandatory ... modeling, including Star Schema and Kimball methodology Experience in customer handling ...

next page

Showing results 1-20

All JobsKimball Schema Expert Jobs

Kimball Schema Expert information

See salary details

$58

$80

$91

How much do kimball schema expert jobs pay per hour?

As of Sep 13, 2026, the average hourly pay for kimball schema expert in the United States is $80.95, according to ZipRecruiter salary data. Most workers in this role earn between $74.76 and $88.46 per hour, depending on experience, location, and employer.

What are popular job titles related to Kimball Schema Expert jobs?

For Kimball Schema Expert jobs, the most frequently searched job titles are:

Infographic showing various Kimball Schema Expert job openings in the United States as of June 2026, with employment types broken down into 4% As Needed, 8% Full Time, 67% Part Time, and 21% Contract. Highlights an 93% Physical, 1% Hybrid, and 6% Remote job distribution, with an average salary of $168,372 per year, or $80.9 per hour.

Data Architect - Remote / Telecommute

Aliso Viejo, CA • Remote

CYNET SYSTEMS
IT Services • 501 - 1,000 employees
Learn more about CYNET SYSTEMSexternal

$45 - $50/hr

Contractor

Medical, Dental, Vision, Life, Retirement

Posted 18 days ago

Job description

Job Overview:

Pay Range: $45.00hr - $50.00hr

Requirement/Must Have:

  • 8+ years of experience in data architecture, data engineering, or enterprise database design.
  • Expert-level proficiency in Microsoft SQL Server including schema design, T-SQL, performance tuning, and high availability.
  • Demonstrated experience designing data warehouses and data marts using star/snowflake schemas and Kimball methodology.
  • Hands-on experience with Microsoft BI stack including SSRS, SSAS, SSIS, and Power BI.
  • Strong understanding of ETL/ELT design patterns and data pipeline architecture.
  • Experience with data governance, data cataloging, and metadata management.
  • Proficiency in data modeling tools such as Erwin, ER/Studio, or SQL Server Data Tools.
  • Strong verbal and written communication skills.
  • Ability to present architecture decisions to both technical and non-technical audiences.
  • Experience in healthcare data environments including claims processing, 835/834 EDI, eligibility, and enrollment.
  • Familiarity with Azure data services including Azure SQL Database, Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake.
  • Experience with HIPAA compliance and handling of PHI/PII data.

Responsibilities:

  • Lead the end-to-end design of enterprise data models, including conceptual, logical, and physical data models across OLTP and OLAP environments.
  • Define and enforce data standards, integration patterns, and interoperability strategies across multiple source systems, databases, and platforms.
  • Architect and oversee the design of data warehouses, data marts, and reporting layers that power BI dashboards, operational reports, and executive analytics.
  • Establish and champion data governance policies, data dictionaries, lineage documentation, and master data management strategies.
  • Guide and review ETL/ELT pipeline design and collaborate with developers on SSIS packages, stored procedures, and data transformation logic.
  • Conduct query and schema performance reviews and advise on indexing strategies, partitioning, and optimization for high-volume data environments.
  • Partner with application developers, business analysts, DBAs, and business stakeholders to translate business requirements into sound data architecture decisions.
  • Evaluate emerging data technologies and contribute to the organization’s data platform roadmap, including cloud migration strategies.
  • Maintain authoritative architecture documentation, ERDs, data flow diagrams, and standards guides.
  • Provide technical leadership and mentorship to database developers and analysts.

Nice to Have:

  • Experience with Azure SQL Database.
  • Experience with Azure Data Factory (ADF).
  • Experience with Azure Synapse Analytics.
  • Experience with Azure Data Lake.
  • Experience with Cloud Data Migration & Modernization.

Skills:

  • Data Architecture.
  • Enterprise Data Modeling.
  • Data Strategy & Governance.
  • Microsoft SQL Server.
  • T-SQL.
  • Schema Design.
  • Performance Tuning.
  • High Availability (HA/DR).
  • Data Warehousing.
  • Star Schema.
  • Snowflake Schema.
  • Kimball Methodology.
  • ETL/ELT Architecture.
  • Data Pipelines.
  • Microsoft BI Stack.
  • SSIS.
  • SSRS.
  • SSAS.
  • Power BI.
  • SQL Query Optimization.
  • Indexing.
  • Partitioning.
  • Metadata Management.
  • Data Cataloging.
  • Master Data Management (MDM).
  • Enterprise Integration Patterns.
  • EDI Integration.
  • Erwin.
  • ER/Studio.
  • SQL Server Data Tools.
  • Architecture Documentation.
  • ERDs.
  • Data Flow Diagrams.

Qualification And Education:

  • 8+ years Data Architecture and Enterprise Data Modeling experience.
  • 8+ years Microsoft SQL Server and T-SQL experience.
  • 5+ years Data Warehousing and Kimball Methodology experience.
  • 5+ years ETL/ELT Architecture experience.
  • 5+ years Microsoft BI Stack experience.
  • 4+ years Data Governance and MDM experience.
  • 3+ years Healthcare Domain experience including Claims and EDI.

Benefits:

Our Benefits Include:

  • Medical, Dental, and Vision Insurance
  • 401(k) Retirement Plan
  • Health Savings Account (HSA)
  • Disability Insurance (Short-Term and Long-Term)
  • Life and AD&D Insurance
  • Paid Sick Leave (where required by applicable state or local law)
  • Supplemental Insurance Plans
  • Identity Theft Protection
  • Pet Insurance
  • Employee Wellness Programs
  • Employee Assistance Program (EAP)
  • Career Growth and Professional Development Opportunities

Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws.


About Cynet Systems


Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.

As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.

Cynet Systems logo

About Cynet Systems

Sourced by ZipRecruiter

Cynet Systems Inc is a staffing and recruiting corporation nestled in Ashburn, VA, USA. Established in 2010, the company operates within the Information Technology and Services sector, specializing in providing effective workforce solutions to different business needs, including IT consulting, direct hire, and contract staffing services. Through the years, Cynet Systems has built an impressive portfolio, going beyond borders and expanding its operations internationally in Canada and India. Rooted in its core values of teamwork, leadership, and commitment, Cynet Systems helps businesses unlock their full potential by providing versatile and competent professionals that perfectly align with their needs. Fueled by their unwavering mission to deliver top-tier talent to businesses worldwide, Cynet Systems garnered various recognitions including SIA's fastest-growing staffing firms and Best Place to Work in Virginia for 2019.

Industry

It services

Company size

501 - 1,000 Employees

Headquarters location

Sterling, VA, US

Year founded

2010

Social media

Twitter

View All Cynet Systems Jobs