Lead Data Engineer

Job Description Summary

This position follows our hybrid workstyle policy: expected to be in a Raymond James office location three days per week, with at least one of those days being a Monday or a Friday.

Please note: This role is not eligible for Work Visa sponsorship, either currently or in the future.

Job Description

Job Description Summary

As part of the Wealth Management Technology organization, the Lead Data Engineer, Apps Dev serves as a technical leader within the Annuity and Life Insurance Solutions team, supporting critical enterprise applications, data solutions, and business initiatives. This role is responsible for delivering scalable, secure, and efficient technology solutions that support business operations, application modernization, production stability, and strategic technology objectives across the Wealth Management department.

The ideal candidate combines deep expertise in Oracle database development, data engineering, application integration, and production support with strong technical leadership and problem-solving capabilities. This position plays a key role in supporting Annuity and Life Insurance initiatives, including application modernization, CSS decommissioning initiatives, platform enhancements, system decommission efforts, and ongoing operational excellence, while partnering closely with business and technology stakeholders to deliver reliable, high-quality solutions.

This role requires hands-on experience with Oracle SQL, PL/SQL, enterprise job scheduling platforms, automation, and modern software delivery practices. The Lead Data Engineer will lead technical design, development, implementation, troubleshooting, and continuous improvement initiatives while promoting engineering best practices, supporting Agile delivery teams, and ensuring operational excellence across critical business applications. The successful candidate will demonstrate a strong balance of technical expertise, business acumen, and leadership skills to influence outcomes, mentor team members, reduce operational risk, and drive the successful delivery of innovative technology solutions that support advisor, client, and business needs. The role also requires proficiency in leveraging AI-enabled engineering tools and practices to improve productivity, code quality, documentation, testing, and delivery efficiency while maintaining accountability for solution quality, security, and performance.

Responsibilities

Technical Leadership & Solution Delivery

• Lead the design, development, testing, deployment, and support of scalable, high-performance data solutions supporting Annuity and Life Insurance applications.

• Provide technical leadership across KTLO, RTB, and CTB initiatives, ensuring successful delivery of business and technology objectives.

• Drive application modernization, CSS decommissioning initiatives, system enhancements, and technology improvement efforts while maintaining operational stability.

• Mentor engineering team members and promote engineering excellence through technical guidance, knowledge sharing, and best practices.

Oracle Database & Data Engineering

• Design, develop, and optimize Oracle SQL, PL/SQL stored procedures, database packages, functions, and performance-tuned queries.

• Perform database design, data modeling, performance tuning, query optimization, and capacity planning for enterprise applications.

• Analyze and resolve complex data, database, and application performance issues to ensure reliability, scalability, and operational efficiency.

• Develop and maintain data integration solutions supporting business-critical processes and enterprise applications.

Application Development & Integration

• Analyze business and system requirements to identify application interactions, data flows, dependencies, and integration points.

• Translate functional and technical requirements into scalable, secure, and maintainable application solutions.

• Collaborate with Product Owners, Business Analysts, QA, DevOps, and Project Managers to deliver high-quality technology solutions.

• Participate in architecture reviews, technical design reviews, and code reviews to ensure compliance with enterprise standards and engineering best practices.

Production Support & Operational Excellence

• Provide technical leadership for production support activities across critical Annuity and Life Insurance applications.

• Lead troubleshooting efforts for production incidents, perform root cause analysis, and implement long-term corrective actions.

• <