Business Analytics Lead Analyst (SSIS/SQL Server Required)

Company: Cigna
Location: Hartford
Posted on: January 11, 2021

Job Description:

Remote, Work From Home, United States This role supports the Network Quality & Performance organization and the associated functional processes within Total Health and Network. This position will conduct quality activities that measure and analyze the quality and consumption of provider data. Activities may include conducting focused audits, utilizing quality tools, analyzing root cause and performing analytical techniques. Along with these duties, this role improves the quality of the data, the process, and improvements in data consumption. The Business Analytics Lead Analyst will also identify defects and will contribute to pinpointing the causes and offer recommendations for prevention. This role will maintain a strong focus on facts and data to understand the quality of our network, contracts, and demographics in Provider data. The Business Analytics Lead Analyst should be proficient conducting sample audits, designing and maintaining audit procedures, implementing quality inspections, assisting in the development and enhancement of quality tools, and analyzing results to improve quality outcomes. This role uses various tools that assist with quality assessments producing metrics and information and requires a proficiency working with data and basic data analysis. Duties include: Conducts audits as well as in-process manual and semi-automated inspections for specific transactions utilizing data mining and intelligence tools Conducts independent and/or collaborative data analysis to improve the quality in Provider data for our customer, client, and provider experience of quality outcomes Assesses the accuracy, completeness, and currency of Networks, Contracts, Demographic and Reimbursement data within Cigna systems Assesses and document the accuracy, completeness of Provider Data Transmitted from source system through the entire transmission process to the usages in the consuming application. Works independently and collaboratively with Cigna business partners to verify and document quality defects with opportunities and coaching to improve Organizes and completes activities including documented support of any audit findings and defects Ensures compliance with all internal and external quality audit requirements Implements and supports business activities utilizing data mining, reporting, and other intelligence methods and tools Committed to improving skills and competencies by demonstrating initiative and leadership in ongoing coaching and training programs Analyzes results for trends and root cause through comparative, diagnostic, or statistical analysis with conclusions Makes recommendations based on findings Conducts data comparisons utilizing source information relative to demographic, contract and reimbursement data Documents and maintains inventory of failures within the process as fed by audit and data obtainable through analysis and reporting related to claims, directory and system fallout, etc. Qualifications: Bachelor's degree or higher strongly preferred or equivalent work experience 3 years-------- strong knowledge and experience of BI tools such as SQL, Visual Studio, Toad for Oracle preferred 3 year' experience working with SSIS and SQL Server required SAS and/or VBA coding nice to have Strong analytical and problem-solving skills 3 years-------- experience in data quality within a healthcare setting Experience or exposure to audits or quality activities Strong knowledge and exposure/experience in the healthcare operations claim process, with emphasis on healthcare providers, contracting, and provider services Strong knowledge of Network, Contract and Demographic data elements. Strong knowledge of Provider structures and relationships Solid communication skills with the ability to discuss data analysis results Organization skills with the ability to manage data sets Adept critical thinking skills with the ability to determine causes with consistency in results Versatile knowledge of MS Access, MS Visio, MS Excel, MS Word, MS PowerPoint SQL experience or other programming language; highly preferred. This position is not eligible to be performed in Colorado. About Cigna Cigna Corporation (NYSE: CI) is a global health service company dedicated to improving the health, well-being and peace of mind of those we serve. We offer an integrated suite of health services through Cigna, Express Scripts, and our affiliates including medical, dental, behavioral health, pharmacy, vision, supplemental benefits, and other related products. Together, with our 74,000 employees worldwide, we aspire to transform health services, making them more affordable and accessible to millions. Through our unmatched expertise, bold action, fresh ideas and an unwavering commitment to patient-centered care, we are a force of health services innovation. When you work with Cigna, you--------ll enjoy meaningful career experiences that enrich people--------s lives while working together to make the world a healthier place. What difference will you make? To see our culture in action, search TeamCigna on Instagram. Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws. If you require reasonable accommodation in completing the online application process, please email: for support. Do not email for an update on your application or to provide your resume as you will not receive a response.

Keywords: Cigna, Hartford , Business Analytics Lead Analyst (SSIS/SQL Server Required), IT / Software / Systems , Hartford, Connecticut