Mgr, Informatics (IC)

Posted:
8/19/2024, 5:00:00 PM

Location(s):
Connecticut, United States ⋅ Hartford, Connecticut, United States

Experience Level(s):
Mid Level ⋅ Senior

Field(s):
Data & Analytics

Workplace Type:
Hybrid

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.

Position Summary

Aetna's Medicare Stars Data Intelligence (DI) team is an integral part of the Medicare business.  We are seeking a Mgr, Informatics to join our Operations team.  The DI team manages data environments, reporting and web applications that support Medicare and Stars-specific initiatives.

The Data Intelligence team is focused on creating a framework for developing large scale data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs focusing on complex business problems. We use advanced technology and tools, data modeling techniques, and ETL processes to enable data acquisition by leveraging big data within a cutting-edge environment. We’re focused on creating new opportunities that drive change in areas such as Medicare stars, Service Operations, Patient Safety, population health management and member experience.

This role is a Hybrid role which means a colleague works some of their scheduled workdays each week in an assigned company office location, and some workdays from a designated virtual work location, usually located in the colleague's home.

Fundamental components

  • Analyze science, engineering, business, and other data processing problems to implement and improve computer systems.

  • Perform advanced SQL and SAS Programming in data warehouse environment including use of different analysis techniques or business intelligence application development.

  • Manage, build, enhance, architect, and maintain the Medicare Stars Data Engine.

  • Process large data sets through complex ETL to our Medicare Star Data Engine.

  • Explore, examine, and interpret large volumes of data in various forms.

  • Perform analysis of structured and unstructured data to solve moderately complex business problems.

  • End to end testing of the Medicare Stars data warehouse data and implement appropriate validation controls to control data quality.

  • Develop automated data quality scripts to ensure the data integrity and completeness of the data.

  • Design and conduct analysis and outcome studies using healthcare claims, pharmacy, and lab data, employing appropriate research designs and statistical methods.

  • Develop, validate, and execute algorithms, data models and reporting tools that answer applied research and business questions for internal and external clients.

  • Define and deliver analytical solutions in support of healthcare business initiatives that drive short and long-term objectives.

  • Applies understanding of key business drivers to accomplish own work.

  • Uses expertise, judgment, and precedents to contribute to the resolution of moderately complex problems. Writes ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing.

  • Collaborates with client team to transform data and integrate algorithms and models into automated processes.

  • Uses knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries to build data pipelines.

  • Uses programming skills in Python, Visual Studio, or any of the major languages to build robust data pipelines and dynamic systems.

  • Builds data marts and data models to support clients and other internal customers.

  • Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards.

In this fast-paced environment, the candidate will have opportunities to work with a wide variety of Medicare business areas and applications.  Within the team, the candidate will interact with skilled analysts and technical partners.


Required Qualifications

  • Strong problem-solving skills and critical thinking ability.
  • Strong collaboration and communication skills within and across teams.
  • 3 or more years of progressively complex related experience.
  • Ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources.
  • Ability to understand complex systems and solve challenging analytical problems.
  • Experience with Visual studio, C#, Python, SQL and SSIS. In addition, DBMS experience is highly desirable (DB2 or MSSQL)
  • Knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.
  • Knowledge in Cloud technologies (GCP and Azure). 
  • Experience building data transformation and processing solutions. Has strong knowledge of large-scale search applications and building high volume data pipelines.

This role is a Hybrid role which means a hybrid Colleague works some of their scheduled workdays each week in an assigned company office location, and some workdays from a designated virtual work location, usually located in the Colleague's home.


Preferred Qualifications

  • Cloud experience (GCP and / or Azure)
  • Working knowledge of Agile methodologies including SAFe concepts as well as familiarity with Agile tools such as Rally

Education

  • Bachelor's degree in Computer Science, HealthCare Informatics, Computer Engineering, Information Systems, Machine Learning, or related discipline or equivalent work experience.

Pay Range

The typical pay range for this role is:

$60,300.00 - $145,860.00

This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls.  The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors.  This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above. 
 
In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities.  The Company offers a full range of medical, dental, and vision benefits.  Eligible employees may enroll in the Company’s 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees.  The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners.  As for time off, Company employees enjoy Paid Time Off (“PTO”) or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies.  
 
For more detailed information on available benefits, please visit jobs.CVSHealth.com/benefits

We anticipate the application window for this opening will close on: 08/23/2024

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.

CVS Pharmacy Inc

Website: https://cvshealth.com/

Headquarter Location: Woonsocket, Rhode Island, United States

Employee Count: 10001+

Year Founded: 1963

IPO Status: Public

Last Funding Type: Post-IPO Equity

Industries: Health Care ⋅ Medical ⋅ Pharmaceutical ⋅ Retail ⋅ Sales