Software Engineering Advisor

Job Summary

The Software Engineer provides expert content/professional leadership on complex Engineering assignments/projects.

Designs and develops a consolidated, conformed enterprise data warehouse and data lake which store all critical data across Customer, Provider, Claims, Client and Benefits data.

Designs, develops and implements methods, processes, tools and analyses to sift through large amounts of data stored in a data warehouse or data mart to find relationships and patterns.

Participates in the delivery of the definitive enterprise information environment that enables strategic decision-making capabilities across enterprise via an analytics and reporting.

Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives.

Uses deep professional knowledge and acumen to advise functional leaders.

Focuses on providing thought leadership within Information Management but works on broader projects, which require understanding of wider business.

Recognized internally as a subject matter expert.

Responsibilities:


* Design, develop, and implement Oracle applications and database solutions to meet business requirements.


* Collaborate with cross-functional teams to gather and document technical requirements.


* Perform complex Oracle database tuning, optimization, and performance monitoring.


* Develop and maintain PL/SQL packages, procedures, functions, and triggers.


* Provide technical leadership and mentorship to junior developers.


* Maintain and enhance existing Oracle applications, ensuring high levels of data quality and availability.


* Participate in the full software development lifecycle, including design, coding, testing, debugging, and documentation.


* Stay up-to-date with the latest Oracle technologies and best practices, and provide recommendations for process improvements.

Qualifications:


* Bachelor's degree in Computer Science, Information Technology, or a related field.


* Minimum of 5 years of experience in Oracle development, including PL/SQL, Oracle Forms, stored procedures/functions, indexes, views and Reports.


* Excellent problem-solving skills, with the ability to troubleshoot complex software issues.


* Strong verbal and written communication skills, with the ability to effectively communicate complex technical concepts to both technical and non-technical stakeholders.


* Proven experience in leading and mentoring junior developers.


* Demonstrated ability to work effectively in a fast-paced, dynamic environment.


* Strong attention to detail, with a commitment to high quality and accuracy.


* Oracle Certified Professional (OCP) certification is a plus.

If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.

About The Cigna Group

Doing s...