Apply on Employer Site

PSI (Proteam Solutions) · 15 hours ago

Data Modeler

Columbus, Ohio Metropolitan Area

Contract

Hybrid

Senior Level, Lead/Staff

$80/hr - $97/hr

10+ years exp

PSI (Proteam Solutions) is seeking a highly experienced Data Modeler to design and implement enterprise-grade data solutions. The role involves deep expertise in data modeling principles and data architecture frameworks, ensuring scalability and performance in alignment with business needs.

CRMInformation Technology

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

Qualification

Data modeling principlesData architecture frameworksGoogle BigQueryDatabricksSQLETL/ELT frameworksMedallion architectureData governanceMetadata managementMaster data managementPerformance tuningQuery optimizationData securityCompliance standards

Required

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

Preferred

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

Company

PSI (Proteam Solutions)

Established in 1992, PSI (Proteam Solutions Inc) has grown from a one man start up to a multi-million dollar IT Consulting, Workforce Solutions and Enterprise Resource Solutions firm providing senior-level consulting and talent management solutions to both the Private and Public Sector.

Founded in 1992

Columbus, Ohio, USA

11-50 employees