Aetna Sr SQL Informatics Business Systems Analyst (52673BR) in Hartford, Connecticut

Req ID: 52673BR


Aetna's Medicare Informatics Data Intelligence Team is growing, and this is an exciting time to join us as our Sr. Informatics Business Systems Analyst. This position will be responsible for developing and maintaining both technical and functional documentation for our Data Engine, Reporting Portals and Web Applications. In this fast-paced environment, the candidate will have opportunities to train end users in the use of a wide variety of web application and reporting portals as well as contribute with 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 Business 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.


(*) 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).


The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.


Functional - Information Management/Informatics/4-6 Years

Functional - Information Technology/Data / info management & architecture/4-6 Years

Functional - Information Technology//


Technical - Database/DB2/4-6 Years/

Technical - Database/Microsoft SQL Server/4-6 Years/


Leadership/Driving a Culture of Compliance/FOUNDATION

Technology/Leveraging Technology/FOUNDATION


Technology/Promoting Emerging Technology/FOUNDATION

Technology/Developing Competitive Technology and Architecture/FOUNDATION

Telework Specifications:

Option for telework will be evaluated based on candidate and location.


Join a high energy team that focuses on creating innovative Data Intelligence and Reporting solutions for a wide array of business partners. Bring your experience to the group, and we will enable you to expand your knowledge base as we grow together.

Aetna is about more than just doing a job. This is our opportunity to re-shape healthcare for America and across the globe. We are developing solutions to improve the quality and affordability of healthcare. What we do will benefit generations to come.

We care about each other, our customers and our communities. We are inspired to make a difference, and we are committed to integrity and excellence.

Together we will empower people to live healthier lives.

Aetna is an equal opportunity & affirmative action employer. All qualified applicants will receive consideration for employment regardless of personal characteristics or status. We take affirmative action to recruit, select and develop women, people of color, veterans and individuals with disabilities.

We are a company built on excellence. We have a culture that values growth, achievement and diversity and a workplace where your voice can be heard.

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

Aetna takes our candidates'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.


Job Function: Health Care