Lead Data Integration Engineer
Raymond James
•
St. Petersburg, FL
0
0
0
0
Not Applicable
Posted April 17, 2026
Job link
Thinking about this job
Responsibilities
Commitments
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.
- Make prompt, pragmatic choices and act with the client in mind
Commitments
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.
Travel
Less than 25%
Workstyle
Hybrid
Not Met Priorities
What still needs stronger evidence
Requirements
- 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.
- MS SQL Server & SQL Proficiency: Deep expertise in writing and optimizing complex SQL queries, stored procedures, functions, and triggers is fundamental.
- SSIS Expertise: In-depth knowledge of designing, developing, deploying, and maintaining ETL (Extract, Transform, Load) processes and packages using SQL Server Integration Services (SSIS).
- This includes robust error handling and logging mechanisms.
- ETL & Data Warehousing: Strong understanding of ETL methodologies, data warehousing concepts (e.g., Kimball methodology, star schemas), and data modeling techniques (normalization/denormalization).
- Performance Tuning: Ability to identify, investigate, and resolve database and ETL performance issues, including capacity and scalability planning.
- Programming Languages: Proficiency in additional programming/scripting languages, such as Python or PowerShell/Shell scripting, for automation, data manipulation, and pipeline development.
- Excellent communication, analytical, and problem-solving skills.
- General Experience - 6 to 10 years
Preferred Skills
- Are you an expert in MS SQL Server & SSIS development who learned python and cloud engineering to stay ahead of the curve?
- Experience with job scheduler tools such as BMC Control-M
- ETL & Data Warehousing: Strong understanding of ETL methodologies, data warehousing concepts (e.g., Kimball methodology, star schemas), and data modeling techniques (normalization/denormalization).
- Programming Languages: Proficiency in additional programming/scripting languages, such as Python or PowerShell/Shell scripting, for automation, data manipulation, and pipeline development.
- Cloud & DevOps (Desired): Familiarity with cloud platforms (e.g., Azure Data Factory, AWS Glue, Google Cloud) and experience implementing CI/CD pipelines and DevOps practices for data solutions is a strong advantage.
- Exposure to streaming technologies such as Kafka is a plus.
- Experience in financial services or enterprise-scale applications is preferred.
Education
- (Required) – Bachelor’s: Computer and Information Science (Required), High School (HS) (Required)
Job Description Summary
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
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.
Skills
MS SQL Server & SQL Proficiency: Deep expertise in writing and optimizing complex SQL queries, stored procedures, functions, and triggers is fundamental.
SSIS Expertise: In-depth knowledge of designing, developing, deploying, and maintaining ETL (Extract, Transform, Load) processes and packages using SQL Server Integration Services (SSIS). This includes robust error handling and logging mechanisms.
ETL & Data Warehousing: Strong understanding of ETL methodologies, data warehousing concepts (e.g., Kimball methodology, star schemas), and data modeling techniques (normalization/denormalization).
Performance Tuning: Ability to identify, investigate, and resolve database and ETL performance issues, including capacity and scalability planning.
Programming Languages: Proficiency in additional programming/scripting languages, such as Python or PowerShell/Shell scripting, for automation, data manipulation, and pipeline development.
Cloud & DevOps (Desired): Familiarity with cloud platforms (e.g., Azure Data Factory, AWS Glue, Google Cloud) and experience implementing CI/CD pipelines and DevOps practices for data solutions is a strong advantage.
Exposure to streaming technologies such as Kafka is a plus.
Experience in financial services or enterprise-scale applications is preferred.
Excellent communication, analytical, and problem-solving skills.
Education
Bachelor’s: Computer and Information Science (Required), High School (HS) (Required)
Work Experience
General Experience - 6 to 10 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.
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
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.
Skills
MS SQL Server & SQL Proficiency: Deep expertise in writing and optimizing complex SQL queries, stored procedures, functions, and triggers is fundamental.
SSIS Expertise: In-depth knowledge of designing, developing, deploying, and maintaining ETL (Extract, Transform, Load) processes and packages using SQL Server Integration Services (SSIS). This includes robust error handling and logging mechanisms.
ETL & Data Warehousing: Strong understanding of ETL methodologies, data warehousing concepts (e.g., Kimball methodology, star schemas), and data modeling techniques (normalization/denormalization).
Performance Tuning: Ability to identify, investigate, and resolve database and ETL performance issues, including capacity and scalability planning.
Programming Languages: Proficiency in additional programming/scripting languages, such as Python or PowerShell/Shell scripting, for automation, data manipulation, and pipeline development.
Cloud & DevOps (Desired): Familiarity with cloud platforms (e.g., Azure Data Factory, AWS Glue, Google Cloud) and experience implementing CI/CD pipelines and DevOps practices for data solutions is a strong advantage.
Exposure to streaming technologies such as Kafka is a plus.
Experience in financial services or enterprise-scale applications is preferred.
Excellent communication, analytical, and problem-solving skills.
Education
Bachelor’s: Computer and Information Science (Required), High School (HS) (Required)
Work Experience
General Experience - 6 to 10 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.