Data Modeler (CEMI)

Cornell University • Ithaca, NY • 7h ago

Working Title: Data Modeler (CEMI) [Remote] [2 Year Term] No Visa Sponsorship is available for this position. This is a two (2) year term appointment which may be ended or extended based on organizational needs, funding availability, and performance. About Information Technology @ CornellInformation 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 daytoday needs to large, complex initiatives that advance major academic, research, and operational objectives across the university. Check out this link to find out more about IT@Cornell. 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. 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 principl

Similar Jobs

Weld Prep Technician II

Core & Main LP • Moravia, NY • 1d ago

IT & Engineering

Based in St. Louis, Core & Main is a leader in advancing reliable infrastructure with local service, nationwide. As a specialty distributor with a focus on water, wastewater, storm drainage and fire protection produc...

1d ago

Go to Apply

Technician II Duck Lab

Cornell University • Ithaca, NY • 1w ago

IT & Engineering

The Cornell University College of Veterinary Medicine seeks a detail-oriented and collaborative professional to join the Duck Research Laboratory in Eastport, Long Island. This position plays an important part in maintai...

1w ago

Go to Apply

Field Technician

Charter Communications • Ithaca, NY • 2w ago

IT & Engineering

This role requires the ability to work lawfully in the U.S. without employment-based immigration sponsorship, now or in the future. Shift- Tuesday-Saturday 12pm-9pm shift (one hr. lunch daily) Earn $20.50/hour, with the...

2w ago

Go to Apply

Facilities Designer II Senior Electrical Designer

Cornell University • Ithaca, NY • 2w ago

IT & Engineering

The Cornell University campus is widely admired as one of the world's most beautiful academic settings. The Division of Facilities and Campus Services is committed to providing the highest quality service to faculty, stu...

2w ago

Go to Apply

Senior Systems Administrator - IT

Racker • Ithaca, NY • 3w ago

IT & Engineering

Overview We are seeking an experiencedSystems Administratorto own the day-to-day operation, security, and reliability of our Windows-based, hybrid-cloud IT environment. This is a hands-on senior role responsible for Acti...

3w ago

Go to Apply

Pottery Decorating Associate

MacKenzie-Childs, LLC • Aurora, NY • 6h ago

Description Company Overview: MacKenzie-Childs is a leading home furnishings retail company known for its unique design, high-quality products and exceptional customer service. We specialize in offering a wide range of k...

6h ago

Go to Apply

Research Administration Assistant

Cornell University • Ithaca, NY • 13h ago

Management & Administrative

The Pre-Award Research Operations (PRO) team in the Office of Sponsored Programs (OSP) provides centralized pre-award grant proposal preparation and support for Principal Investigators (PIs) across a variety of colleges...

13h ago

Go to Apply

Yard & Tank Laborer

Suit-Kote • Watkins Glen, NY • 1d ago

Manufacturing & Warehouse

Job Title: Yard & Tank Laborer Overview: Suit-Kote Corporation, a leading Asphalt products manufacturer, road construction and maintenance and asphalt application engineering company is seeking candidates for a Yard...

1d ago

Go to Apply

AI Literacy Librarian

Cornell University • Ithaca, NY • 1d ago

Management & Administrative

Are you someone with an interest in designing instruction which will optimize how we learn in an AI-infused world? If so, we invite you to consider this exciting opportunity at Cornell University Library. The Teaching &a...

1d ago

Go to Apply

Part time Sales Manager

Michaels • Ithaca, NY • 1d ago

Management & Administrative

Store - ITHACA, NY The Sales Manager leads and champions a high-performing selling culture across the store, driving strong sales results and an engaging customer experience. This role oversees front-end and service oper...

1d ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)