Data Analyst

Do you want to be part of a leading, patient-centered organization where professionals come together to improve access to quality health care for all? At Oak Orchard Health, you can grow your career with the fulfilment and satisfaction of knowing that your work is making a difference in someone’s life. We have 8 medical offices located in communities throughout Western NY and we continue to expand and recruit top talent with our mission to ensure everyone has access to affordable, quality health care. Our diverse, highly skilled professionals are the reason for our success, from physicians to nurses to administrators and support personnel. If you’re passionate about serving all with excellence, equity, inclusion, respect, and dignity, we think you’ll fit right in! Diverse and bilingual candidates are encouraged to apply.

We offer:

• Tuition Reimbursement and Student Loan Forgiveness (PSLF) Eligible!
• Flexible schedule that promotes a healthy work life balance!
• Competitive wages!
• Comprehensive benefit package (health/vision/dental) that starts the first of the month after your hire date!
• Retirement Plan 403(b) with a competitive company match
• Organizational support of continuing education and professional development!
• Company paid life Insurance!
• Generous PTO package that includes Vacation time, Sick time, Personal Days, Floating Holidays, and Company paid holidays!

Position Summary:

The Data Analyst is responsible for the development and maintenance of reports and dashboards utilizing eClinicalworks, and third-party data repositories. This position will interact with multiple disciplines of the Health Center, including, but not limited to Clinical, Financial, Quality, Imaging, Regulatory and Operations to ensure reporting needs are met.

Job Responsibilities:

• Develop logic for reports and data analysis using various SQL languages (PostgreSQL, Microsoft SQL) along with eCW reporting tools.
• Utilize function calls, SQL stored procedures, multiple table joins, nested select statements and various SQL programming techniques to extract structure and present data.
• Understand and learn EMR workflows to translate between eCW to backend databases
• Conduct thorough data analysis to identify trends, patterns, and opportunities for improvement across various organizational functions.
• Assist in data quality assurance by identifying inconsistencies, cleaning datasets, and implementing best practices for data governance.
• Work with Relevant to be able to build custom reports and views based on staff requests
• Work with third party organizations that deal with providing reports of views to Oak Orchard.
• Be a liaison between Oak Orchard Health and HealthEfficient Qual IT program
• Any other reasonable requests from management.

Skills/Qualifications:

• Proficiency in SQL languages, with strong experience in PostgreSQL and Microsoft SQL.
• Experience with data visualization tools like Power BI, Tableau, or similar.
• Familiarity with data integration tools and ETL processes.
• Knowledge of healthcare data systems and standards (e.g., EHR, HL7, ICD codes) is a plus.
• Strong proficiency in Excel and other analytical tools.

Education/Experience:

• Bachelor’s degree in data science, computer science, statistics, health Informatics, or a related field.
• 3+ years of experience in a data analytics role, preferably in a healthcare environment.

Comprehensive Benefits:

• Health / Dental /Vision Insurance
• Retirement Plan
• Tuition Reimbursement
• Public Service Loan Forgiveness
• Generous Time Off