Skip to main content

Information Technology

Aetna IT is committed to keeping our members at the heart of everything we do. Our top-talent workforce delivers leading-edge technology, drives innovation, turns vision into action and challenges the art of the possible. We provide best-in-class services to our members by delivering groundbreaking healthcare tools, enabling consumer-friendly interactions and protecting data security. Your mission will be to deliver innovating technology solutions including: Hybrid cloud infrastructure, artificial intelligence/machine learning capabilities and infrastructure as code.

Aetna, a CVS Health Company, is a company with a world-class IT team and we will be counting on you to carry on our success as the preferred provider of infrastructure services for our business partners.

Back to Job Navigation (Overview)

Success Profile

What makes a successful Information Technologist?
Here are the traits we are looking for:

  • Adaptable
  • Collaborative
  • Communicator
  • Digitally Savvy
  • Good Listener
  • Problem-solver
  • Results Driven
  • Team Player
  • Technologically savvy
  • Versatile
  • Relationship expertise
  • Diplomatic
  • Trustworthy
  • Business Savvy

Back to Job Navigation (Success)

Benefits

  • Medical

  • Dental

  • Vision

  • Healthcare
    FSA

  • Dependent
    Care FSA

  • Health and
    Wellness
    Programs

Back to Job Navigation (Rewards)

Job Details

Technical Analyst - SQL

Primary Location: Phoenix, Arizona
Additional Locations: AZ-Phoenix
Apply
Description:
Creates and executes specific deliverables and activities as part of a team assigned to a business-sponsored IT project. Key contributor to overall project success.
Must be able to load SQL data, write SQL code, be proficient in MS ACCESS and SAS.
The ideal candidate will be able to load vendor data and files into a database, query files using joins and find discrepancies, discuss the best ways to create reports, and work with other teams to identify data sources, then create process documentation. Ideally, the candidate will also have experience with Github, Team City, Octopus, and other tools.

Fundamental Components:
  • Consistently performs analysis and translates business needs to create high-quality Business Requirements and Functional Specifications documentation within specified time frames to solve most complex problems (multiple interfaces with other systems across multiple business units) considering all impacted components from an end-to-end perspective.
  • Ensures end-to-end traceability of requirements is complete.
  • Expert in one or more business systems.
  • Applies specific functional and/or business expertise to perform assigned tasks and develop specific project deliverables.
  • Conducts impact analysis of technology changes on business processes and existing technology.
  • Competent to work at the highest technical capacity on most phases of the business systems analysis.
  • Contributes to the review of Test Planning and Test Execution strategies.
  • Creates the appropriate User-Interface Model(s) to support projects.
  • Develops business workflow diagrams.
  • Assists in the development of data models and interface design specifications
  • Documents, tracks, and resolves issues related to data quality.
  • Contributes to the design and mapping of data conversion strategies.
  • Participates in collaborative system and data design sessions with the user community, technical architecture resources, and development resources.
  • Completes project activities on time and within budget, and proactively identifies and communicates issues that may jeopardize milestones or project budget to the Project Manager.
  • Adheres to APLC or AGILE project management methodology by utilizing internal procedures and tools and identifying areas for methodology improvement.
  • Develops Product Overviews, FAQs, Tool Glossaries, system training material, and system user documentation to support implementation activities.
  • Creates appropriate communication materials are documented and distributed appropriately.
  • Guides and advises less-experienced Business Analysts.
  • Senior BA assigned as Lead on a project ensures other BA's assigned to the project are completing their deliverables of high quality and on-time.
  • Conducts interviews, fact-finding, and independent research to design creative, progressive IT solutions for business problems


Background Experience:
  • 5+ years Business Analyst experience.
  • Ability to recognize complex problems vs. objectives and apply creativity to analyze situations, develop solutions and procedures.
  • Must possess sound knowledge of structured IT application development lifecycles, methodologies inclusive of Use Case tools.
  • Bachelor’s degree in a Business or IT field, or an equivalent combination of education and work experience.


Additional Job Information:
This position reports into the Medicare Operations and is a create opportunity to learn about Medicare risk adjustment activities.

Technology Experience:
Database - Microsoft Access, Database - Microsoft SQL Server, Reporting Tool - SAS

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

Influential Content

Back to Job Navigation (Trending)

Sign up for Job Alerts

Explore This Area

Check out where you could be working if you apply.

View Map

Similar Jobs

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.