Enterprise Data Architect & Data Modeler

Ampstek; St. Louis (MO); On-site; USD 120,000 - 180,000; Full time

Job summary

Ampstek is seeking an experienced Solution Architect / Data Modeler to design enterprise data solutions and lead data architecture for large-scale initiatives. The role focuses on conceptual, logical, and physical modeling and architecture leadership.

You will work with stakeholders, enterprise architects, data engineers, and analytics teams to translate requirements into scalable, secure architectures using ETL/ELT pipelines and cloud platforms. Onsite in St. Louis, MO.

Qualifications

• Experience designing enterprise data solutions and architecture.
• Proficiency in conceptual, logical, and physical data modeling.
• Strong knowledge of data integration patterns and ETL/ELT pipelines.
• Familiarity with cloud platforms and data governance practices.

Responsibilities

• 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 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.
• Collaborate with Data Engineers to implement physical data models via ETL/ELT pipelines.
• Define data integration patterns between applications, databases, APIs, cloud platforms, and data stores.
• Establish data architecture standards, modeling conventions, and best practices.
• Analyze systems and perform source-to-target data mapping and lineage analysis.
• Identify data-quality issues and opportunities for optimization.

Skills

Data modeling

Enterprise data architecture

Data governance

Data integration

Cloud platforms

Stakeholder collaboration

Tools

SQL

ETL tools

Data modeling tools

Job description

Ampstek is seeking an experienced Solution Architect / Data Modeler to design enterprise data solutions and lead data architecture for large-scale initiatives. The role focuses on conceptual, logical, and physical modeling and architecture leadership.

You will work with stakeholders, enterprise architects, data engineers, and analytics teams to translate requirements into scalable, secure architectures using ETL/ELT pipelines and cloud platforms. Onsite in St. Louis, MO.