Data Modeler

Position: Data Modeler

Location: Columbus OH

All 5 Days Onsite

Job Requirements: 

·       We are seeking a Data Modeling developer responsible for Define entities, relationships, and keys (primary/foreign keys) and document cardinalities.

·   Able to specify table grain (row-level meaning) for each fact/event/feature table, create dimension tables with consistent codes, descriptions, and hierarchy attributes where applicable and create fact/event tables with measures, timestamps, and join keys to relevant dimensions/entities.

·       The role involves working closely with data engineers, architects, and business stakeholders to ensure data integration, transformation and loading processes within the cloud environment.

·       Define entities, relationships, and keys (primary/foreign keys) and document cardinalities, Specify table grain (row-level meaning) for each fact/event/feature table

·       Create dimension tables with consistent codes, descriptions, and hierarchy attributes where applicable, Create fact/event tables with measures, timestamps, and join keys to relevant dimensions/entities, Represent time using standard date/time fields and, when needed, effective start/end dates for history Standardize naming conventions, data types, units, and allowed values (domains) across models, Add metadata and documentation (field definitions, source system, refresh cadence, owner)Implement basic validation checks (nullability, uniqueness, referential integrity, value ranges), Design outputs for common access patterns (joins, filters, aggregations) used by OLAP and AI pipelines

·       Maintain versioning/change history for models and update downstream dependencies when schemas change, Optimize the models for performance of AI/BI use cases Good understanding of Databricks concepts.

·       Good understanding of tools like Erwin

Work Experience: 7-10Years

Alchemy: Transforming Your Professional Vision into Reality

Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we’ve positioned ourselves at the forefront of digitization and software modernization.

Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.

With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.

Alchemy – Connecting Talent with Opportunities (Diversity, Equity and Inclusion)