Lead Python Developer, Data Analytics

CVS Health

2d • Hybrid

About The Position

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time. Position Summary Aetna’s Reporting Solutions team is looking for an initiative-taking Lead Python Developer with 3+ years of experience in software engineering with Python in a professional environment to join our Reporting Solutions team. This Lead Python Developer role is a part of the Aetna Commercial’s Sales Enablement department that partners with business leaders and key stakeholders to optimize the achievement of strategic business objectives. In this exciting new role, the candidate will be accountable for designing, developing new Python code for new analytics capabilities and content. The work environment supports and thrives on out-of-the box thinking, creative talent, and a consultative approach. Specifically, this role will be responsible for developing and delivering new capabilities to support health care analytics and reporting, benefits evaluations, and operational decision making by Aetna internal and external constituents. This work requires technical, analytic, and consultative skills. The position may be remote or hybrid anywhere in the US depending on candidate location and commute to a hub location

Requirements

• 3+ years of experience with a Python Data Engineering Stack in a professional environment.
• 3+ Experience with SQL query development, working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources.
• Proficient in usage of the following Python libraries: Polars, NumPy, Pandas.
• Proficient with: XML, JSON, YAML.
• Experience with AI prompting to assist with development with tools like Copilot and, Claude.
• Proficient in the use of CI/CD pipelines and Git integration.

Nice To Haves

• 5+ years in a technical analytics/reporting role, with 3+ years of experience focusing on Python, SQL in a professional environment.
• Experience with callback architecture, including client-side callbacks, pattern-matching callbacks, and callback optimization techniques for complex multi-page applications.
• Experience with Redis for application caching, session management, and real-time data storage.
• Experience with PostgreSQL including complex query optimization, indexing strategies, and database performance tuning.
• Expertise Celery for distributed task queue management and background job processing, including task routing, retry logic, error handling, and monitoring.
• Expertise in XlsxWriter for generating complex Excel reports with multiple worksheets, charts, conditional formatting, and data validation.
• Experience with front end development, e.g., REACT, HTML, CSS.
• Experience with cloud computing providers (GCP, Azure, AWS)
• Experience with specialized Python data management libraries, e.g., with DBT.
• Experience migrating on-premises capabilities and analytical workflows to the cloud, leveraging cloud-native technologies to improve efficiency and effectiveness, e.g., with Google Cloud Platform.
• Excellent English communication and presentation skills, ensuring clear and concise communication with our team members and fostering a smooth and effective collaboration process.
• A strong ability to encourage teamwork and actively support the team’s objectives is essential.

Responsibilities

• Leverage Python to develop new reporting and analytics using healthcare data (medical, pharmacy, lab)
• Create business applications to deliver clinical or analytic solutions to constituents in a self-service fashion using Plotly Dash Enterprise.
• Drive forward enterprise modernization opportunities leveraging Python and cloud-native technologies.
• Refactor legacy programming code to improve turn-around-times and to take advantage of modern technologies.
• Communicate with key stakeholders in a way that is easy to understand and actionable.
• Define and deliver new technical capabilities in support of healthcare business initiatives that drive short- and long-term objectives.
• Work to expand, scale, and automate the analyses available to the broader team and the Aetna field.
• Ability to mentor and knowledge share with peers.
• Monitor and maintain applications and production processes required to deliver on business commitments.
• Use analytics and technology to solve business needs as well as to demonstrate to customers the value of Aetna’s integration with CVS Health.

Benefits

• This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families.
• The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility.
• Additional details about available benefits are provided during the application process and on Benefits Moments.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level