Data Modeler (CEMI)

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. What will you do: 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. This position leads the design of dimensional data models, data warehouses, and data marts, translating complex business requirements into scalable, high-performance data structures. This position will analyze source data structures and business processes from which they will build fact and dimension tables in a database. This role requires ability to work with SQL and to understand database fundamentals. This role will also be involved with the testing and validation of both data and models. The role works collaboratively with business stakeholders, data architects, developers, and analysts to define requirements, design solutions, and ensure data quality and usability across reporting platforms. The Data Modeler 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. Work is highly complex, involving multiple systems (e.g., ERP, data lake environments) and requires advanced analytical, technical, and problem-solving capabilities. This is a two (2) year term appointment which may be ended or extended based on organizational needs, funding availability, and performance. While position responsibilities vary, every member of our community is expected to foster 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. Required Qualifications: 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. Preferred Qualifications: 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 Application Information: A resume is required for further consideration for this position. A cover letter expressing alignment with Cornell's mission and this role is strongly encouraged. When applying through our system, please remember to attach your application materials (Cover Letter and Resume) in PDF format. No Visa Sponsorship of any kind is available for this position. No Relocation assistance will be provided for this position . Rewards and Benefits University Job Title: Business Intelligence Eng IV Job Family: Information Technology Level: G Pay Rate Type: Salary Pay Range: $114,698.00 - $140,186.00 Remote Option Availability: Remote Company: Contact Name: Maria Avila Contact Email: mia28@cornell.edu Job Titles and Pay Ranges: Non-Union Positions Noted pay ranges reflect the potential pay opportunity for each job profile. The hiring rate of pay for the successful candidate will be determined considering the following criteria: Prior relevant work or industry experience Education level to the extent education is relevant to the position Unique applicable skills Academic Discipline Union Positions Current Employees: Online Submission Guidelines : Employment Assistance: Notice to Applicants: EEO Statement: Cornell welcomes students, faculty, and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities, to further the founding principle of "... any person ... any study." No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving, but not limited to, such factors as race, ethnic or national origin, citizenship and immigration status, color, sex, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual's genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law. Cornell University embraces diversity in its workforce and seeks job candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We hire based on merit, and encourage people from historically underrepresented and/or marginalized identities to apply. Consistent with federal law, Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans' Readjustment Assistance Act (VEVRAA) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law. 2026-06-10