Aetna Veterans Jobs

Job Information

Aetna Data Warehouse Manager in New York, New York

Req ID: 64352BR

Job 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 included but are not limited to:

  • 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.

Qualifications Requirements and Preferences:

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

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

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

Benefit Eligibility

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

Job Function: Information Technology

Aetna is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected Veterans status.