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.
  

Area Representative and Type Traits Appraiser

Reports to Executive Secretary and Director of Field Services

Location:  Area Representative serving the states of Arizona, California, Oregon, and Washington. Type Traits Appraiser varies based on schedules. Reside in California.
  

Objective: Provide direct service to customers utilizing programs and services of the Jersey organizations and market same to potential customers.  Provide accurate evaluations and effective service to herd owners as member of the appraisal staff for the AJCA linear type evaluation program.
  
Share this job  
  

RESPONSIBILITIES: 

• Provide service as needed to dairy producers and milk processors utilizing AJCA-NAJ programs and services.
• Serve as an appraiser for the AJCA linear type appraisal program.
• Market AJCA-NAJ programs and services to potential customers.
• Plan and carry out direct marketing activities for USJersey programs and products, such as REAP, JerseyMate and JerseyTags.
• Respond to and follow up on sales inquiries by telephone, email and/or personal visit in a timely manner.
• Serve as a cattle marketing agent through Jersey Marketing Service
• Represent the Jersey organizations and the Jersey breed at various activities and functions.
• Promote the advantages of the Jersey breed and Jersey milk to dairy producers and dairy industry support organizations.
• Serve as liaison between customers and management.  Provide field information to management.
• Monitor and report on activities and provide relevant management information to improve services, delivery of services and customer satisfaction.
• Establish a good working relationship with Jersey leaders in the area.

PLACEMENT STANDARDS:

College graduate with a degree in the field of agriculture or equivalent experience. Dairy production background is desired. Must be a self-starter and demonstrate ability to work with a minimum amount of direct supervision. Must be willing to travel extensively, have broad knowledge of the dairy industry and excellent communication skills.  Above all, must have the ability to work well with people in a wide variety of situations.

Contact:  Frequent contact by telephone, e-mail and in person with dairy producers and dairy industry personnel.
  

Working Conditions: 

Position requires frequent travel for extended periods of time with overnight stays.  When not traveling, would use home as office.  Evenings, weekends, and holidays would be required to carry out the responsibilities.
  

Salary: Commensurate with experience.  Company vehicle provided and travel expenses are reimbursed.  Employee benefit package available.
  

Part-Time Type Traits Appraiser

Reports to Executive Secretary and Director of Field Service

Objective: Provide accurate evaluations and effective service to herd owners as member of the appraisal staff for the AJCA linear type evaluation program.

Location:  Nationwide, on-site

  
Share this job  
  

RESPONSIBILITIES: 

• Serve as an appraiser for the AJCA linear type program.
• Provide service as needed to dairy producers and milk processors utilizing AJCA-NAJ programs and services.
• Market AJCA-NAJ programs and services to potential customers.
• Serve as a cattle marketing agent through Jersey Marketing Service
• Represent the Jersey organizations and the Jersey breed at various activities and functions.
• Promote the advantages of the Jersey breed and Jersey milk to dairy producers and dairy   industry support organizations.
• Serve as liaison between customers and management.  Provide field information to management.
• Establish a good working relationship with Jersey leaders in the area.

PLACEMENT STANDARDS:

College graduate with a degree in the field of agriculture or equivalent experience. Dairy production background is desired. Must be a self-starter and demonstrate ability to work with a minimum amount of direct supervision. Must be willing to travel extensively, have broad knowledge of the dairy industry and excellent communication skills.  Above all, must have the ability to work well with people in a wide variety of situations.

Contact:  Frequent contact by telephone, e-mail and in person with dairy producers and dairy industry personnel.
  

Working Conditions: 

Position requires frequent travel for extended periods of time with overnight stays. When not traveling, would use home as office. Evenings, weekends, and holidays would be required to carryout the responsibilities.
  

Salary: Commensurate with experience.  Travel expenses are reimbursed.