Hiring: Solution Architect (Data Modeler) Company: Ampstek Location: St Louis, MO Job Posted Time: 2026-09-17 14:08:08 Employment Type: On-site Target Skills & Keywords : Data Warehouse, ELT, ETL, Snowflake About the job Required Skills: •Design end-to-end data architecture and solution architectures supporting enterprise business and technology initiatives. •Develop and maintain Conceptual, Logical, and Physical Data Models. •Translate business and functional requirements into scalable data models and technical solutions. •Define enterprise data structures, relationships, entities, attributes, keys, constraints, and data domains. •Design normalized and dimensional data models, including Star and Snowflake schemas. •Develop data models for operational systems, data warehouses, data lakes, and analytical platforms. •Partner cross-functionally with Data Engineers to ensure physical data models can be efficiently implemented through ETL/ELT pipelines. •Define data integration patterns between applications, databases, APIs, cloud platforms, and enterprise data stores. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!