Application Development Lead Analyst

In this role, you will provide hands-on software engineering and production support for one of our enterprise Finance Technology teams. You will be working on enterprise financial and accounting systems critical to the operational success of Evernorth Health Services, US Employer, and International business segments within The Cigna Group.

Requirements

• Expert in building reports using Oracle Application Express (APEX) tool.
• Strong knowledge of Apex Office Printing (AOP) configuration and template development.
• Working experience with Virtual Trader is strong plus.
• Design, develop, and enhance financial reports using Insight Spreadsheet Server for Oracle ERP.
• Hands-on experience with Insight Software Spreadsheet Server, including report building and administration.
• Automate tasks and reports using Visual Basic for Applications (VBA) in Excel.
• Integrate and transform data from Oracle and other sources for use in spreadsheet and PDF reporting.
• Knowledge of Spreadsheet server excel add on tool, Angles for Oracle Replication tool
• Proficiency in SQL and PL/SQL is crucial.
• Monitor and support scheduled and ad-hoc report generation across all platforms (Spreadsheet Server, AOP, BI Publisher).
• Experience with SQL and PL/SQL for custom data extraction and troubleshooting.
• Expertise in data models, data flows and data visualizations concepts.
• Knowledge about On-premises to Cloud data migration and vice versa.
• Expertise in most of the following technologies- Advanced Microsoft Excel, BI, ETL Tools.
• Expertise in agile methodology including SCRUM team leadership.
• Familiarity with Oracle Cloud Infrastructure (OCI) or Oracle Fusion Applications.
• Exposure to ServiceNow, Jira, or other ITSM tools for incident/change management.
• Solid understanding of Oracle ERP (EBS or Fusion) data structures and reporting requirements.
• Knowledge of financial processes such as General Ledger, AP/AR, Fixed Assets and Operational Expenses.
• Work closely with finance and business users to gather requirements and translate them into efficient reporting solutions.
• Strong written and verbal communication skills with the ability to interact with all levels of the organization.

Benefits

• Equal Opportunity Employer actively encouraging and supporting organization-wide involvement of staff in diversity, equity, and inclusion efforts to educate, inform and advance both internal practices and external work with diverse client populations.