Job Description
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
Apply Now
Apply Now