Data Modeler

Amicis Global; Charlotte (NC); On-site; USD 90,000 - 110,000; Full time

Job summary

Amicis Global in Charlotte, NC is seeking a Data Modeler to design conceptual, logical, and physical data models that support analytics and application design. You will work with stakeholders, document models, and align with enterprise data standards.

The role focuses on scalable data models for data warehouses, leveraging IBM IDA, Azure, and Databricks, and delivering data flow diagrams and design specifications for reliable reporting and integration across systems.

Qualifications

• Creates conceptual, logical, and physical data models to support analytics and application design.
• Experience with data modeling tools and database design principles.

Responsibilities

• Design, implement, and optimize data models for the data warehouse, ensuring alignment with business requirements.
• Work extensively with IBM IDA (InfoSphere Data Architect) to create logical and physical data models.
• Ensure that the data models are scalable, performant, and aligned with the organization's data strategy.
• Collaborate with data engineers to implement and maintain data models in Azure and Databricks environments.
• Translate business requirements into conceptual, logical, and physical data models, ensuring data quality and consistency across systems.
• Participate in data architecture and design discussions to ensure data modeling best practices are followed.
• Develop and maintain documentation of data models, data flow diagrams, and database design specifications.
• Work with stakeholders to ensure the data models support analytics, reporting, and data integration needs.
• Perform impact analysis of changes to existing models and collaborate with teams to assess the effects on downstream systems.
• Continuously improve and optimize data models to enhance performance and data accessibility.

Skills

Data modeling

Stakeholder communication

Documentation

SQL/Database design

Tools

IBM IDA InfoSphere Data Architect

Azure

Databricks

Job description

Title:

Data Modeler

Location

Charlotte, NC, 28202

Duration:

6 Months

Summary:

Creates conceptual, logical, and physical data models to support analytics and application design. Responsibilities: Work with stakeholders, document models, align with enterprise data standards. Skills: Experience with data modeling tools and database design principles.Description

Key Responsibilities

• Design, implement, and optimize data models for the data warehouse, ensuring alignment with business requirements.


• Work extensively with **IBM IDA (InfoSphere Data Architect)** to create logical and physical data models.


• Ensure that the data models are scalable, performant, and aligned with the organization's data strategy.


• Collaborate with data engineers to implement and maintain data models in **Azure** and **Databricks** environments.


• Translate business requirements into conceptual, logical, and physical data models, ensuring data quality and consistency across systems.


• Participate in data architecture and design discussions to ensure data modeling best practices are followed.


• Develop and maintain documentation of data models, data flow diagrams, and database design specifications.


• Work with stakeholders to ensure the data models support analytics, reporting, and data integration needs.


• Perform impact analysis of changes to existing models and collaborate with teams to assess the effects on downstream systems.


• Continuously improve and optimize data models to enhance performance and data accessibility.