Lead Python/SQL Developer- Data Integration Engineer

Raymond James•St. Petersburg, FL

3d•Hybrid

About The Position

Are you an expert in MS SQL Server & SSIS development who learned python and cloud engineering to stay ahead of the curve? We are seeking a lead data engineer to maintain and support our critical Pre-trade clearance system while working on re-engineering our entire data stack into AWS using python. Job Description This position follows our hybrid workstyle policy: Expected to be in a Raymond James office location a minimum of 10-12 days a month. Please note: This role is not eligible for Work Visa sponsorship, either currently or in the future.

Requirements

Microsoft SQL Server
SSIS
SQL development
Python
Oracle databases
PL/SQL development
CI/CD pipelines
DevOps practices
data warehousing concepts
ETL methodologies
data modeling techniques
Unix
Shell scripting
job scheduler tools such as BMC Control-M
waterfall and agile SDLC frameworks
Financial Services industry including middle and back-office functions
collaborating with business counterparts to understand detailed requirements
verbal and written communication skills
High School (HS)
General Experience - 6 to 10 years

Nice To Haves

Experience in AWS Glue, Glue Streaming, Lambda, S3, Athena, Iceberg, AWS SageMaker and Redshift for advanced analytics and AI-driven insights
Understanding of data governance frameworks

Responsibilities

Deep expertise in Microsoft SQL Server, SSIS, and SQL development.
Strong proficiency in writing and optimizing complex stored procedures, functions, and packages.
Hands-on experience with Python for data manipulation, automation, and pipeline development.
Familiarity with Oracle databases and PL/SQL development is required for cross-platform data integration.
Experience in implementing CI/CD pipelines and DevOps practices for data solutions.
Understanding data warehousing concepts, ETL methodologies, and data modeling techniques.
Experience with Unix and Shell scripting
Experience with job scheduler tools such as BMC Control-M
Proven track record working in both waterfall and agile SDLC frameworks
Knowledge of the Financial Services industry including middle and back-office functions
Experience in collaborating with business counterparts to understand detailed requirements
Excellent verbal and written communication skills
Produce and maintain detailed technical documentation for all development efforts.