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

Data Warehouse Manager

Primary Location: Alpharetta, Georgia
Additional Locations: GA-Alpharetta, NY-New York
Apply
Description:
Supervises and executes specific deliverables as part of a team assigned to support the day - to - day maintenance and enhancement of business applications and related project support.

Fundamental Components:
- Under the direction of experienced Application Support Manager: Supervises, directs, instructs and performs periodic quality reviews.
- Conducts regular performance reviews and provide coaching sessions to develop a high performing team.
- Leads the team to perform analysis to assess root cause of customer issues for reported system defects and control deficiencies found from system audits. This includes the reproducibility of the problem and managing the process for bringing the issues to closure.
- Leads the team with the conducting of interviews, fact-finding, and independent research to design creative, IT solutions for business problems
- Gathers and reports the business impact analysis of system defects, control/audit deficiencies and outages.
- Oversees the development and communication of short term workaround procedures to address system defects.
- Contributes to the communication process to impacted customers and internal management personnel.
- Supervises the generation of Problem/Service Request documentation and assists in prioritization process to determine how IT resources will be utilized in fixing system defects or implementing small enhancements.
- Responsible for the teams translation of business needs into Business Requirements within specified time frames Ensures that data quality issues are recognized, tracked, and addressed.
- Oversees the development of Product Overviews, FAQs, Tool Glossaries, system training material, and system user documentation to support implementation activities.
- Supervise the business area operations that set-up/modify/maintain system operating parameters by designing and configuring business rule table entries, and/or macros/automated scripts.
- Ensures the day to day support of these items so that they work properly (including the application of appropriate QA procedures) and to quickly fix any identified defects.
- Completes activities on time and within budget, and proactively identifies and communicates issues that may jeopardize delivery dates or budget to the Application Support Manager.
- Manages multifunctional team of analysts to provide end to end production support.
- Oversees team to bring to conclusion end to end problem resolution. Identifies trends in customer contact issues, determine business impact and present recommendations for change or improvement.
- Has in depth knowledge of Aetna systems and their interfaces.
- Effectively manages multiple priorities.
- Contributes to the organization's Business Plan and KPM's/SLA's.
- Performs related duties as assigned or requested.

Background Experience:
4+ years work experience that reflects a proven track record or proficiency in the competencies noted.
Bachelor's degree desired in related field
Hands-on experience with PL/SQL Packages, Stored Procedures, data aggregation, and error handling.
Must be able to understand SQL code, execute queries and investigate any reported defects
Solid skills with performance tuning PL/SQL scripts using indexes and hints
Experience with BO reporting tools such as Crystal reports, Webi reports, and exploration views
Ability to dive into Tableau dashboards and understand the logic behind multi-dimensional metrics
Analyze data issues, understand ETL logic and track them to the appropriate source databases
Expertise with performing root cause and impact analysis
Manage a production support team for a data warehouse
Communicate effectively and with L1, L2, L3 support personnel, QA, business and technical leads to research and resolve issues
Manage daily/weekly/monthly/quarterly standard reporting deliverables
Manage support intake log and conduct review meetings
Experience with Python scripting is a plus


Required Skills:
Benefits Management - Encouraging Wellness and Prevention, General Business - Communicating for Impact, General Business - Consulting for Solutions, Leadership - Creating Accountability

Desired Skills:
General Business - Turning Data into Information, Service - Handling Service Challenges, Service - Providing Solutions to Constituent Needs, Technology - Selecting and Applying Technology Solutions

Functional Skills:
Administration / Operation - Document production & distribution

Technology Experience:
Aetna Application - 28% Subsidy Web GUI, Aetna Application - AetInfo Disease Management Reporting, Aetna Application - Aetna Total clinical View, Aetna Application - Aggregate Reporting

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.