Job Description
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.
- Leads the design of dimensional data models, data warehouses, and data marts.
- Translates complex business requirements into scalable, high-performance data structures.
- Analyzes source data structures and business processes to build fact and dimension tables in a database.
- Works with SQL and understands database fundamentals.
- Involved with the testing and validation of both data and models.
- Collaborates with business stakeholders, data architects, developers, and analysts to define requirements and design solutions.
- Ensures data quality and usability across reporting platforms.
- Functions as a technical authority and subject matter expert, guiding data design standards and mentoring peers.
- Ensures solutions align with enterprise architecture and performance expectations.
- Handles highly complex work involving multiple systems (e.g., ERP, data lake environments).
- Requires advanced analytical, technical, and problem-solving capabilities.
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.
- Supporting work/life integration of oneself and others.
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.
Job Tags
Full time, Local area