Skip to main content

A new day in healthcare. Together, CVS Health and Aetna help people on their path to better health.

Business Data Analyst- SQL

Primary Location: Hartford, CT
Additional Locations: CT-Hartford
Apply
Description:

Aetna's Medicare Stars Data Intelligence team is growing, and this is an exciting time to join us as an Informatics Business Systems Analyst. This position will be responsible for managing and analyzing project work, enhancement requests and questions that come in for our Data Engine, reporting portals or web applications. The candidate will also be responsible for developing and maintaining both technical and functional documentation, including some basic project management documents. In this fast-paced environment, the candidate will have opportunities to work with a wide variety of Medicare business areas and applications to both gather requirements and train business partners on our applications and reporting portals. Within the team, the candidate will interact with skilled technical partners, contributing analysis mostly through SQL query development.



Fundamental Components:
Core responsibilities for this position include, but are not limited to, the following:
(*) Analyzing database table structures and reverse engineering Entity Relationship Diagrams.
(*) Creating and maintaining documentation that describes database tables and relationships for multiple functional areas within the overall structure (made up of 1200+ tables and views). This documentation will need to include all details needed by Data Intelligence Analysts who will develop queries to answer business questions.
(*) Creating and maintaining reporting portal and web application documentation. Work with developers to create technical documentation. Work with business analysts, business partners and end users to create functional documentation.
(*) Work with business partners and end users to develop and document Business Needs and Business Requirements documentation for project and enhancement requests.
(*) Conduct tutorial and training sessions with business partners and end users in the use of our reporting portals, web applications and the Data Intelligence Data Engine.


Background Experience:

(*) 5 or more years of healthcare, health insurance, or relevant combination of experience
(*) Proficient in writing and maintaining technical and functional documentation.
(*) Ability to explore database tables and structures (DB2 and MS SQL Server) for the purpose of developing schema diagrams and technical documentation.
(*) Ability to write and execute SQL queries in DB2 and MS SQL Server.
(*) Understanding of application development structures for the purpose of developing technical documentation.
(*) Ability to train others in 1 on 1 and group settings.
(*) Demonstrated ability to effectively communicate and negotiate across the business and in the external health care environment.
(*) Strong reporting skills using Excel, Access, Word and/or PowerPoint.
(*) Contributes and creates a motivated work environment within the team.
(*) Working knowledge of Agile methodologies including SAFe using Scrum and Kanban concepts.
(*) Working knowledge of the following are a big plus: SAS, C#.NET, Tableau, Business Objects Enterprise (BOE), Team Foundation Server (TFS).


Additional Job Information:
The Medicare Stars Data Intelligence team is growing to support the needs of the Medicare organization. This is a fast-paced, fluid business team involved in many strategic initiatives for Medicare.

Potential Telework Position:
Yes

Percent of Travel Required:
0 - 10%

EEO Statement:
Aetna is an Equal Opportunity, Affirmative Action Employer

Benefit Eligibility:
Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

Candidate Privacy Information:
Aetna takes our candidate's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.

Click To Review Our Benefits (PDF)

Apply

Jobs for you

Recently Viewed Jobs

You do not have any recently viewed jobs

Your Saved Jobs

You do not have any saved jobs

Sign up for Job Alerts

Join our Talent Community

At Aetna, we are pioneering a total approach to health and wellness and we need talented candidates like you to join our team. Become a member of our talent community to be the first to know about career initiatives that match your skills and interests as they become available, in addition to details on upcoming events, networking opportunities, and news about Aetna.

Join Our Talent Community

Sign up to receive information about job openings that are tailored to your skills and interests. Plus, get the latest career news from Aetna.