Senior Engineer, Database Engineering

Raymond James•Saint Petersburg, FL

1d•Hybrid

About The Position

DUTIES: Design, develop, and maintain ETL/Data Integration/Data Processing Flows using Oracle Data Integrator (ODI). Ensure data quality and integrity across various data sources and downstream applications. Design and implement data warehouse solutions to support business intelligence and analytics needs. Develop and maintain complex PL/SQL scripts and stored procedure. Perform database tuning and optimization ETL processes for performance and scalability. Utilize scheduling tools to automate and schedule jobs, ensuring adherence to necessary scheduling dependencies and execution sequences. Ensure timely and reliable data processing through effective job scheduling. Monitor job execution and troubleshoot any issues that arise. Utilize version control systems to manage codebase and track changes. Collaborate with cross-functional teams using project management tools like JIRA and TFS. Lead and participate in all phases of the project life cycle, from requirements gathering to deployment. Collaborate with business stakeholders to understand reporting requirements and deliver actionable insights. Support ETL Batch processing. Provide on-call support of Data Integration Batch processes on a rotating basis and other on-call as required. Perform other duties and responsibilities assigned. REQUIREMENTS: Bachelor’s degree in Computer Science, MIS, Business or related. Five (5) years in any occupation with Oracle Data Integrator (ODI) and experience in managing and optimizing ETL processes. Five (5) years in any occupation with Oracle Data Integrator (ODI) and experience in managing and optimizing ETL processes must include: Five (5) years of experience with PL/SQL development. Five (5) years of experience with Agile, Waterfall and Hybrid software development methodologies. Five (5) years of experience with Full Software Development Life Cycle (SDLC) . Four (4) years of experience with Building low latency Data Integration solutions. Four (4) years of experience with Prototyping and automating Data Integration Processes. Four (4) years of experience with Performance Optimization of Oracle Databases. Four (4) years of experience with Financial Services Industry. Three (3) years of experience with TFS, JIRA or any other requirements management tool. Two (2) years of experience with CI/CD practices and using software version control tools such as GIT. SALARY: $159,723 per year Education Work Experience Certifications Travel Less than 25% Workstyle Hybrid At Raymond James our associates use five guiding behaviors (Develop, Collaborate, Decide, Deliver, Improve) to deliver on the firm's core values of client-first, integrity, independence and a conservative, long-term view. We expect our associates at all levels to: • Grow professionally and inspire others to do the same • Work with and through others to achieve desired outcomes • Make prompt, pragmatic choices and act with the client in mind • Take ownership and hold themselves and others accountable for delivering results that matter • Contribute to the continuous evolution of the firm At Raymond James – as part of our people-first culture, we honor, value, and respect the uniqueness, experiences, and backgrounds of all of our Associates. When associates bring their best authentic selves, our organization, clients, and communities thrive. The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs. Raymond James is a diversified financial services company providing wealth management, capital markets, asset management, banking and other services to individuals, corporations and municipalities. Founded in 1962 in St. Petersburg, Florida, rather than on Wall Street, we have always embraced being a different kind of financial services firm. Today, Raymond James has locations and subsidiaries across the United States, Canada, the United Kingdom and Germany, and is listed on the New York Stock Exchange under the symbol RJF. Thanks for your interest in working with Raymond James. While we might not have the perfect role for you today, we'd love to keep in touch. Join our Talent Network to stay up to date on career opportunities that may be a good fit for you. Our business is deeply focused on people and their financial well-being. We're committed to helping individuals, corporations and institutions achieve their goals, while also supporting successful professionals and helping our communities prosper. We believe doing well and doing good aren't mutually exclusive. As an established but ever-evolving company, you can start – or continue – growing your career here. We invest in you with wide-ranging benefits and the support of leaders and colleagues who care. From development opportunities and enriching networking groups to prioritizing diversity, inclusion and the power of different perspectives, Raymond James is where good people grow. Our people-first culture is outlined in our Culture Blueprint. Check it out to see why many choose to work at Raymond James – and why they stay.

Requirements

Bachelor’s degree in Computer Science, MIS, Business or related.
Five (5) years in any occupation with Oracle Data Integrator (ODI) and experience in managing and optimizing ETL processes.
Five (5) years in any occupation with Oracle Data Integrator (ODI) and experience in managing and optimizing ETL processes must include:
Five (5) years of experience with PL/SQL development.
Five (5) years of experience with Agile, Waterfall and Hybrid software development methodologies.
Five (5) years of experience with Full Software Development Life Cycle (SDLC) .
Four (4) years of experience with Building low latency Data Integration solutions.
Four (4) years of experience with Prototyping and automating Data Integration Processes.
Four (4) years of experience with Performance Optimization of Oracle Databases.
Four (4) years of experience with Financial Services Industry.
Three (3) years of experience with TFS, JIRA or any other requirements management tool.
Two (2) years of experience with CI/CD practices and using software version control tools such as GIT.

Responsibilities

Design, develop, and maintain ETL/Data Integration/Data Processing Flows using Oracle Data Integrator (ODI).
Ensure data quality and integrity across various data sources and downstream applications.
Design and implement data warehouse solutions to support business intelligence and analytics needs.
Develop and maintain complex PL/SQL scripts and stored procedure.
Perform database tuning and optimization ETL processes for performance and scalability.
Utilize scheduling tools to automate and schedule jobs, ensuring adherence to necessary scheduling dependencies and execution sequences.
Ensure timely and reliable data processing through effective job scheduling.
Monitor job execution and troubleshoot any issues that arise.
Utilize version control systems to manage codebase and track changes.
Collaborate with cross-functional teams using project management tools like JIRA and TFS.
Lead and participate in all phases of the project life cycle, from requirements gathering to deployment.
Collaborate with business stakeholders to understand reporting requirements and deliver actionable insights.
Support ETL Batch processing.
Provide on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.
Perform other duties and responsibilities assigned.