Senior Engineer, Oracle/ETL Development

Job Description

Note: This position follows our hybrid-friendly schedule, so you get the best of both worlds - flexibility and collaboration. In office days will be 2-3 per week averaging 10-12 days per month in our St Petersburg, FL Corporate Office.

Job Summary:

As part of the OFSAA development team, this Senior Engineer will analyze business requirements and drive research to design technical solutions. This individual will be involved in sourcing of data from source systems using Oracle Data Integrator (ODI) or other ETL tools into the Oracle Financial System Analytical Application Framework (OFSAA) and is responsible for designing, coding, testing, implementing, maintaining, and supporting the OFSAA application software. Handles complex problems independently and demonstrates analytical thinking. Is able to make judgements and recommendations based on the analysis and interpretation of data.

Responsibilities:

• Develop existing applications and contribute to development of new applications by analyzing and identifying areas for modification and improvement.
• Analyzes system requirements, including identifying program interactions and appropriate interfaces between impacted components and sub systems.
• Translates business requirements into (OFSAA) designs and map data elements from sources to the OFSAA data model.
• Monitor, identify, and correct more complex software defects to maintain fully functioning applications software.
• Writes and/or reviews system specifications, including output requirements and flow charts.
• Design and perform website/applications software tests and respond to user emails to monitor, diagnose, and correct performance issues.
• Ensures proper analysis of problems and programming approaches to prevent rework and schedule slippage.
• Makes recommendations towards the development of new code or to reuse of existing code.
• May lead assigned projects, including assigning tasks, coordinating efforts, and monitoring performance.
• May recommend new technologies and methodologies to management for meeting business needs, resolving problems and exploiting opportunities. Remains current with new technologies.
• Performs other duties and responsibilities as assigned.

Required Skills:

• At least to five (5) years of experience in Design, Development and Support of Data-Driven, all aspects of SDLC in a highly scalable multi-tier applications in distributed environments is preferred.
• Financial services and/or enterprise level experience is required.
• Experience with SQL, PL/SQL modules such as packages, procedures, functions, other database objects is required.
• Experience with ETL/ Data Flow Principles. Extracting, loading of data from source systems is required.
• Experience on the Java, J2EE, REST API .
• Experience with Unix and Shell scripting.
• Experience Job scheduler tools like BMC Control-M, Autosys.
• Experience with Data Warehousing.
• Works without supervision and provides technical guidance when required on analyzing data from multiple sources to draw appropriate conclusions and make suitable recommendations.
• Works without supervision and provides technical guidance when required on developing software using programming languages.
• Works without supervision and provides technical guidance when required on monitoring, diagnosing and fixing technological problems.
• Occasionally work a non-standard shift including nights and/or weekends and/or have on-call responsibilities.
• Excellent written and oral communication skills.

Optional Skills:

• Knowledge on OFSAA Architecture, OFSAA Data Model is preferred.
• Experience with OFSAA technical and business metadata design, developments such as T2T, DT, DQ, PMF, GL Recon is preferred.
• Knowledge of Microsoft Azure DevOps is preferred.
• Knowledge on OFSAA Architecture, OFSAA Data Model is preferred.
• Experience with regulatory reporting, especially in the area of CECL and CCAR are preferred.
• Experience with Business Intelligence and Reporting are preferred.

Licenses/Certifications:

• None required.

Education
Bachelor's: Computer and Information Science, Bachelor's: Computer Engineering, High School (HS) (Required)

Work Experience
General Experience - 3 to 6 years

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.
#LI-NM1