Data and Reporting Specialist

Job Summary: This position’s primary function is to serve, from a continuous quality improvement perspective, as the primary support and maintenance position for the utilization of the agency EHR software and Microsoft Office Software related to client information and records compliance. In addition, this position will serve as the back-up position for CQI Assistant Director related functions and continue to perform agency CQI tasks as necessitated and directed.

Essential Functions:

• Serves as a Super-User for and assists in the continued development and maintenance of the utilized EHR software.
• Gathers information and generates compliance reports for program leadership staff.
• Serves as primary staff for completion of CDC quarterly file audits.
• Performs analysis, develops recommendations, and implements solutions for continuous data improvement opportunities.
• Locates and defines new data process improvement opportunities; propose practices that will prevent metadata, data quality and data compliance problems.
• Assists Assistant Director of CQI to gather and report data.
• Meets with stakeholders to discuss data issue findings; assists in policy and procedure improvements to remedy data issues; monitors improvement plans as indicated.
• Writes and runs SQL queries to identify data issues and exceptions related to existing report requirements.
• Builds SQL queries to extract meaningful data per new report requirements determined by program and leadership staff.
• Automates data preparation and report rendering, where possible.
• Researches, presents, and resolves application issues; acts as single-point-of-contact with agency EHR partner regarding any technical issues and task ticket resolution.
• Extracts, filters, and aggregates data through logical queries and basic programming. Develops and creates data layout like tables, charts, graphs, and process flow diagrams.
• Documents approved processes related to best-practice entry, reporting, and servicing of client data.
• Assists the agency in all preparation for visits by funding, licensing, monitoring, or accrediting bodies.
• Assists with projects such as the annual time study, new service documentation development, and continuous quality improvement action plan implementation.
• Responsible for obtaining required staff development/training hours as set forth by St. Joseph Children’s Home Policy and Procedures, by COA, and the Commonwealth of Kentucky.  Must implement and use the tools acquired during education sessions.

Position Requirements (Knowledge, Skills and Abilities):

• CULTURAL SENSITIVITY
  • Appreciates differences between others in thought as well as style and shows respect for their ideas.
  • Demonstrates responsiveness to the racial, ethnic, and cultural needs of individuals while maintaining respect for those differences.
• EMPOWERMENT
  • AS APPROPRIATE TO ROLE: Recognizes and works to eliminate situations that may lead to re-traumatization; Understands and allows for mutual self-help to occur among trauma survivors by utilizing their lived experience to promote recovery and healing.
• JOB KNOWLEDGE (Essential Functions)
  • Has a clear understanding of the position.
  • Demonstrates proficiency in the necessary common and technical knowledge areas required for the position.
• MODELING
  • AS APPROPRIATE TO ROLE: Uses appropriate voice, is aware of development levels of clients served, encourages independence and self-help, and reinforces positive behavior.
  • For those who provide direct care to clients, has the ability to anticipate problems, redirect behavior using positive practices, handle transitions well and develop goals for observation.
• PEER SUPPORT & COLLABORATION
  • Communicates and interacts well with others among teams, across departments, and/or with clients to ensure a respectful, and inclusive service/work environment.
  • Encourages and supports skill development of colleagues and/or direct reports, clients and/or families, and external stakeholders.
  • Builds/maintains trust and exhibits healthy boundaries with colleagues and/or direct reports, clients and/or families, and external stakeholders.
• PROFESSIONALISM
  • Is visible with a positive presence, ethical, and highly professional.
  • Expresses accountability for actions.
  • Shows respect towards others, serves as an appropriate role model during interactions and while performing job responsibilities, and is responsive to the needs of others.
• QUALITY OF WORK
  • Reliably completes work according to organization standards.
  • Exhibits strong judgment and problem-solving skills.
• SAFETY
  • Creates and maintains a safe, welcoming, physical and service environment.
• TIME MANAGEMENT
  • Is consistently at work, on time, and conforms to scheduled work hours.
  • Possesses the ability to effectively manage projects, timelines, and team goals without constant oversight.

Education and Experience:

• Bachelor’s degree in Computer Information Technology or related field preferred; OR equivalent understanding and experience with electronics and software preferred.
• At least two years in a professional work environment heavily utilizing software and working with data.
• In depth understanding of MSSQL and Office Suite products.

Physical Factors (those checked apply):

x	Sitting at a desk for  up to 8 hours	x	Office Environment	x	Entering data / keystroke		Driving
x	Standing for up to 8 hours	x	Reaching above shoulder level	x	Walking	x	Bending
x	Lifting/Carrying 25 max lbs	x	Pushing / Pulling 25 max lbs.		Using feet for repetitve action	x	Using hands for repetitive action