Lead Data Engineer (ODI/ELT/ETL)

Saint Petersburg, Florida


Employer: Raymond James Financial Incorporated
Industry: Technology
Salary: Competitive
Job type: Full-Time

Note: This position will follow our hybrid work model, we expect the selected candidate to be in the office 8 days per month in one of the following corporate locations: St. Petersburg, FL; Memphis, TN; or Southfield, MI.

Job Summary:

As part of the Cash Management development team, the Lead Data Engineer will take a lead role in building Enterprise Data Integration solutions by working on enterprise-class data integration initiatives. This team is responsible for application development, modification, maintenance, and support for the following areas: Annual Fees, Capital Access, Cash Management, and Retirement Planning Services. The Lead Data Engineer will be responsible for building solutions which are flexible, performant, and scalable. Works closely with Solution Architects and other Engineers to build ETL Data flows and design patterns. Handles complex problems independently and demonstrates analytical thinking. Is able to make judgements and recommendations based on the analysis and interpretation of data.

Essential Duties and Responsibilities:

• Builds scalable and reliable ETL/ELT systems to pull large and complex data together efficiently.

• Develop ETL/Data Integration/Data Processing Flows.

• Provides subject matter expertise and collaborates with other Engineers to build optimal and efficient ETL/ELT and Database code.

• Supports ETL Batch processing.

• Provides on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.

• Performs other duties and responsibilities as assigned.

Qualifications:

Knowledge, Skills, and Abilities:

Advanced knowledge of the following:

• Data Integration patterns/technologies.

• Oracle Data Integrator (ODI).

• Oracle as a database platform and PL/SQL.

• Full Software Development Life Cycle (SDLC) experience.

• Experience with TFS or JIRA or any other requirements management tool.

• Experience with CI/CD practices and using software version control tools (e.g., GIT).

• Experience working in Agile, Waterfall and Hybrid software development methodologies.

Experience with the following is a plus:

• Building low latency Data Integration solutions.

• Prototyping and automating Data Integration Processes.

• Physical Performance Optimization of Oracle Databases.

• Development experience using SQL Server and SSIS.

• Experience with messaging platforms (e.g., IBM MQ).

• Financial Services Industry knowledge.

Education/Previous Experience:

• Minimum of a Bachelor's degree in Computer Science, MIS, Business or related degree and five (5) years of relevant experience or a combination of education, training and experience approved by HR.

Licenses/Certifications:

• None required.

Raymond James Guiding Behaviors

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 outcome

• 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

Created: 2024-05-08
Reference: 2401580
Country: United States
State: Florida
City: Saint Petersburg


Similar jobs: