[Hiring] Data Modeler @Cornell University

Role Description

The Data Modeler (CEMI) serves as a senior individual contributor responsible for the design, development, and maintenance of enterprise data models and analytics solutions supporting institutional reporting and decision-making.

• Lead the design of dimensional data models, data warehouses, and data marts.
• Translate complex business requirements into scalable, high-performance data structures.
• Analyze source data structures and business processes to build fact and dimension tables in a database.
• Work with SQL and understand database fundamentals.
• Involved with testing and validation of both data and models.
• Collaborate with business stakeholders, data architects, developers, and analysts to define requirements and design solutions.
• Ensure data quality and usability across reporting platforms.
• Function as a technical authority and subject matter expert, guiding data design standards and mentoring peers.
• Ensure solutions align with enterprise architecture and performance expectations.
• Work is highly complex, involving multiple systems (e.g., ERP, data lake environments).
• Requires advanced analytical, technical, and problem-solving capabilities.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• 5–7 years of relevant experience, or equivalent combination of education and experience.
• Demonstrated expertise in:
  • Dimensional data modeling (fact/dimension design).
  • Data warehousing, data marts, and data architecture.
  • SQL development, query optimization, and data profiling.
  • Source-to-target mapping and ETL processes.
  • Translating business requirements into technical data solutions and models.
  • Understanding of data structures, relationships, and database design principles (PK/FK, schemas).
  • Working across complex, multi-system environments (ERP, analytics platforms, etc.).
  • Leading design sessions and facilitating requirements gathering.
  • Analyzing and solving complex problems and developing scalable and efficient data solutions.
  • Communicating technical concepts to non-technical stakeholders.
  • Mentoring or providing technical guidance to peers.
  • Managing multiple priorities in a fast-paced, evolving environment.
  • Cultivating and developing inclusive working relationships with students, faculty, staff, and community members.

Requirements

• Experience with BI and analytics tools (e.g., Power BI, Tableau, OBIEE).
• Experience with ERP systems (e.g., Workday, PeopleSoft, SAP, Oracle).
• Experience in higher education or similarly complex organizational environments.
• Familiarity with data lake architectures and modern analytics ecosystems.
• Experience developing data modeling standards and documentation.

Benefits

• Comprehensive health care options.
• Generous retirement contributions.
• Access to wellness programs.
• Employee discounts with local and national retail brands.
• Health and personal leave, three weeks of vacation, and 13 holidays.
• Two additional floating holidays for observing faiths and traditions.
• Tuition-free Extramural Study and Employee Degree Program.
• Tuition aid for external education.
• Cornell Children's Tuition Assistance Program.