POSITION SUMMARY
The Data Analyst I/Report Writer I creates reports and provides data analysis for Clinical departments and Administration. The Data Analyst I/Report Writer I is responsible for reviewing and auditing clinical and operational information systems data as well as creating requested recurring or ad hoc reports. The Data Analyst/Report Writer I will also provide technical support for testing and maintaining member-managed reporting components for the Healthcare Software Systems, works as a part of a multidisciplinary team, and ensures high accuracy of organizational data by focusing on data quality control and process improvement.
The Native American Health Center is an accredited institution and adheres to the standards of excellence set forth by the Accreditation Association of Ambulatory Health Care (AAAHC) and the Commission of Dental Accreditation (CODA).
This is a regular, full-time, hybrid (remote and in-person) position with weekly/intermittent in-person and in-office attendance to visit the Oakland office and client premises to provide support for the clinic and/or client needs or activities, meetings, retreats, and ad-hoc activities. The individual hired for this job must reside within a 50-mile radius of Oakland, CA, and be available to work onsite as required.
DUTIES AND RESPONSIBILITIES
Reporting
1. Serve as a secondary report writer, in support of Data Analyst / Report Writer II, for business departments by creating and coordinating generation of regular internal reports for Administration and clinicians.
2. Create and coordinate generation of audit reports for Administration and clinicians.
3. Create and coordinate the generation of reports for grants and federal reporting (i.e., UDS, OSHPD, etc.).
4. Responsible for creating recurring annual, monthly, weekly, daily and ad-hoc reports upon request.
5. Create SQL queries, views, functions and stored procedures to extract data from healthcare software systems and other data warehouses.
6. Consult with managerial and departmental personnel to clarify report specifications and identify problems with existing reports.
7. Revise and interpret existing reports and SQL scripts to meet new reporting requirements.
8. Actively participate in and/or support cross-trainings designed to ensure data information is consistently entered and reviewed.
9. Proactively communicate with clinical and administrative staff about issues relating to quality and effectiveness of software databases and clinical processes.
10. Participate in efforts to analyze, design and migrate data as needed.
11. Maintain absolute integrity of clinical data sets and suggest ways to improve data quality and consistency.
12. Supports Data Analyst / Report Writer II with the design, development, and maintenance of reports/dashboards generated from the healthcare data systems from initial request to project completion including: preliminary conversations with end users, data extractions from relevant databases, and data visualization.
13. Assists with and supports technical troubleshooting and issue resolution, including but not limited to EHR upgrades, EHR reports, and general technical support.
14. Perform data validation and audits.
15. Assist Site Specialists with addressing reporting-specific matters, including but not limited to:
• Provide daily support to Epic applications users through troubleshooting, coaching and consulting.
• Collaborate with OCHIN to test new features and upgrades prior to implementation as well as communicating out to end users regarding new features/ changes.
• Support NAHC and data system updates, implementation and optimization.
• Provide trainings to staff on system utilization.
Relevant Software Support
16. Create and update detailed training guides for Relevant (with Epic crosswalk).
17. Provide ongoing support to relevant application users through troubleshooting, coaching, and consulting.
18. Remain abreast of new relevant features/upgrades, testing new features and upgrades prior to implementation as well as communicating out to end users regarding new features/changes.
General Agency Duties
19. Employee Safety: Safely performs all duties; follows required protective protocols to ensure personal safety as well the safety of others.
20. Must maintain compliance with ergonomic safety standards; be mindful of posture and regularly practice ergonomic stretches.
21. Quality Improvement: Actively participate in internal quality improvement teams and work with members proactively to drive quality improvement initiatives in accordance with the mission and strategic goals of the organization, federal and state laws and regulations, and accreditation standards, when assigned.
22. HIPAA: Keep all protected health information (PHI) confidential and abide by HIPAA policies for the release and disclosure of any PHI. Will report unauthorized use of disclosure of PHI immediately, to supervisor or HIPAA security officer.
23. Work well under pressure, meet multiple and often competing deadlines.
24. At all times demonstrate cooperative behavior with supervisors, subordinates, colleagues, clients and the community.
25. Other duties as assigned by Supervisor.
26. Maintain the highest degree of confidentiality at all times as outlined by HIPAA, HITECH and agency policies.
27. Project a mature, professional image at all times and provide responsive, high quality, timely follow-up to internal and external inquiries.
MINIMUM QUALIFICATIONS
1. Must reside within a 50-mile radius of Oakland, CA; hybrid (remote and in-person) position with weekly/intermittent in-person and in-office attendance to visit the Oakland office.
2. Bachelor’s degree from four-year College or university, preferably in a computer-related field; two years of Health Information systems experience; or an equivalent combination of education and experience. Experience and skill working with database applications and database types, especially Microsoft Access, Epic, Dentrix, Relevant, and NextGen.
3. Knowledge and ability to develop SQL scripts to assist with reporting requirements.
4. Advanced knowledge at using database query tools, including Microsoft Access and Crystal Reports.
5. Experience with data warehouse environment implementation and maintenance.
6. Experience working with clinical data and Information Systems.
7. Well organized with good verbal and written communication skills.
8. Ability to work well independently and in a team environment; self-motivated.
9. Superior attention to detail and excellent organizational skills.
10. Excellent verbal, written, problem solving and interpersonal skills.
PREFERRED QUALIFICATIONS
11. Excellent knowledge of medical terminology and ICD-10.
12. Experience working in a community clinic environment.
Benefits: Native American Health Center (NAHC) considers our employees to be our most valuable resource and offers an excellent benefit package: competitive salaries, personal time off (PTO) or sick/vacation leave program, and an employer contribution 403(b) retirement plan to full-time regular status employees. We also provide medical, vision, dental, flexible spending, group term and voluntary life insurance coverage for employees and their dependents—with a percentage of employee contribution for dependent medical premiums.
Note to Applicants: Please be advised a post job offer, pre-employment Physical and TB test are required as a condition of employment. Additionally, you may be asked to get a Department of Justice Fingerprinting clearance as a contingency for an offer of employment. Criminal clearances are obtained to protect the welfare and safety of clients receiving services at NAHC.
EQUAL OPPORTUNITY EMPLOYER: Within the scope of Indian Preference, all candidates will receive equal consideration without regard to race, color, gender, religion, national origin or other non-merit factors.
Age Discrimination in Employment Act (ADEA): Native American Health Center abides by the mandates of the ADEA (protecting individuals 40 years and older) and considers age a non-merit factor in all employment decisions and considerations.
Americans with Disabilities Act (ADA): Native American Health Center abides by the mandates of the ADA and considers disability a non-merit factor in all employment decisions and considerations. Furthermore, NAHC will make any practical, feasible, and reasonable arrangements to accommodate qualified applicants and employees with disabilities.