Business Intelligence Analyst

Company Intro

At American Vision Partners (AVP), we partner with the most respected ophthalmology practices in the country and integrate best-in-class management systems, operational infrastructure, and advanced technology to provide the highest quality patient care possible. Our practices include Barnet Dulaney Perkins Eye Center, Southwestern Eye Center, Retinal Consultants of Arizona, M&M Eye Institute, Abrams Eye Institute, Southwest Eye Institute, Aiello Eye Institute, Moretsky Cassidy Vision Correction, Wellish Vision Institute, West Texas Eye Associates and Vantage Eye Center. We are focused on building the nation’s largest and most comprehensive eye care practices and currently operate more than 100 eye care centers in Arizona, New Mexico, Nevada, California and Texas – including 25 ambulatory surgical centers.At AVP we value teamwork, providing exceptional experiences, continuous improvement, financial strength, and hard work. We are committed to providing best-in-class patient care, pioneering research and technology, and most importantly, rewarding and recognizing our employees!

Overview

As a BI Analyst- Financial Planning and Analysis, you will use data to catch the pulse of current market trends to better assist our company with profits. You will work with data from multiple sources including the company database, web database, data from other companies, etc. You will then collect the data and use it to create a picture of the current market and the best path for a company to take in the future.

Responsibilities

• Use SQL to develop queries to analyze big datasets, validate their quality and visualize outcomes
• Work across various business departments to define and document business and technical requirements for data analysis and dashboards
• Develop and maintain databases, data sets, and data processes to help drive business intelligence
• Utilize financial and operational modeling to drive strategy business decisions
• Present analytical findings and recommendations to operational leaders and senior leadership
• Actively work to understand and refine existing processes to develop new analytics views
• All Other Duties as assigned

Qualifications

• BA/BS or HS and equivalent work history 
• 4+ year in a similar role
• 2+ years developing and writing SQL queries
• Multi site experience required
• Healthcare Experience highly preferred
• Strong understanding of relational database foundations- creating, structuring, maintaining, and updating databases.
• Proven experience in strategic analytics and modeling
• Proven experience in leveraging big data
• Ability to uncover operational and data trends
• Knowledge of Excel, PowerPoint, data warehousing (Sequel), data mining, business intelligence (Power BI), and other financial systems 
• Excellent written and oral communication
• Self-motivated with the ability to work independently in a fast-paced, high pressure, and rapidly changing environment

Benefits & Perks

Your health, happiness and your future matters! At AVP, we offer everything from medical and dental insurance, significant eye care discounts, child care assistance, pet insurance, continuing education funds, 401(k), paid holidays, PTO, Sick Time, opportunity for growth, and much more!