Parentage Qualification Coordinator & Herd Services Assistant

Reports to Herd Services Manager and Assistant Herd Services Manager

Located in Reynoldsburg, Ohio

Objective: Coordinate Qualification Program, process tag orders and records. To provide support to Herd Services and Genetic Programs.
  
Share this job  
  

RESPONSIBILITIES: 
 

Parentage Qualification Program

• Coordinate all aspects of the Parentage Qualification Program (including, but not limited to marketing and ordering of Micro-Satellite/DNA and genomic testing);
• Provide customer service for genomic test customers (including, but not limited to distribution of genomic test forms/kits and genomic test results);
• Process and input test results into the AJCA database.
• Resolve parentage qualification issues/conflicts.
• Provide follow-up for animals requiring parentage qualification not yet complete.
• Provide required documentation to export Jersey genetics as requested by AI companies, export organizations and foreign country herdbooks.
• Obtain required documentation for imported Jersey genetics.
  
   

Herd Services

• Fully integrated in all aspects of marketing and ordering JerseyTags, along with servicing JerseyTag customers.
• Process registrations and transfers.
• Issue new customer numbers and process updates.
• Process membership applications.
• Process NAAB stud code additions and updates.
• Assist with mailings as needed.

Other

• Provide switchboard assistance as needed.
• Provide mailroom assistance as needed.
• Other miscellaneous duties as instructed.

Placement Standards: Well-organized, self-motivated and detail-oriented individual possessing general office knowledge and computer skills including, but not limited to, word processing, spreadsheets and data base experience.  General knowledge of agriculture and/or the dairy industry a plus.  Willingness and ability to learn new computer applications.  Must be able to communicate effectively with customers.  Ability to multi-task. 

Working Conditions: 

1. Normal office hours:  Monday through Friday, 8:00 a.m. – 4:30 p.m.
2. Employee offered 30-minute lunch and two (2) 15-minute breaks.
3. Employer offers a smoke-free environment.

Database Developer and Analyst

Reports to IT Manager

Objective: Maintain and implement data storage policies, design, programming, construction of new databases, procedures, and existing platform updates.
  
Share this job  
  

RESPONSIBILITIES: 
 

• Run routine database analysis reports and implement changes to improve database effectiveness and efficiency.
• Prepare and process datasets for exchange with CDCB, Dairy Record Processing Centers, dairy industry partners and AJCA customers.
• Update data export and import procedures as needed to accommodate changes to the data requirements and file specifications.
• Thoroughly test all new and updated data export and import procedures to ensure that the integrity of the AJCA data is maintained.
• Design and develop database queries for custom data requests by AJCA staff and customers.
• Design and develop custom reports for AJCA staff and customers.
• Maintain and update AJCA SQL data table structure as needed.
• Add appropriate tables and views to the AJCA SQL database as needed to support new programs.
• Maintain and develop new SQL stored procedures needed for new functionality.
• Maintain and develop new SQL Integrated Services (SSIS) packages for efficient processing of large datasets.
• Assist AJCA staff with Microsoft Access setup, and query design to meet their routine data needs
• Routinely document changes and processes including labeling and categorizing for easy retrieval, long term strategies and to be used for adhering to project requirements.

QUALIFICATIONS:

• Bachelor's degree in Computer Science, Computer Programming, or other related IT fields.
• Proficient knowledge of SQL and Access databases.
• Strong relational database skills
• Create high quality and optimized stored procedures and reports.
• Proficient knowledge working with Excel spreadsheets, CSV files and Office 365 Products.
• Knowledge of how to efficiently prepare datasets to be used with database import processes and procedures.

Competencies

• Teamwork – work effectively with other team members to meet deadlines and share knowledge to accomplish an overall goal.
• Problem Solving – Identify problems faced by the organization and make adequate changes and/or suggestions to management staff.
• Dependability – Be reliable, responsible, and dependable on fulfilling assigned duties and obligations.
• Communication – Effective verbal and written communication skills to interact in a clear and concise manner with AJCA staff and customers.

Working Conditions: 

Full-time position based in an office setting in Reynoldsburg, Ohio.  Will have frequent contact and work closely with customer IT staff, USJersey employees, allied industry, and customers. Availability to work a flexible schedule that will occasionally include extended weekday and weekend hours to meet project deadlines and carry out responsibilities.

Salary: Commensurate with qualifications. Employee benefit package available.
  

Senior Accounting Clerk

Reports to Treasurer

Objective: To assist with all operations of the Accounting Department.  Assist in maintaining financial records, general analysis, as well as many day-to-day functions of the department.
  
Share this job  
  

RESPONSIBILITIES: 
Provide assistance to the Treasurer and/or be responsible for the follow areas:

• General Ledger;
• Accounts receivable.  Including, but not limited to deposits, customer account maintenance and invoicing, monthly statements, credit balances, delinquent accounts and letters, written-off accounts, etc.;
• Accounts payable;
• Payroll;
• Bank reconciliations;
• Jersey Marketing Service – private treaty, public sales, royalties, analysis, etc.;
• 1099 processing;
• State Sales tax;
• Assist with human resource management;
• Analysis and reports for departments and ledgers as requested;
• Equity Membership Data Base;
• Work with supply vendors and office equipment vendors (ie. copier, mail machine, suppliers, etc.);
• Back-up various duties within the responsibilities of the accounting department (which also may include receptionist and mail room);
• Assist with general office maintenance/management;
• Special projects;
• Other miscellaneous duties as requested by the Treasurer or Executive Secretary.

PLACEMENT STANDARDS:

Associate degree in accounting or equivalent experience. Must have excellent understanding of all aspects of accounting procedures.  Must demonstrate excellent skills in time management, computerized accounting, spreadsheets, word processing, Access, (Office Suite), plus be familiar with general office machines.  Position requires individual initiative, attention to detail and professional, administrative and organizational skills. Must be organized to meet deadlines.  Position requires frequent contact with staff, members and dairy industry professionals.  Strong written and oral communication skills. Ability to multi-task.  General knowledge of agriculture and/or dairy industry a plus but not required.
  

Working Conditions: 

Full-time position.  Works in an office setting. Occasional evenings, weekends or holidays may be required to carry out responsibilities.
  

Salary: Commensurate with qualifications. Employee benefit package available.