Fidelity Investments

Senior Data Engineer - Oracle SQL and PL/SQL

Fidelity Investments

Chicago, IL, USA
Full-TimeDepends on ExperienceSenior LevelMasters
Job Description

Are you ready to take on a challenging and rewarding role as a Senior Data Engineer at Fidelity Investments? We are seeking a highly skilled and experienced individual with a passion for data and a strong background in Oracle SQL and PL/SQL. As a member of our dynamic team, you will play a critical role in designing, developing, and maintaining our data architecture to support our business needs. If you have a strong understanding of data structures and a drive to constantly improve and optimize data processes, we want to hear from you. Join us in shaping the future of data at Fidelity Investments.

  1. Design and Develop Data Architecture: The Senior Data Engineer will be responsible for designing and developing the data architecture at Fidelity Investments. This includes understanding business requirements and translating them into efficient and scalable data structures.
  2. Maintain and Optimize Data Processes: The Senior Data Engineer will play a critical role in maintaining and optimizing data processes to ensure smooth and efficient data flows. This includes identifying and resolving data-related issues and constantly seeking ways to improve and optimize data processes.
  3. Technical Expertise: The candidate must have a strong background in Oracle SQL and PL/SQL, as well as a deep understanding of data structures and database design. The Senior Data Engineer will be responsible for utilizing their technical expertise to design and develop effective data solutions.
  4. Collaborate with Team: The Senior Data Engineer will work closely with the team to understand business needs and align data processes accordingly. They will also collaborate with other data engineers and data analysts to ensure a cohesive and efficient data ecosystem.
  5. Stay Updated on Industry Trends: The candidate must have a passion for data and a drive to constantly improve and optimize data processes. This includes staying updated on industry trends and implementing new technologies and techniques to enhance data processes at Fidelity Investments.
  6. Data Security and Compliance: The Senior Data Engineer will be responsible for ensuring data security and compliance with regulations and policies. This includes implementing proper data access controls and monitoring data usage to maintain data integrity and protect sensitive information.
  7. Project Management: The Senior Data Engineer will be responsible for managing data-related projects, including defining project scope, creating timelines, and ensuring timely and successful project delivery.
  8. Troubleshooting and Problem-Solving: In this role, the Senior Data Engineer will be responsible for troubleshooting data-related issues and identifying and implementing solutions in a timely manner.
  9. Documentation: The Senior Data Engineer will be responsible for documenting data architecture, processes, and solutions, ensuring that all information is accurate and up-to-date.
  10. Mentorship and Training: As a
Where is this job?
This job is located at Chicago, IL, USA
Job Qualifications
  • Extensive Experience With Oracle Sql And Pl/Sql: The Ideal Candidate Should Have A Minimum Of 5 Years Of Hands-On Experience Working With Oracle Sql And Pl/Sql. They Should Be Able To Write Efficient And Optimized Queries, And Have A Deep Understanding Of Database Design Principles.

  • Proficiency In Data Modeling And Etl Processes: The Senior Data Engineer Should Have A Strong Understanding Of Data Modeling Techniques And Be Able To Design And Implement Complex Etl Processes. They Should Have Experience Working With Large Datasets And Be Able To Optimize Data Pipelines For Performance And Scalability.

  • Knowledge Of Data Warehousing And Business Intelligence Tools: A Strong Understanding Of Data Warehousing Concepts And Experience Working With Business Intelligence Tools Such As Tableau Or Power Bi Is Essential For This Role. The Candidate Should Be Able To Design And Develop Data Models To Support Reporting And Analytics Needs.

  • Familiarity With Cloud Computing And Big Data Technologies: As Fidelity Investments Continues To Expand Its Use Of Cloud Computing And Big Data Technologies, The Senior Data Engineer Should Have Experience Working With These Technologies. Knowledge Of Tools Such As Aws, Hadoop, And Spark Is Highly Desirable.

  • Strong Analytical And Problem-Solving Skills: In Addition To Technical Expertise, The Ideal Candidate Should Possess Strong Analytical And Problem-Solving Skills. They Should Be Able To Identify And Troubleshoot Data-Related Issues And Provide Effective Solutions. The Ability To Work In A Fast-Paced And Dynamic Environment Is Also Crucial For Success In This Role.

Required Skills
  • Data Analysis

  • Database Management

  • Data Modeling

  • Scripting

  • Data warehousing

  • Data integration

  • Performance tuning

  • Data transformation

  • Data migration

  • Database design

  • ETL Development

Soft Skills
  • Communication

  • Conflict Resolution

  • Leadership

  • Time management

  • creativity

  • Critical thinking

  • Attention to detail

  • Teamwork

  • Adaptability

  • Problem-Solving

Compensation

According to JobzMall, the average salary range for a Senior Data Engineer - Oracle SQL and PL/SQL in Chicago, IL, USA is $120,000 to $180,000 per year. This range can vary depending on factors such as years of experience, specific skills and certifications, and the company's size and industry.

Additional Information
Fidelity Investments is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based upon race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
Required LanguagesEnglish
Job PostedJanuary 30th, 2024
Apply BeforeJune 21st, 2025
This job posting is from a verified source. 
Reposted

Apply with Video Cover Letter Add a warm greeting to your application and stand out!

About Fidelity Investments

Fidelity Investments Inc., commonly referred to as Fidelity, earlier as Fidelity Management & Research or FMR, is an American multinational financial services corporation based in Boston, Massachusetts.

Frequently asked questions

Get interviewed today!

JobzMall is the world‘ s largest video talent marketplace.It‘s ultrafast, fun, and human.

Get Started