Job Description
This individual contributor position is located on the Aetna Mental Wellbeing – Performance Excellence team and is responsible for in-depth technical development of analytics solutions. This position will work in collaboration with business leaders, stakeholders, and analysts to develop data driven solutions that inform opportunities to improve the mental wellbeing of the customers we serve.
This is a technical position that will involve gathering requirements, preparing documentation, combining data from multiple sources, and producing customer-facing analytics results.
– Collaborates with internal and external stakeholders to translate business needs into technical requirements.
– Prepares documentation such as process diagrams, data dictionaries, file specifications, ERDs, wireframes, and pseudocode.
– Makes recommendations about data management processes, metric definitions, and evaluation methods.
– Performs analyses in a relational database environment, including development of SQL queries, stored procedures, and functions.
– Develops customer-facing dashboards by modeling and aggregating data from multiple databases, source systems, and servers.
– Performs extensive verification and validation testing to ensure results meet functional requirements and stakeholder needs.
– Ability to manage conflicting priorities and multiple projects concurrently.
– Ability to clearly communicate technical ideas to nontechnical clients in written and verbal form.
– Responsible for project commitments to quality and on-time deliverables.
– Designs and conducts analyses using healthcare claims and services data.
Pay Range
The typical pay range for this role is:
Minimum: 70,000
Maximum: 140,000
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
Required Qualifications
– 5+ years of analytics experience with advanced SQL programming ability in a data warehouse or big data analytics environment (CTEs, subqueries, windowed aggregations, stored procedures, etc.).
– Experience preparing and combining data from multiple sources (SAS, SSIS, Alteryx, etc.) or equivalent tools.
– 3+ years of experience building efficient, high quality, integrated and increasingly real-time ETL/ELT processes using tools, programming languages and services (SSIS etc.).
– Understanding of user-centered design principles.
– Well-versed in data modeling concepts (dimensional/fact, cardinality, normalization, etc.).
– Strong problem-solving skills and critical thinking ability.
– Strong collaboration and communication skills within and across teams.
Preferred Qualifications
– Experience conducting analysis and working with healthcare claims and services data.
– Experience developing and publishing dashboards/reports with BI tools (Tableau, Power BI, etc.) or equivalent tools.
-Experience in GCP Cloud services such as Big Query, Composer, Airflow, DataProc.
Education
– Bachelor’s degree or equivalent experience.
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. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities.
Apply