Hartford, Connecticut

Job Description
This position is located on the Aetna Mental Wellbeing team and is responsible for in-depth technical development in support of the RFL Customer Reporting team. This position will work in collaboration with business and informatics consultants to develop data management processes that support scalable reporting solutions.

This is a technical position that will involve the implementation and maintenance of ETL processes and Stored Procedures by integrating data from multiple sources, cleaning, profiling, and modeling data to support business reporting needs.

• Performs analyses in a relational database environment, including development of SQL queries, stored procedures, and functions.
• Implements and maintains automated ETL pipelines and packages.
• Performs extensive data validation and testing in a complex environment that uses multiple databases, source systems, and servers.
• Designs and develops algorithms, data models and reporting solutions that support internal and external clients.
• Makes recommendations about data management processes, metric definitions, and evaluation methods.
• Evaluates the data needs of assigned projects and assures the integrity of the data.
• Ability to manage conflicting priorities and multiple projects concurrently.
• Ability to 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.

Required Qualifications
• 5 or more years of data management, ETL, and analytics experience with Microsoft SQL Server tools (SSMS, SSAS, and SSIS).
• Advanced SQL programming abilities in a data warehouse or big data analytics environment.
• Well-versed in data management and data modeling concepts (dimensional fact modeling, OLAP, etc.)
• Knowledge of reporting tools such as SSRS, Business Objects/Crystal Reports, Power BI, or Tableau.
• Strong problem-solving skills and critical thinking ability.
• Strong collaboration and communication skills within and across teams.

COVID Requirements
CVS Health requires its Colleagues to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, or religious belief that prevents them from being vaccinated.

If you are vaccinated, you are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status within the first 10 days of your employment. For the two COVID-19 shot regimen, you will be required to provide proof of your second COVID-19 shot within the first 45 days of your employment. In some states and roles, you may be required to provide proof of full vaccination before you can begin to actively work. Failure to provide timely proof of your COVID-19 vaccination status will result in the termination of your employment with CVS Health.

If you are unable to be fully vaccinated due to disability, medical condition, or religious belief, you will be required to apply for a reasonable accommodation within the first 10 days of your employment in order to remain employed with CVS Health. As a part of this process, you will be required to provide information or documentation about the reason you cannot be vaccinated. In some states and roles, you may be required to have an approved reasonable accommodation before you can begin to actively work. If your request for an accommodation is not approved, then your employment may be terminated.

Preferred Qualifications
- Master’s degree preferred.
- Healthcare industry/data experience preferred.

Bachelor's degree in Computer Science, Information Technology, Computer Engineering, Business, Healthcare, or related discipline

Business Overview
At Aetna, a CVS Health company, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.

We are committed to maintaining a diverse and inclusive workplace. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, gender, gender identity, age, disability or protected veteran status. 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. See Job Description

Hartford, Connecticut

Continue serving and work with a purpose

As a CVS Health colleague, you'll find career opportunities across the organization and at every stage of your career. More important, your work will have an impactful purpose on someone's life, including your own. Learn more about how you can continue serving on your next mission at CVS Health.

Careers for Veterans and Military Spouses


"The military has an ethos that is grounded in purpose-driven service that’s bigger than the individual. The same holds true for us at CVS Health. You can talk to colleagues in any part of our business and they will be able to articulate our company’s purpose. Working here provides an opportunity for service members and military spouses to continue to serve, just in a civvies."

Similar jobs