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 multiple application development teams and other shared services teams, leveraging your expertise in SQL, stored procedures, AWS services to ensure the seamless ingestion, integration, transformation and orchestration of data. Your experience with complex ETL pipelines will be instrumental in creating a scalable, high-performance data environment. By adhering to best practices and industry standards, you will collaborate with our engineering and data teams to design forward thinking solutions. This role will follow a hybrid workstyle in the following location: Saint Petersburg, FL.
Essential Duties and Responsibilities:
• Responsible for developing highly optimized low latency Data Integration solutions.
• 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.
• Collaborate with our Development and Data teams to understand business requirements and data integration needs, translate them into effective data solutions and resulting in top-quality outcomes.
• Implement, and manage end-to-end data pipelines, ensuring data accuracy, reliability, data quality, performance, and timeliness.
• Responsible for writing code which conforms to standards and best practices and is highly efficient.
• Perform data profiling and analysis to troubleshoot data-related challenges / issues and build solutions to address those concerns.
• Work closely with version control team to maintain a well-organized and documented repository of codes, scripts, and configurations using Git.
• Proactively identify opportunities to automate tasks and develop reusable frameworks.
• Provide technical guidance and mentorship to fellow developers, sharing insights into best practices, tips, and techniques for optimizing data solutions.
• Provides on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.
• Performs other duties and responsibilities as assigned.
Qualifications:
Knowledge, Skills, and Abilities:
Knowledge of:
• AWS Services and Redshift experience is a plus.
• Experience with Search Platforms like SOLR is a plus.
• Understanding of Master Data Management (MDM) principles is a plus.
• Financial Services Industry knowledge is a plus.
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 in building low latency Data Integration solutions.
• Experience with Oracle Data Integrator (ODI).
• Knowledge or experience with AWS services such as Redshift and other pertinent data technologies,
• 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:
• Identify and understand issues, problems and opportunities; compare data from different sources to draw conclusions.
• Ability to work collaboratively in a fast-paced, agile environment and effectively communicate technical concepts to non-technical stakeholders.
• Proven track record of delivering high-quality data solutions within designated timelines.
• Use effective approaches for choosing a course of action or developing appropriate solutions; recommend or take action that is consistent with available facts, constraints and probable consequences.
• Demonstrate a satisfactory level of technical and professional skill or knowledge in position-related areas; remains current with developments and trends in areas of expertise.
• Develop and use collaborative relationships to facilitate the accomplishment of work goals.
• Make internal and external clients and their needs a primary focus of actions; develop and sustain productive client relationships.
• Occasionally work a non-standard shift including nights and/or weekends and/or have on-call responsibilities.
• Excellent interpersonal skills and be able to build consensus across teams.
Education/Previous Experience:
• Minimum of a Bachelor's degree in Computer Science, MIS or related degree with three(3) to five (5) years of relevant development or engineering experience or combination of education, training and experience.
Raymond James Guiding Behaviors
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 outcome
• 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