Senior Data Modeler – Remote Enterprise Analytics

Cornell University; Ithaca (GA); Remote; USD 115,000 - 140,000; Full time

Job summary

Cornell University is seeking a Data Modeler (CEMI) to design, develop, and maintain enterprise data models and analytics solutions that support institutional reporting and decision-making. The role focuses on dimensional modeling, data warehouses, and data marts, translating complex business requirements into scalable data structures.

Collaboration with stakeholders ensures data quality and performance. The position supports ERP and analytics platforms, requires strong SQL and data architecture

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• 5–7 years of relevant experience or equivalent.
• Experience designing dimensional data models (fact/dimension) and data warehouses.
• Strong SQL development, query optimization, and data profiling skills.
• Experience translating business requirements into technical data solutions and models.

Responsibilities

• Design, develop, and maintain enterprise data models, data warehouses, and data marts.
• Translate complex business requirements into scalable data structures and solutions.
• Collaborate with stakeholders, data architects, developers, and analysts to ensure data quality and usability across reporting platforms.
• Lead design discussions, guide requirements gathering, and mentor peers.

Skills

Dimensional data modeling

Data warehousing

SQL development

Source-to-target mapping

ETL

Stakeholder comms

Education

Bachelor’s degree in CS/IS/Engineering or related field

Tools

Power BI

Tableau

OBIEE

Workday/PeopleSoft/SAP/Oracle ERP

Job description

Cornell University is seeking a Data Modeler (CEMI) to design, develop, and maintain enterprise data models and analytics solutions that support institutional reporting and decision-making. The role focuses on dimensional modeling, data warehouses, and data marts, translating complex business requirements into scalable data structures.

Collaboration with stakeholders ensures data quality and performance. The position supports ERP and analytics platforms, requires strong SQL and data architecture