Senior Database Engineer (SSIS/SSRS/ODI)

Note: This position will follow our hybrid work model, we expect the selected candidate to be in the office a minimum of 8 days per month at the St. Petersburg, FL Corporate Office location.

Job Summary:

As part of the Account Transfers development team, the Senior 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: Account Transfers, Mergers/Acquisitions, and Mass Account Transfers.

The Senior 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.
• Development experience using SQL Server and SSIS.
• SSRS experience.
• 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.
• Oracle Data Integrator (ODI).
• 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 three (3) to five (5) years of relevant experience or a combination of education, training and experience approved by HR.
• Five (5) or more years of experience as a Database Engineer would be preferred.

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