EEO/AA Data Analyst

Job description

Posting Details

Position Information

Job Category Support Staff Position Title EEO/AA Data Analyst Full Time/Part Time Full Time Division Office of the President Department President's Office Department Statement

Colgate University is committed to recruiting and retaining a talented diverse workforce and recognizes diversity is integral to the University’s achievement of excellence, as it enhances the ability of the University to accomplish its academic mission and to foster a respectful, equitable work environment. The University’s Equal Opportunity (EEO)/Affirmative Action (AA) function affirms and promotes our commitment to equal opportunity and affirmative action and offers an exciting opportunity for an EEO/AA Data Analyst. Reporting to the Executive Director for EEO/AA, and Equity and Inclusion, this position will enhance the university’s data management and data systems necessary for the University’s EEO/AA federal regulatory and legal compliance.


This role will focus on data analysis related to equal employment opportunity, affirmative action, equity, and inclusion. It is accountable for:
•organizing and automating procedures for ongoing data management
•creating systems to analyze and reconcile workforce and personnel transaction data (either automated or manual), and where possible refining employment-related data sets
•aggregating, analyzing, and compiling information relevant to EEO/AA and other diversity, equity, and inclusion initiatives.
•assisting with the development and production of federally mandated EEO/AA related reports, such as the Vets2412 and the utilization and selection data of individuals with disabilities and protected veterans.
•creating detailed documentation of complex processes.

Technical Competencies

Name Data Entry, Data Collection, and Data Management Description

Demonstrated ability to transfer, retrieve, and/or update data either from paper formats into computer files or database systems or within existing computer files or database systems. Demonstrated ability to analyze multiple sources of data, manage web-based data collection processes, and develop methods to capture and store data. Demonstrated ability to work with demographic data, aggregate & disaggregate large data sets, accurately create complex spreadsheets, and verify data by comparing it to source documents.

Technical Competencies

Name Database and Other Technical Expertise Description

Demonstrated database software skills and the ability to access and understand multiple sources of data and databases to integrate and access data. Demonstrated proficiency in MS Office products, in particular advanced Excel skills such as pivot tables, vlookup and graphs. Demonstrated ability to design & build complex spreadsheets, pivot tables, & graphics in Excel & related software, conducting in-depth analysis on multiple sources of data, as well as combine and manipulate data for analysis and reporting. Ability to learn programming in relevant software and tools (SAS, SQL Server, Tableau, Qualtrics, etc.).

Technical Competencies

Name EEO/AA Description

Ability to learn applicable state and federal laws as they pertain to employment and EEO requirements, affirmative action reporting requirements and statistical methodologies, and EEO/AA programs. Must be able to work with highly confidential data and maintain confidentiality.

Technical Competencies

Name Process Improvement Description

Demonstrated ability to document complex processes. Demonstrated ability to highlight areas of process inefficiency and suggest potential process improvements.

Technical Competencies

Name Multicultural and Intersectional Knowledge Description

Understands and/or is willing to increase awareness of multiple cultural frameworks, values, and norms. Engages in on-going self-reflection. Recognizes and addresses one’s own filters, privileges, biases, and cultural preferences. Commits to continuous learning/improvement in diversity, inclusion, and cultural competence. Manages and mediates interpersonal conflict effectively. Demonstrates an ability to flex style when faced with myriad dimensions of culture in order to be effective across cultural contexts. Listens and adapts approach to fit audience. Earns the trust and respect of others.

Behavioral Competencies

Name Personal Accountability for Results Description

Takes responsibility for decisions, performance, and outcomes; behaves in a responsible manner with a positive attitude; shows self-awareness and openness to feedback.

Behavioral Competencies

Name Effective Communication Description

Demonstrates effective written and oral communication skills; communicates clearly and knowledgeably; shares information with others, seeks input from others; adapts communication to diverse audiences; protects private and confidential information.

Behavioral Competencies

Name Problem Solving and Decision Making Description

Analyzes and prioritizes situations to identify and solve problems; solutions increase efficiency and improve quality; involves others in solving problems and making decisions; factors organizational goals into decisions; makes clear, transparent, timely decisions.

Behavioral Competencies

Name Change Management Description

Responds positively to changing university initiatives and readily adapts behavior to maintain effective performance; understands the long term direction of the university and can relate this to one’s own departmental area; adapts to new methodologies, techniques and process steps for greater impact.

Behavioral Competencies

Name Leadership and Teamwork Description

Applies skills and knowledge to achieve department and organizational goals; helps others perform at their best; self-aware and open to feedback; adds value; high quality work, understands and supports organizational goals; builds wide sphere of influence to enhance individual and organizational effectiveness; builds productive working relationships; cooperates and collaborates with colleagues; treats others with respect; resolves conflicts among team members; balances individual and team goals.

Behavioral Competencies

Name Creativity and Innovation Description

Generates, explores, encourages, and implements innovative ways of creating strategic value for the university, division, department, and individual level; critically assesses the effectiveness of new initiatives.

Behavioral Competencies

Name Diversity and Inclusion Description

Demonstrates respect for people and their differences; understands the benefits of a diverse workforce; earns the trust and respect of others; includes and welcomes others; works to understand the perspective of others; promotes opportunities to experience diversity within our community.

Behavioral Competencies

Name Sustainability Description

Understands the impact of decision making and personal behavior in achieving the university’s commitment to a sustainable and carbon-neutral campus; supports and advances the university’s sustainability initiatives; influences others to use sustainable practices.


Professional Experience/ Qualifications

•Must be capable of working collegially with a diverse group of students, faculty, staff, and visitors on a daily basis.
•Must demonstrate multicultural competence, active listening, critical thinking, and interpersonal skills.
•Familiarity, or ability to quickly learn, functions of spreadsheets (e.g., Excel, Google Sheets).

Preferred Qualifications

•Knowledge of data concepts and automated production of reports.
•Willingness to work with automated/digital and non-automated/digital data sets.


•Bachelor’s degree in a relevant area, or three years of relevant work experience, or a combination of education and relevant work experience.

Certifications Physical Requirements Other Information

This full-time position carries benefits and is currently scheduled to end no later than June 30, 2020.

Posting Detail Information

Requisition Number 2019S078P Temporary Yes Work Schedule Job Open Date 06/07/2019 Job Close Date Open Until Filled Yes Special Instructions Summary EEO Statement

It is the policy of Colgate University not to discriminate against any employee or applicant for employment on the basis of their race, color, creed, religion, age, sex, pregnancy, national origin, marital status, disability, protected Veterans status, sexual orientation, gender identity or expression, genetic information, being or having been victims of domestic violence or stalking, familial status, or any other categories covered by law. Colgate is an Equal Opportunity/Affirmative Action employer. Candidates from historically underrepresented groups, women, persons with disabilities, and protected veterans are encouraged to apply.

Clery Act

The Campus Safety Department will provide upon request a copy of Colgate’s Annual Security and Fire Safety Report. This report includes statistics as reported to the United States Department of Education for the previous three years concerning reported: 1. crimes that occurred on-campus; in certain off-campus buildings or property owned or controlled by Colgate University; and on public property within, or immediately adjacent to and accessible from, the campus and 2. fires that occurred in student housing facilities. The report also includes institutional policies concerning campus security and fire safety, such as policies concerning sexual assault, life safety systems, and other related matters. To obtain a copy, contact William Ferguson, Clery Compliance Coordinator via e-mail at [email protected]. You may also access the report from the Campus Safety web page at:

Supplemental Questions

Required fields are indicated with an asterisk (*).

  1. * Are you currently a Colgate employee?
    • Yes
    • No
  2. * Have you ever been a Colgate employee?
    • Yes
    • No
  3. * Are you at least 18 years of age?
    • Yes
    • No
  4. * Please let us know how you heard about this position.
    • Albany Times Union
    • Binghamton Press & Sun
    • BlackCoachesinSports
    • Cazenovia Republican
    • Chronicle of Higher Education
    • Chronicle of Philanthropy
    • Colgate Employee
    • Colgate Website
    • CoSIDA
    • Diverse Issues of Higher Education
    • HERC (Upstate New York HERC)
    • LinkedIn
    • Mid-York Weekly
    • NACWA
    • naviGATE
    • NCAA News
    • Norwich Evening Sun
    • Oneida Daily Dispatch
    • Sherburne News
    • Syracuse Post Standard
    • Utica Observer Dispatch
    • Waterville Times
    • Other
  5. If you selected "Colgate Employee" or "Other" for how you heard about this position, please provide the employee's name or where you heard about/saw the position.

    (Open Ended Question)

Applicant Documents Required Documents
  1. Resume
  2. Cover Letter
Optional Documents




    Diversity Profile: University



    View more

    Learn more on Inside Higher Ed's College Page for University

    Arrow pointing right
    Job No:
    Posted: 6/22/2019
    Application Due: 7/15/2019
    Work Type: