Data Modeler (CEMI)

About the role

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.

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.
• Ledesigns dimensional data models, data warehouses, and data marts, translating complex business requirements into scalable, high-performance data structures.
• Develops scalable data models, analytics solutions, and reporting tools that enable business units across the university to efficiently access, interpret, and act on data.
• 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.
• Manages multiple priorities in a fast-paced, evolving environment.

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.
• Cultivate and develop inclusive working relationships with students, faculty, staff, and community members.

Qualifications

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

Skills

• SQL development, query optimization, and data profiling.
• Source-to-target mapping and ETL processes.
• 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.
• Strong communication skills, especially in explaining 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.
• Cultivate and develop inclusive working relationships with students, faculty, staff, and community members.

Benefits

This position is based in Ithaca, New York, however, the successful applicant may perform this role remotely anywhere within the United States. Employees who work remotely may receive multiple W-2 Forms depending on their work location. The New York Convenience of employer guidelines require New York State individual tax reporting and withholding for this position. Additional individual state income tax filings may also be required if working temporarily outside of New York State. The university reserves the right to modify, suspend, or terminate the remote or hybrid work arrangement at any time.

Pay

$114,698.00 - $140,186.00

Schedule

Full-time, 40 hours per week