Position Description:
Designs, develops, and implements scalable data engineering, analytics and reporting solutions to support business needs. Builds robust data infrastructure and reporting platforms, using Oracle SQL, PL/SQL, Python, Airflow, Oracle Business Intelligence Enterprise Edition (OBIEE) / Oracle Analytics Server (OAS), Unix Shell Scripting, and Snowflake. Develops and supports data acquisition, Extract, Transform, and Load (ETL) pipelines, and reporting applications in both on-premises and Cloud-based (Amazon Web Services (AWS)) environments. Collaborates with product owners, data analysts, and data modelers to deliver high-quality, resilient, and extensible data solutions. Ensures alignment to enterprise data, analytics and insights strategy, taxonomy, and DevSecOps practices.
Primary Responsibilities:
- Drives the execution of multiple development work streams and ensures design and architecture is scalable, resilient, and extensible.
- Confers with systems analysts and other software engineers/developers to design systems and obtain information on project limitations, capabilities, performance requirements, and interfaces.
- Develops software system testing and validation procedures, programming, and documentation.
- Collaborates with peers via daily code reviews, pair programming, or interactive discussions.
- Architects, crafts, and develops highly scalable distributed data processing systems.
- Develops solutions that improve developer efficiency and shares knowledge about new techniques and technologies.
- Ensures technology decisions and implementation align with architecture standards and strategies.
- Evaluates and recommends technology and frameworks for flexibility, long-term viability, and time to market.
- Provides guidance, training, and coaching to other team members.
- Plans organization wide initiatives.
- Identifies and plans for future resource needs.
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) performing data analysis, solution design, and development for Data Lake, ETL, Reporting and Analytic processes.
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) performing data analysis, solution design, and development for Data Lake, ETL, Reporting and Analytic processes.
Skills and Knowledge:
Candidate must also possess:
- Demonstrated Expertise (“DE”) creating conceptual and logical data models to depict functional business entity interactions, using Systems Applications and Products (SAP) Power designer and MS Visio; creating Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP) models in line with architectural standards; designing ETL processes to enable data loads into physical database tables; and performing WORM compliant storage for compliance and data masking, using IBM Optim.
- DE performing data analysis and profiling across subject areas within investment management and distribution in the financial services industry, using Microsoft Excel, Toad, SQL Developer, and MS Visio; and designing and developing robust data reconciliation processes to support data quality and completeness in a multi-year data migration project for an OLTP database, using Oracle SQL and PL SQL.
- DE designing and developing back-end applications according to business user requirements, using Oracle, PL/SQL, and Informatica; designing and developing Unix Shell and Oracle PL/SQL scripts and Informatica ETL mappings to bulk load data from data systems and sources into OLTP database according to business user requirements; and designing and developing Control-M jobs to automate and schedule end-to-end processes.
- DE performing in all aspects of the Software Development Lifecycle (SDLC) -- participating in architecture and business discussions and delivering innovative solutions in line with software development best practices and Agile methodologies; and reviewing representative use cases, defining technology and modernization strategies, and publishing key decisions in discernable format to all consumers.
#PE1M2
#LI-DNI
Certifications:Category:Information TechnologyPlease 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, Information Technology, Information Systems, or related field (or foreign equivalent) plus five years' relevant experience OR Master's degree plus three years' relevant experience
- Experience designing and implementing scalable data engineering, ETL, Data Lake, and reporting solutions
- Expertise with Oracle SQL and PL/SQL
- Experience with Python programming
- Experience building and scheduling pipelines using Apache Airflow and Control‑M
- Experience with Oracle Business Intelligence Enterprise Edition (OBIEE) or Oracle Analytics Server (OAS)
- Experience with Snowflake and cloud-based data platforms (AWS)
- Experience with Informatica ETL and Unix shell scripting
- Experience with data modeling tools (SAP PowerDesigner) and MS Visio
- Experience with data profiling, reconciliation, and IBM Optim for WORM/compliance and data masking
- Experience using Microsoft Excel, Toad, and SQL Developer for data analysis and profiling
- Demonstrated experience across the Software Development Lifecycle, Agile methodologies, and DevSecOps alignment
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.
