Description

This position will follow our hybrid work model, we expect the selected candidate to be in office 2-3 days a week at one of the following office locations: St. Petersburg, FL;

Job Summary

We are seeking a talented and experienced Data Engineer to join our team in designing, developing, and optimizing data pipelines and ETL processes in the journey of Raymond James to develop a leading Wealth Management Platform. In this role, you will collaborate closely with business owners of multiple product areas, Enterprise data teams, and application development teams, leveraging your expertise in SQL, Oracle, stored procedures, SSIS, and Integration Services/ODI to ensure the seamless ingestion, integration, transformation, and orchestration of data. You will write complex stored procedures to curate data from central data stores and surface it in meaningful ways to business leaders and external partners to support daily operations and business intelligence. Your experience with complex ETL pipelines will be instrumental in creating a scalable, high-performance data environment. This role will follow a hybrid workstyle in the following location: Saint Petersburg, FL.

Essential Duties and Responsibilities:

• Collaborate with business owners and external partners to understand business requirements and data integration needs, translate them into effective data solutions, and deliver top-quality outcomes.

• Implement and manage end-to-end data pipelines, ensuring data accuracy, reliability, data quality, performance, and timeliness.

• Collaborate with Data engineering and Development teams to design, develop, test, and maintain robust and scalable ELT/ETL pipelines using SQL scripts, stored procedures, and other tools and services.

• Work independently to prioritize and execute approved tasks to meet deadlines and budget constraints.

• Organize, manage, and track multiple detailed tasks and assignments with frequently changing priorities in a fast-paced work environment.

• Work closely with change management team to maintain a well-organized and documented repository of codes, scripts, and configurations using Azure.

• Proactively identify opportunities to automate tasks and develop reusable frameworks.

• Provide and maintain detailed documentation of all solutions.

• Collaborate with other technical teams to troubleshoot incidents as they occur.

• Establish and maintain effective working relationships at all levels of the organization, including negotiating resources.

• Perform other duties and responsibilities as assigned.

Qualifications

Knowledge of:

• Financial Services Industry knowledge is a plus.

• SSIS or ODI experience is essential.

Skill in:

• Must have relevant experience in various database platforms, ETL solutions/products, ETL architecture.

• Expert-level experience with Oracle (or similar DB platforms), ETL architecture, and development.

• Expert level experience in Performance Optimization of ETL and Database (Oracle – SQL, PLSQL or similar)

• Expert-level experience with efficient Data Integration patterns/technologies.

• Experience with Oracle Data Integrator (ODI) or SQL Server Integration Services (SSIS).

• Experience with Tableau, Qlik Sense, Thought Spot, or other BI visualization tools.

• Strong coding and problem-solving skills, and attention to detail in data quality and accuracy.

• Proficiency in SQL programming and stored procedures for efficient data manipulation and transformation.

• Experience working with large-scale, high-volume data environments.

• Deep experience in SQL tuning, tuning ETL solutions, physical optimization of databases.

• Ability to navigate internal documentation to find appropriate resources to achieve success.

Education/Previous Experience

• TYPICALLY requires a Bachelor's degree; 3-5 years of relevant experience. May have one or more technical or business-related certifications.

Job: Technology

Primary Location: US-FL-St. Petersburg-Saint Petersburg

Other Locations: US-FL-Clearwater-Clearwater, US-FL-Tampa-Tampa, US-FL-St. Petersburg-Saint Petersburg

Organization Technology

Schedule Full-time

Job Shift Day Job

Travel Yes, 5 % of the Time

Req ID: 2401368