Data Analyst II in Rocky Hill, CT at Beacon Health Options

Date Posted: 3/12/2020

Job Snapshot

Job Description

We Help People Live their Lives to the Fullest Potential!

For more than 30 years, Beacon has changed the way people live with behavioral health conditions. Today, we are the undisputed leader in behavioral health management, serving 40 million people across all 50 states. At Beacon, we are committed to delivering a ‘world-class’ candidate experience from the moment you click ‘Apply’! Our goal is to help you reach your fullest potential, while utilizing your talents and expertise to help us deliver on our promise.

Do you have a passion for helping others? If so, we are looking for you!

Beacon is currently seeking a Data Analyst II to join our team at our Rocky Hill, CT office. The Data Analyst provides analytical support for clinical informatics, program evaluation, quality improvement and outcomes projects. Responsibilities include design and validation of summary report requests for the programming team, data management, and analysis including interpretation and presentation of results. Major focus of role will include creation of data visualizations, reports, and dashboards using Tableau for internal and external use. The Data Analyst will work closely with and assist SQL Developers in interpreting specifications and ensuring standards for data definition and data extraction are followed.

What does a typical day look like?

  • Reviews and manipulates data and reports from multiple sources, including authorizations and Medicaid claims for behavioral health, physical health, dental, and pharmacy.
  • Designs and maintains data, reports, and dashboards for tracking and reporting of clinical, quality, outcome, and research projects.
  • Develop functional and technical specifications for data extracts to be used for data analysis and reporting.
  • Collaborate closely with SQL Programmers to interpret, define, and document data extract specifications.
  • Develop easy-to-understand charts, tables, and graphs for diverse audiences using Tableau.
  • Monitor and quickly address data issues as they arise and escalate issues and support resolution in collaboration with the Director of Quality Analytics and Data Visualization.
  • Primary tool will be Tableau, in addition to Excel and SAS EG, and SAS EM.
  • Completes analyses and prepares written reports that summarize methodology, analysis of study data, and provides interpretations and recommendations.
  • Shift priorities when necessary to support urgent business needs
  • Collaborate with other Departments in order to interpret and assess needs of data requests.
  • Ensures the quality and timeliness of assigned deliverables, and is able to manage multiple concurrent projects.

What you Contribute?


  • Bachelor degree in related field of study required

Knowledge, Skills & Abilities:

  • Minimum of two years of experience with Data Analysis and Statistical principles 
  • Experience in Managed Healthcare or Behavioral Healthcare highly desirable
  • Intermediate to advanced proficiency in Tableau, Excel and SAS EG
  • Ability to work on cross-functional teams to support quality management/data analysis needs

What Makes Us Different?

  • Here, it’s not just a job – it’s an opportunity to change lives.
  • Our employees are learners, innovators and original
  • Our mission and values guide the way we treat our members, providers and each other.

What We Have to Offer:

  • Healthcare benefits available starting day 1!
  • Health & wellbeing incentives, such as gym membership reimbursement
  • 401K with company match to help reach your future financial goals
  • Generous PTO, because we know life happens outside of work
  • Tuition reimbursement so you can keep reaching your fullest potential

If Beacon sounds like the place for you, what are you waiting for? Apply with us today to get started!

Beacon Health Options is proud to be an Equal Opportunity and Affirmative Action Employer as well as a Drug Free and Tobacco Free Work Environment. EOE/AA/M/F/Veterans/Disabled

At Beacon Health Options, our candidate's data privacy is a top priority. Our recruiting team conducts all communications using official company email ( Only candidates who have applied for an open position through our Careers page ( will be engaged in our interview process. Beacon conducts all interviews in person or over the phone. At no time during the recruiting process will any Beacon recruiter request any financial or personally identifiable information from you.