Data Modeler (CEMI)
About The Position
Cornell Information Technology (IT) is a strategic enabler for many functions at Cornell University, with staff located across colleges, administrative units, and campuses throughout the institution. While comprised of many organizations, IT operates as one partnering closely with faculty, staff, and students to support teaching, research, and business operations. By being embedded where the Cornell community is, IT is well positioned to provide support ranging from day‑to‑day needs to large, complex initiatives that advance major academic, research, and operational objectives across the university. The Data & Analytics function supports enterprise reporting and decision-making by integrating data from ERP systems and other institutional sources into a centralized data environment. The team develops scalable data models, analytics solutions, and reporting tools that enable business units across the university to efficiently access, interpret, and act on data.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field and 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
- Experience translating business requirements into technical data solutions and models
- Strong understanding of data structures, relationships, and database design principles (PK/FK, schemas)
- Experience working across complex, multi-system environments (ERP, analytics platforms, etc.)
- Ability to lead design sessions, facilitate requirements gathering, and guide technical solutions
- Demonstrated ability to analyze and solve complex problems and develop scalable and efficient data solutions
- Communicate technical concepts to non-technical stakeholders
- Experience mentoring or providing technical guidance to peers
- Ability to manage multiple priorities in a fast-paced, evolving environment
- Ability to cultivate and develop inclusive working relationships with students, faculty, staff, and community members.
Nice To Haves
- 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
Responsibilities
- 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.
- Leads the design of dimensional data models, data warehouses, and data marts, translating complex business requirements into scalable, high-performance data structures.
- Analyzes source data structures and business processes from which they will build fact and dimension tables in a database.
- Involved with the testing and validation of both data and models.
- Works collaboratively with business stakeholders, data architects, developers, and analysts to define requirements, design solutions, and ensure data quality and usability across reporting platforms.
- Functions as a technical authority and subject matter expert, guiding data design standards, mentoring peers, and ensuring solutions align with enterprise architecture and performance expectations.
- Fosters a culture of belonging and a healthy work environment by communicating across differences; being cooperative, collaborative, open, and welcoming; showing respect, compassion, and empathy; engaging and supporting others regardless of background or perspective; speaking up when others are being excluded or treated inappropriately; and supporting work/life integration of oneself and others.
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
- 13 holidays: Martin Luther King, Jr. Day, Memorial Day, Juneteenth, Independence Day, Labor Day, Thanksgiving and the day after, and an end of the year winter break from December 25-January 1.
- Two additional floating holidays
- Tuition-free Extramural Study and Employee Degree Program
- Tuition aid for external education
- Cornell Children's Tuition Assistance Program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
