Job Description• Organize, Schedule meetings with business users to understand, document the purpose, goal and objectives of the report/extract request.• Create technical specification document, including the implementation methodologies using tools and technologies such as SQL, Tableau, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).• Collaborate with business partners to design the automatic data acquisition or data delivery process for the required reporting data using various tools and technologies such as SFTP, Control-M, Batch scripts, SSIS and Sql Server Database.• Design and build scalable reporting solutions to continuously monitor trends, pattern, outliers on various clinical and operational metrics which impacts patient's health and operation performance.• Build Radar dashboards and Reporting Workbench reports with in Epic Hyperspace environment for Clinical, Revenue Cycle, Operations and other business teams.• Work collaboratively with the business users in testing phase and ensures the final deliveries of extracts and reports meet the business needs.• Conduct rigorous analyses of clinical and operational Data using appropriate data analysis techniques and provide accurate insights/inference that advance enterprise strategic goals.• Identify, assess and resolve complex business problems, issues, risks and facilitate issue resolution and risk mitigation.• Review Epic upgrade documentation related to reporting and implement the changes as per the guidelines defined.• Respond promptly to the needs of end-users, and meets Service Level Agreements as defined with clients.• Participate in project meetings as a key contributor with stakeholders from operations, clinical, payer relations and analytics team.• Share the expertise and coach other less experienced developers in Epic reporting.• Perform other duties as assigned
Required Qualifications• 5 years' experience with SQL development. Ability to write complex relational and multidimensional SQL queries and complex stored procedures.• 4 - 6 years' experience with business intelligence tools such as Microsoft BI stack, SAP Business Objects, Tableau is highly preferred.• 2 or more years' healthcare reporting/analytics experience preferred.• Experience with ETL tools such as SSIS is a plus.• Prior experience working with an EHR system and understanding of clinical and revenue cycle data are highly preferable.• Strong analytical and problem solving skills are mandatory.• Strong verbal and written communication skills. Can effectively translate complex technical concepts to non-technical audiences.• Ability to build consensus across teams, with staff and leadership.• Ability to work effectively in a matrixed, agile reporting environment.
COVID Requirements
COVID-19 Vaccination Requirement
CVS Health requires certain colleagues to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, religious belief, or other legally recognized reasons that prevents them from being vaccinated.
You are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status or apply for a reasonable accommodation within the first 10 days of your employment. Please note that in some states and roles, you may be required to provide proof of full vaccination or an approved reasonable accommodation before you can begin to actively work.
Preferred Qualifications• Strong knowledge of advanced analytics tools and languages to analyze large data sets from multiple
data sources• Anticipates and prevents problems and roadblocks before they occur• Healthcare sector experience preferred• Demonstrates strong ability to communicate technical concepts and implications to business
partners• Demonstrates proficiency in most areas of mathematical analysis methods, machine learning,
statistical analyses, and predictive modeling and in-depth specialization in some areas• People management experience
Education• Bachelor Degree in Computer Science, Information Systems, Business Administration, or related Engineering fields.• Master's Degree is preferred.• Current Epic certification: Cogito certification and Cogito Data Model is preferred
Business Overview
Bring your heart to CVS Health
Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand - with heart at its center - our purpose sends a personal message that how we deliver our services is just as important as what we deliver.
Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable.
We strive to promote and sustain a culture of diversity, inclusion and belonging every day.
CVS Health is an affirmative action employer, and is an equal opportunity employer, as are the physician-owned businesses for which CVS Health provides management services. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.