Lead Data Engineer

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.

Responsibilities

Lead design, development, testing, deployment, and support of scalable, high-performance data solutions; Provide technical leadership across KTLO, RTB, and CTB initiatives; Drive application modernization, CSS decommissioning initiatives, system enhancements, and technology improvement efforts; Mentor engineering team members; 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; Analyze and resolve complex data, database, and application performance issues; Develop and maintain data integration solutions; Translate functional and technical requirements into scalable, secure, and maintainable application solutions; Collaborate with Product Owners, Business Analysts, QA, DevOps, and Project Managers; Participate in architecture reviews, technical design reviews, and code reviews; Provide technical leadership for production support activities; Lead troubleshooting efforts for production incidents and perform root cause analysis; Monitor application performance, data processing activities, and operational metrics; Support release management, deployment validation, operational readiness, disaster recovery planning; Design, develop, and support enterprise batch-processing solutions utilizing BMC Control-M and related job scheduling platforms; Manage job scheduling, workflow orchestration, monitoring, recovery processes; Identify automation opportunities and develop automation solutions; Leverage AI-powered development tools such as GitHub Copilot, Claude Code, and Microsoft Copilot; Apply AI-assisted engineering practices; Promote responsible adoption of AI technologies; Build strong partnerships across business and technology organizations; Support application modernization, system decommissioning, and strategic transformation programs; Communicate technical risks, recommendations, and solution approaches; Evaluate emerging technologies and develop proof-of-concepts

Requirements

Bachelor's degree (required); 6-10 years of general experience; Deep expertise in Oracle database development, data engineering, application integration, and production support; Strong technical leadership and problem-solving capabilities; Hands-on experience with Oracle SQL, PL/SQL, enterprise job scheduling platforms, automation, and modern software delivery practices; Proficiency in leveraging AI-enabled engineering tools and practices; Not eligible for work visa sponsorship; Less than 25% travel

Benefits

Additional compensation (cash or equity); Discretionary bonuses; Commissions; Medical, dental, and vision insurance; Life insurance; Critical illness insurance and accident insurance; Disability benefits; Retirement savings; Paid time off (vacation, holidays, and sick leave); Parental leave