View All Jobs/Careers

Job Information

Aetna SQL Developer / Senior Analyst in Phoenix, Arizona

Req ID: 62446BR

Job Description

This Applications Support Analyst position is responsible for supporting the CSRA Technical Team in the design, development, and maintenance of operational management and reporting applications, primarily using the MS-SQL tools. This position is responsible for evaluating department requirements for information reporting based on the QNXT claims processing system configuration build designs as well as the Remedy change management system database structure to determine the logic needed to correctly design and build SQL application tools in support of CSRA management.

Fundamental Components included but are not limited to:

  • This position is with Aetna Medicaid Administrators.

  • Perform analysis to assess root cause of moderately complex (multiple interfaces with other systems within a single business unit) customer issues for reported system defects and control deficiencies found from system audits.

  • This includes recreating the problem and managing the issues to closure.

  • Conduct interviews, fact-finding, and independent research to design creative, progressive solutions to system issues.

  • Document business impact of system issue.

  • Develop and communicate effective short-term workaround procedures to address system issues.

  • Assist with the management and resolution of unplanned hard system outages.

  • Contribute to the communication process to impacted customers and internal management personnel.

  • Document, track, and resolve issues related to data quality.

  • Assist in the development of Product Overviews, FAQs, Tool Glossaries, system training material, and system user documentation to support implementation activities.

  • Support business area operations/functions by setting up /modifying / maintaining simple to complex system operating parameters by designing and configuring business rule table entries, and/or complex macros/automated scripts.

  • Provide day to day support of these items to ensure they work properly (including the application of appropriate QA procedures) and to quickly fix any identified defects.

  • Complete activities within Standard Level Agreements and proactively identifies and communicates issues that may jeopardize delivery dates or budget to the Supervisor or Manager.

  • Determine root cause analysis of system issues.

  • Coordinate with peers to analyze issues and provide end to end resolutions.

Qualifications Requirements and Preferences:

  • Minimum of two years of experience researching and generating SQL queries and procedures, either as a Technical or Business Analyst.

  • Experience must include performing data analysis, data management, business process analysis, and preparing reports and dashboards to determine root cause analysis of system issues.

  • Must have experience performing database manipulation, query optimization and ETL; importing and exporting data from external data sources; creating pivot tables; and implementing operating procedures to bridge data gaps.

  • Experience with SSIS; MS SQL server 2012; Ultra Edit Editor; BMC Remedy; and Claims processing system QNXT.

Functional Skills:

Information Management - Business information analysis, Information Technology - Application development, Project Management - Issue identification and analysis

Technology Experience:

Database - SQL Server, Development Experience - Client/Server, System Management - Technical Troubleshooting

Required Skills:

Technology - Developing Competitive Technology and Architecture, Technology - Developing Software Solutions, Technology - Promoting Emerging Technology

Desired Skills:

General Business - Maximizing Work Practices, Leadership - Collaborating for Results

Benefit Eligibility

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

Job Function: Healthcare

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.

DirectEmployers