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

Date Posted: 1/15/2020

Job Snapshot

Job Description

Beacon is seeking to hire a Data Analyst II as part of the Intensive Family Care & Support Program, (IFCS) based in our Rocky Hill, CT office.

The IFCS program is responsible for providing support to families referred by the Department of Children and Families (DCF). The program works with families through a family-driven, strength-based, culturally and linguistically responsive model. The program supports families in developing solutions, identify an array community resources based on their need, and promotes permanent connections for the family.

The Data Analyst will provide analytical support for clinical informatics, program evaluation, quality improvement and outcomes projects. The 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 and will also create test cases and perform testing to validate final datasets.


  • 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.


  • 2-5 years of experience with data analysis and statistical principles
  • Five plus years of experience working in a Healthcare data environment
  • Experience in data analysis and data presentation preferably related to behavioral health and managed care.
  • Proficiency with Tableau, Excel and SAS EG
  • Ability to work on cross-functional teams to support quality management/data analysis needs.


  • Bachelor degree in related field of study required
  • Master's degree in related field of study, desirable

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.