Lead Python Developer, Data Analytics

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.

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. The 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. 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.

• 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

• 3+ years of experience with a Python Data Engineering Stack in a professional environment
• 3+ years of 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, Num Py, 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

• 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 in Celery for distributed task queue management and background job processing, including task routing, retry logic, error handling, and monitoring
• Expertise in Xlsx Writer 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., 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…