Database and Reporting Administrator

Description

Orion Industries offers workforce development services so that every individual has an opportunity to access a career. We offer hope and create paths to employment through building esteem, mentoring, training, education, community services and successful businesses. Every day we know we are part of something important. Revealing the potential in every person, and uplifting people experiencing barriers to employment.

Database

• Experience with Apricot or similar case management database system UX (user experience) customization.
• Assumes primary responsibility for ensuring case management software meets end user needs and reporting requirements.
• Understand underlying database structures and data flows for troubleshooting and resolving data issues related to data syncs, imports, system upgrades, customizations, etc.
• Experience with SQL, MySQL or similar querying languages
• Python knowledge is a plus
• Address technical challenges and provide input on process improvement for organizational performance, improving efficiency, and monitoring outcomes.
• Aptitude to dive into data, identify patterns and draw conclusions.
• Train end users on optimal use of reports and dashboards to support data driven business decisions.
• Develop a complete understanding of Orion’s employment services models including onboarding, goals and processes of each program, and reporting requirements of each program and associated grant.
• Lead Apricot Case Management Steering Committee: Engage with all relevant staff to ensure the system is being utilized to increase efficiencies.
• Provides database quality control; investigates and resolves data and reporting inconsistencies; develops and implements workflow, data entry, collection, and reporting procedures.
• Develops written documentation, internal operating procedures, and end user instructions. Trains and notifies staff of changes to data entry and operational policies and procedures and provides ongoing technical assistance.
• Responsible for user acceptance testing of system modifications.
• May serve as liaison with outside agencies on data analysis and reporting issues and needs
• Support the export of data from Orion’s current database and accesses / provides historical information upon request.
• Act as backup for IT (Information Technology) support tickets as needed.
• Works collaboratively with staff to discuss departmental/program goals; ensures the database provides the required information and is used to its fullest capacity.
• Strong written and verbal communication skills, with demonstrated ability to effectively communicate technical concepts to a diverse range of stakeholders.
• Acts as an organizational representative in all situations, setting a strong example of professionalism, work completion and quality, and commitment to organizational goals and ethics
• Self-motivated, hard-working team player with proven outstanding organizational skills and very detail oriented and ability to work independently and manage and prioritize multiple tasks at once and meet critical deadlines.
  
  

Reporting

• Assist in review of grant agreements, scopes of work and contracts to identify compliance requirements.
• Create a schedule of necessary reports and information to be reported to grantmaking agencies.
• Maintain a calendar of necessary reports and keep leadership apprised of upcoming obligations.
• Draft required reports based on collected information for services at each location.
• Coordinates with Billing/Finance Department
• Ensure timely delivery of necessary documentation to ensure grant compliance.
• Develop data collection templates to secure necessary information from relevant business lines.
• Support Managers in building reports for grant and program audits including DVR (Division of Vocational Rehabilitation), DDA (Developmental Disabilities Administration), CDBG (Community Development Block Grant) and CARF (Commission on Accreditation of Rehabilitation Facilities) certification.
  
  

Requirements

• Experience with Apricot or similar case management database system UX (user experience) customization.
• Understand database structures and data flows for troubleshooting and resolving data issues related to data syncs, imports, system upgrades, customizations, etc.
• Aptitude to dive into data, identify patterns and draw conclusions.
• Strong written and verbal communication skills, with demonstrated ability to effectively communicate technical concepts to a diverse range of stakeholders.
• Self-motivated, hard-working team player with proven organizational skills and attention to detail
• Ability to work independently, managing and prioritizing multiple tasks while meeting critical deadlines.
  
  

Wage Range

The pay range for this role considers several factors, including but not limited to required experience, skill level, prior training, education, and other business needs. Starting salary will near midpoint of range.

Other Duties

This job description contains a listing of activities, duties, or responsibilities that are required of the employee for this job at this moment in time. Activities, duties, or responsibilities may change at any time with or without notice.

Physical Requirements/Work Environment

The physical requirements/work environment described below represent those that an employee must meet to successfully perform the job's essential functions. Reasonable accommodation will be made to enable individuals with disabilities to perform the essential job functions.

• Frequent use of hands and fingers to reach, manipulate, handle, and hold material.
• Frequent use of vision abilities including close vision, distance vision, color vision, depth perception, and spatial relationship.
• Frequent use of hearing ability to receive detailed information through oral communication.
• Frequent use of speaking ability to express or exchange ideas, communicate detailed information, or convey instructions.
• Frequent lifting of 5 or 10 pounds
• Occasional exposure to manufacturing shop floor, requiring use of Safety Glasses.
• Infrequent exposure to excess noise levels, necessitating the use of Hearing Protection.
  
  

Benefits Offered

• 401(k) with a percentage company-match contribution
• Medical, dental, vision, voluntary life & ADD, accident, and critical illness insurances
• Company-paid life, ADD, and long term disability insurance
• Paid holidays
• Paid time off
• Employee Assistance Plan
  
  

ITAR (International Traffic In Arms Regulation) – US Person Status

Due to Orion Industries’ participation in the defense industry, International Traffic in Arms Regulations (ITAR) requires that access to sensitive information and material pertaining to defense and military related technologies may only be accessed, viewed, or shared by US Persons as defined by law. A “US Person” can be a US citizen; a lawful permanent legal resident or an individual who has been admitted as a refugee or asylee.

EEO/DEI Statement

Orion Industries commits to cultivating a culture of diversity, equity, and inclusion. We invite employees, participants in our services, vendors, and customers to bring their authentic selves to every interaction. We seek to represent the communities we serve. We aspire to see and value people across the spectrums of age, ability, gender, race, sexual orientation, perspectives, and other visible and invisible differences. We strive to include equitable practices at the center of our daily work and believe our organization is stronger for it.

Orion Industries provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.