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.
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.
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
• verbal and written communication skills
• High School (HS) (Required)
• 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