Lead Director, Data Engineering

Lead Director, Data Engineering

At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.

As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues – caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.

Caremark LLC, a CVS Health company, is hiring for the following role in Irving, TX: Lead Director, Data Engineering to plan, direct, and coordinate activities for data engineering teams. Duties include: direct daily data engineering operations across the enterprise, analyze workflow, establish priorities, and develop and execute strategic engineering roadmaps; apply analytical rigor and advanced statistical methods to the analysis of large amounts of data from pharmacy benefits management, specialty, retail, and/or healthcare businesses; lead a team of Data Engineers and Data Scientists designing and delivering analytics projects and experiments that inform solutions for in-house teams (i.e., pharmacy pricing, medical costs, risk scores, onboarding) and customer engagement across critical journeys (i.e., calories, heart rate, breast cancer, maternity); manage large data-driven information technology projects incorporating data exploration, model building, performance evaluation, and testing in order to evaluate scenarios, predict outcomes, and provide usable information on health metrics and future outcomes; identify business needs that can be addressed with advanced analytics and translate analytics into business value; present analytics results and compelling business insights to executives; review project plans and coordinate project activity; and mentor and assign and review the work of Data Engineers and junior team members. Telecommuting available.

Master's degree (or foreign equivalent) in Computer Science, Data Science, Statistics, Mathematics, Analytics, Information Systems, or a related field and four (4) years of experience in the job offered or related occupation. Requires four (4) years of experience in each of the following: analyzing large data sets from multiple data sources; data analysis for retail and/or healthcare industries; programming in Java, Python, or R; SAS or SQL programming languages; databases: Oracle, Teradata, or DB2; Spark, PySpark, or Scala; Hadoop architecture or HDFS commands; Hadoop and Hive; domain support for healthcare or retail organization; software testing, quality assurance, and troubleshooting; writing Extract/Transform/Load (ETL) processes; designing data models and solutions for analytical and reporting use cases; big data implementation. Managing consulting engagements including requirements gathering, data requests and reports, progress updates, issue resolution, and documenting analytics findings; creating functional project plans, developing new operating models, giving executive presentations, establishing working teams with functional leads across the enterprise, and developing integration business plans, budgeting, financial baseline comparison, and plans to capture synergy value; leadership of business analyses and initiatives; MS Excel, including writing advanced Excel formulas and using conditional, vlookups/hlookups, sorting and filtering, array formulas, and VBA macros, pivot reporting, and conditional formatting; leadership of cross-functional projects; developing high-impact presentations for senior-level leaders; communicating technical concepts and implications to business partners; presenting quantitative reports and analysis to executive-level audiences; and translating high-level business goals to technical and process requirements.

Pay Range: $180461.00/year to $230000.00/year.

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. This position also includes an award target in the company's equity award program. 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.