Position Description:
Architects, crafts, and develops highly scalable distributed data processing systems and software applications. Writes and optimizes SQL queries and stored procedures using SQL, PL/SQL, Java, Python, and Shell scripting languages for development of data pipelines. Incorporates and streamlines test automation into software application builds, using Continuous Integration/Continuous Delivery (Cl/CD) methodologies - Jenkins, Terracore, GitHub and uDeploy. Creates data driven business solutions using data warehousing, mart concepts, and relational databases -- Oracle, SQL Server, and Snowflake on Amazon Web Services (AWS) Cloud. Implements and supports databases in an Amazon Web Services (AWS) Cloud Infrastructure environment. Creates and maintains database schemas and objects such as tables, views, indexes, and triggers for easy access of database systems. Confers with systems analysts and other software engineers/developers to design systems and to obtain information on project limitations and capabilities, performance requirements, and interfaces.
Primary Responsibilities:
Develops applications on complex projects, components, and subsystems for the division.
Troubleshoots and resolves issues with databases and related systems.
Ensures the delivery of effective, efficient, and high-quality data movement and data integration patterns.
Ensures the scalability, reliability, performance, and security of the databases by performing database tunes and optimization techniques.
Monitors and optimizes database performance by implementing various database designs and models techniques.
Advises senior management on technical strategy.
Acts as a primary liaison for business units to resolve various project/technology issues.
Develops comprehensive documentation for multiple applications or subsystems.
Develops or directs software system tests or validation procedures, programs, or documentation.
Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.
Mentors junior team members.
Education and Experience:
Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and five (5) years of experience as a Principal Data Engineer (or closely related occupation) designing and building highly scalable Business Intelligence (BI) and analytical solutions on Cloud and on-premise platforms in a financial services environment, using Data Warehouse and Mart techniques.
Or, alternatively, Master’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Principal Data Engineer (or closely related occupation) designing and building highly scalable Business Intelligence (BI) and analytical solutions on Cloud and on-premise platforms in a financial services environment, using Data Warehouse and Mart techniques.
Skills and Knowledge:
Candidate must also possess:
Demonstrated Expertise (“DE”) designing and building Data Warehouses and performing Extract, Transform, and Load (ETL) development, using Oracle, PL/SQL, Informatica, Control-M, or UNIX; and building and maintaining (CI/CD) pipelines using Terracore (for application code deployment), Jenkins, GitHub, or uDeploy.
DE coordinating and implementing all aspects of the Software Development Lifecycle (SDLC) in support of applications deployment according to financial services standards, security requirements, software development best practices, and Agile methodologies, using JIRA for project management, and programming languages and frameworks (JavaScript, Node.js, and React).
DE developing Cloud-native applications and migrating on-premise data centric applications to Cloud, using Snowflake and AWS; and migrating data to and from Snowflake data stores by designing and implementing performant ETL/Extract Load, and Transform (ELT) pipelines in Cloud environments, using Python, Snowflake, and SnowSQL.
DE developing effective data solutions that meet end user demands on Snowflake, using Spark SQL and Python; and classifying, analyzing, and governing data assets to ensure data quality and compliance, using Alation and Collibra.
Salary: $155,325.00 to $ 166,000.000/year.
#PE1M2
#LI-DNI
Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.
Skills Required
- Bachelor's degree in Computer Science, Engineering, IT, Information Systems or related plus 5 years as Principal Data Engineer (or foreign equivalent)
- Or Master's degree in Computer Science, Engineering, IT, Information Systems or related plus 3 years as Principal Data Engineer (or foreign equivalent)
- Designing and building Data Warehouses and performing ETL development
- Experience with Oracle and PL/SQL (database development, schemas, objects, performance tuning)
- Experience with Informatica, Control-M, and UNIX for ETL and batch orchestration
- Experience building and maintaining CI/CD pipelines using Terracore, Jenkins, GitHub, or uDeploy
- Developing cloud-native applications and migrating data-centric apps to Snowflake on AWS
- Developing performant ETL/ELT pipelines using Python, Snowflake, and SnowSQL
- Experience with Spark SQL and Python for data processing
- Familiarity with data cataloging and governance tools such as Alation and Collibra
- Knowledge of SDLC, Agile methodologies, JIRA, and software development best practices (including JavaScript, Node.js, React exposure)
- Ability to mentor junior team members and advise senior management on technical strategy
Fidelity Investments Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Fidelity Investments and has not been reviewed or approved by Fidelity Investments.
-
Strong & Reliable Incentives — Bonuses, commissions, and profit-sharing are presented as generous and meaningful components of total compensation, with certain roles achieving high total earnings through multiple pay streams. Variable pay is consistently framed as a positive contributor beyond base salary.
-
Retirement Support — A 401(k) match up to 7% alongside additional profit-sharing up to 10% materially enhances long-term compensation. These retirement features are highlighted as standout strengths of the overall package.
-
Parental & Family Support — Generous paid parental leave (16 weeks maternity, 12 weeks parental), backup dependent care, and adoption assistance provide robust family support. Hybrid work and caregiving resources further ease family responsibilities.
Fidelity Investments Insights
What We Do
At Fidelity, our goal is to make financial expertise broadly accessible and effective in helping people live the lives they want. We do this by focusing on a diverse set of customers: - from 23 million people investing their life savings, to 20,000 businesses managing their employee benefits to 10,000 advisors needing innovative technology to invest their clients’ money. We offer investment management, retirement planning, portfolio guidance, brokerage, and many other financial products. Privately held for nearly 70 years, we’ve always believed by providing investors with access to the information and expertise, we can help them achieve better results. That’s been our approach- innovative yet personal, compassionate yet responsible, grounded by a tireless work ethic—it is the heart of the Fidelity way.
