Posted in

Sr Manager – Business Intelligence

Sr Manager – Business Intelligence

CompanyCVS Health
LocationHartford, CT, USA
Salary$67900 – $199144
TypeFull-Time
Degrees
Experience LevelSenior, Expert or higher

Requirements

  • 5+ years of experience in reporting and data analytics/informatics in a healthcare, Health insurance or similarly regulated environment
  • 5+ years of experience with Python/SQL server in data analytics and manipulation
  • 5+ years of experience with BI tools, including Tableau, Quicksight, PowerBI
  • Strong proficiency in SQL for data manipulation and analytics
  • Hands-on experience with data visualization with AWS QuickSight or similar tools
  • Experience in data modeling and working with structured and unstructured datasets
  • Strong problem-solving skills and ability to troubleshoot technical challenges
  • Self-starter with the ability to work independently and take initiative
  • Excellent communication skills to collaborate with technical and business stakeholders
  • Experience working in an Agile development environment or similar methodologies
  • Understanding of healthcare industry data and compliance requirements is a plus

Responsibilities

  • Responsible for providing guidance and direction to external vendors, external consultants, team members and/or matrixed staff as required to support MA Risk Adjustment Revenue Integrity initiatives
  • Responsible for leading the reconciliation of data (coding review results and medical record images) from different sources, identifying gaps within the process, and leading to develop more efficiency within the process
  • Act as business lead for system design and in testing new functions, as well as the support of auditing activities related to vendor reconciliation of coding results and medical record images as well as other technical projects
  • Drive change related to enhancements and system fixes. Understanding interdependencies in both process and timing to further business objectives. To be successful, the candidate will use their knowledge and experience to create meaning from the data
  • This position also supports coordination across all shared services and vendors to assure data integrity and data validation processes are in place. You will be responsible for auditing tasks including documenting and evaluating critical controls. You will be responsible for understanding procedures, results, and business impacts; and document and express such understanding in both written and verbal form
  • Conducts periodic updates of analytical routines and department production systems. Investigates and evaluates alternative solutions to meeting business needs
  • Tightly managing vendor data quality and timeliness; ensure data is ingested into CREW to drive submissions; any and all CREW validation errors are worked timely to ensure submission completeness; analyze and understand digital retrieval to maximize results; customize MA and ACA reporting views and outreach manager data needed for day to day operations work
  • Implement Python or PySpark solutions for data transformation and analytics
  • Write and optimize complex SQL queries for efficient data extraction, transformation, processing, and analysis
  • Build, optimize, and maintain AWS QuickSight and Tableau dashboards for data visualization and reporting
  • Ensure data integrity, validation, and compliance with healthcare industry standards and regulations
  • Document processes, technical designs, and best practices for future reference
  • Work in an Agile development environment, collaborating with cross-functional teams
  • Mentor junior team members and provide guidance on best practices in development, data analysis, reporting accuracy, and data validation

Preferred Qualifications

  • 7+ years of experience in reporting and data analytics/informatics in a healthcare, Health insurance or similarly regulated environment
  • Vendor management experience
  • Experience with CMS Risk Adjustment programs
  • 7+ years of healthcare, health insurance, or relevant combination of experience
  • 7+ years of experience with several of the following methodologies: management consulting, project consulting, business process consulting, financial strategic analysis strategic business planning, and/or risk management consulting
  • Experience documenting business processes, as well as, recommending and implementing improvement strategies
  • Participates in system design
  • Experience with IT application development lifecycles, methodologies
  • Strong problem-solving, analytical, critical thinking and project management skills
  • Experience influencing others by turning data into meaningful and actionable information
  • Ability to perform testing functions
  • Ability to audit the accuracy of reporting against source documents/reports/databases