Aetna Data Warehouse Manager in New York, New York
Req ID: 64352BR
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
Administration / Operation - Document production & distribution
Aetna Application - 28% Subsidy Web GUI, Aetna Application - AetInfo Disease Management Reporting, Aetna Application - Aetna Total clinical View, Aetna Application - Aggregate Reporting
Benefits Management - Encouraging Wellness and Prevention, General Business - Communicating for Impact, General Business - Consulting for Solutions, Leadership - Creating Accountability
General Business - Turning Data into Information, Service - Handling Service Challenges, Service - Providing Solutions to Constituent Needs, Technology - Selecting and Applying Technology Solutions
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.