Data Modeler

Role : Data Modeler

Location : Atlanta, GA -Hybrid

Duration : 12+ Months

Data Modeler - seeking an experienced, hands-on Enterprise Data Modeler to join our data organization in Atlanta, GA. This role focuses on enterprise data modeling, business analysis, and data architecture, supporting the design and delivery of scalable, high-quality data solutions across the organization.

The ideal candidate brings deep expertise in relational and dimensional data modeling, along with strong business engagement skills to translate complex data needs into well-structured models and requirements.

Experience with modern platforms such as Databricks and modeling tools like Erwin is essential. This role will play a key part in shaping Norfolk Southern’s enterprise data fabric, enabling a unified, trusted, and consistent view of data for analytics, reporting, and operational decision-making.

Responsibilities

* Lead the design and development of enterprise data models (conceptual, logical, and physical) across domains

* Partner with business stakeholders to elicit, analyze, and translate data requirements into scalable data models and BI/DW solutions

* Define and enforce data modeling standards, best practices, and governance processes, leveraging tools such as Erwin

* Serve as a central point of contact for enterprise data models, ensuring consistency, quality, and reusability

* Drive the development of Norfolk Southern’s enterprise data fabric, including alignment of models across systems and domains

* Collaborate with BI, analytics, and data platform teams to ensure models support reporting, dashboards, and advanced analytics use cases

* Participate in all phases of the BI/Data Warehousing lifecycle, including requirements, design, validation, and implementation support

* Coordinate with development teams and business users through design reviews, UAT, and validation processes

* Ensure data quality, integrity, and traceability across enterprise datasets

Skills:

Required Qualifications:

* 5+ years of experience in data modeling and/or data architecture (relational and dimensional)

* Strong expertise in entity-relationship modeling and dimensional design (star/snowflake schemas)

* Hands-on experience with data modeling tools such as Erwin

* Experience working with modern data platforms such as Databricks

* Advanced SQL skills (complex queries, data analysis, and validation)

* Proven ability to translate business requirements into data models and functional specifications

* Strong understanding of data warehousing, BI, and analytics concepts

* Experience with data testing and validation (unit, system, integration)

* Familiarity with SDLC methodologies and technical documentation practices

* Excellent communication, presentation, and stakeholder management skills Preferred Qualifications:

* Experience with data fabric, data mesh, or enterprise data architecture frameworks

* Knowledge of metadata management, data governance, and data quality frameworks

* Familiarity with ETL/ELT concepts and data integration patterns

* Experience with data virtualization or integration tools

* Prior experience in the transportation or logistics industry

Education

B.A./B.S. degree or equivalent work experience in computer science, information technology, business administration, engineering, or another relevant field