Workday Data Engineer

Description

The Workday Data Engineer will develop, maintain, and optimize data pipelines Hamilton College’s Workday enterprise cloud application. This role will integrate data from various campus systems into a central data lake and warehouse for reporting, analytics, and system interoperability. This role requires expertise in data integration, transformation, and governance to ensure high-quality, accessible, and secure data across the institution.

The ideal candidate will have: 

• a minimum of one year demonstrated Workday API integration, EIB, Workday Studio, and RaaS custom report experience,
• ETL and/or iPaaS solution knowledge,
• data warehouse skills, and
• a strong commitment to customer relationships

This is a full-time, exempt, fixed term position ending on June 30, 2028, with a pay rate of $95,000.

Responsibilities

• Data Integration & Management
  • Develop and maintain data pipelines for efficient data movement across enterprise systems, data warehouses, and data lakes.
  • Implement batch and real-time data integrations using ETL and iPaaS solutions.
  • Design and manage data structures for optimized storage, retrieval, and reporting.
  • Maintain cloud-based and/or on-premises integration platforms.
• Collaboration & Support
  • Partner with campus data analysts to ensure data availability and usability for reporting, analytics, and visualization.
  • Establish and manage interfaces between data repositories and analytics tools.
  • Provide guidance on connecting analytics software to institutional data sources.
  • Manage data access and security permissions.
• Data Governance & Security
  • Support enterprise-wide data governance initiatives to improve data quality and ensure compliance with security policies.
  • Assist in the implementation of data protection strategies, governance frameworks, and standardization efforts.
• Technology & Innovation
  • Stay informed of emerging data technologies, tools, and best practices to enhance institutional data capabilities.
  • Recommend improvements for data management strategies and technical infrastructure.

Qualifications

Bachelor’s Degree or equivalent experience working with data structures and integration technologies. An advanced degree or certifications in a related field is a plus.

Knowledge, Skills, and Abilities

• Required Qualifications
  • A minimum of one year of experience with Workday integrations, business objects, APIs, custom reports, EIBs, and Workday Studio.
  • Proficiency in data warehousing technologies such as Snowflake, AWS, or other enterprise solutions.
  • Hands-on experience with SQL-based databases, including schema development.
  • Strong knowledge of integration technologies, including APIs, Web Services, and JDBC/ODBC connectors.
  • Proficiency in ETL/ELT processes and iPaaS solutions.
  • Programming experience with SQL, Python, XML, and XSLT.
  • Familiarity with data formats such as JSON, XML, CSV, and XLSX.
  • Ability to manage multiple priorities.
  • Strong problem-solving, communication, and collaboration skills.
  • Project management (Agile preferred) and project management software experience, e.g., Asana
  • Commitment to customer service and the ability to explain technical concepts to non-technical stakeholders.
  • Willingness to learn and adapt to evolving technologies.
• Preferred Qualifications
  • Advanced degree or certifications in data engineering, cloud computing, or a related field.
  • Experience with cloud data platforms and serverless computing.
  • Familiarity with data governance frameworks and compliance standards (e.g., GDPR, FERPA).

Application Instructions

Please submit a cover letter, resume and contact information for three professional references. Consideration of candidates will begin immediately and continue until the position is filled.

Equal Employment Opportunity Statement

Hamilton College is an Affirmative Action, Equal Opportunity employer and encourages diversity in all areas of the campus community.

Hamilton College complies with all federal and state laws including publishing and making available its Annual Security Report. The report includes statistics for the previous three years concerning reported crimes and institutional policies addressing campus security. To obtain a copy of this report contact the Director of Campus Safety or visit: www.hamilton.edu/annualsecurityreport