Data Analyst I


Visual Connections, LLC is seeking a savvy and enthusiastic analytical mind adept at creating queries, writing reports and presenting findings. This role will support the MPIC strategic plan, data analysis and reporting initiatives. Strong verbal and written communication, multitasking and time management skills are key to success in this role. The ideal candidate will be able to consume, process and analyze large data-sets in collaboration with other analysts, investigators, and subject matter experts.

Essential Duties & Responsibilities:

  • Develop and distribute standard reports, custom reports, and data files using SAS Enterprise Guide, COGNOS BI and MS Office tools.

  • Interpret data and analyze results using statistical techniques and provide ongoing reports

  • Identify, analyze, and interpret trends or patterns in complex data sets

  • Work closely with management to prioritize business and information needs

  • Initially validate results to ensure data integrity of the reports and/or files produced

  • Work with internal customers on custom data reporting and file requests to define requirements, create queries to meet requirements, conduct testing, and execute import/export processes

 Required Experience/Education:

  • BA/BS degree (or equivalent experience) Mathematics, Economics, Computer Science, Information Management, Economics, Statistics or a related field

  • 1-2 years of experience working as an analyst

  • Knowledge of relational databases and database querying language (e.g. SQL)

  • 2+ years of experience using SAS for the querying and analysis of data

  • Ability to use Base SAS to write programs using data steps (in addition to general PROC SQL) with oversight from senior data analysts

  • Ability to work independently to construct queries and review output to create initial trend identification

  • Ability to effectively communicate analysis results to technical and non-technical audiences

  • Advanced Excel skills including formulas, pivot tables, charting, and data tables

 Core Competencies:

  • Advanced level of proficiency with Microsoft Excel, Word, and PowerPoint

  • Working knowledge of database architecture and ability to effectively map data, as well as run basic SQL queries to analyze large complex data sets and troubleshoot

  • Acute attention to detail and strong analytical and critical thinking skills

  • Strong written and verbal communication skills including the ability to communicate results of data analysis to a variety of stakeholders

  • Motivation to achieve individual and team goals, must be able to work independently and in a team environment

  • Ability to learn and apply industry-specific concepts

  • Adaptable to change and able to work independently and as part of a team

  • Strong problem analysis skills to include the use of mathematical concepts to validate results

 Preferred Qualifications:

  • Experience using R, Python, SAS Visual Analytics and/or JMP for data analysis and data visualization

  • Familiarity with Remote and telework technologies like Skype and WebEx

  • Experience in healthcare and government sector a plus

Program Background: The Affordable Care Act (ACA) requires every state to establish a health insurance exchange (also called Health Insurance MarketplaceSM) to facilitate the purchase of health insurance for individuals and small businesses. Through the Center of Program Integrity (CPI), CMS has strong oversight and internal controls to protect consumers enrolled in the Marketplaces and safeguard taxpayer dollars. CMS develops and enforces rules for insurance agents, and brokers and others who assist with FFM enrollments.  The Marketplace Program Integrity Contractor (MPIC) is designed to support this oversight. Through research, investigation and data analysis, the desired outcomes of the MPIC efforts are to prevent, detect, and resolve noncompliance with Marketplace rules, requirements, and laws; recommend administrative action to CMS; and recommend referral to law enforcement if potential fraud and abuse is identified.

Anticipated Start Date:  11/1/2019

Program/Project: Marketplace Program Integrity Contractor (MPIC)

Duration: OY 2-4

Position Type: Full-Time (FT)

Location: VC or Remote

Core Hours: 9am – 5pm Eastern; 40 hours/week


Visual Connections, LLC offers a full benefits package including:

  • Full Medical, Dental, Prescription and Vision health care

  • 10 Paid Holidays annually

  • Paid time off

  • Short Term, Long Term Disability and Life Insurance

  • Employee Assistance Program (EAP)

Training and Development opportunities including professional certification and educational reimbursement

Visual Connections, LLC provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. Visual Connections, LLC complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.