Principal Data Engineer at Fidelity Investments

Westlake, Texas, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level

Full TimeJob Type

UnknownVisa

Financial ServicesIndustries

Requirements

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) developing and supporting data integration and reporting platforms in a financial services environment
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) developing and supporting data integration and reporting platforms in a financial services environment
Demonstrated Expertise implementing Cloud technologies using Oracle Analytics Cloud (OAC)
Demonstrated Expertise delivering real time reports with actionable insights to stakeholders using advanced BI tools (Oracle Analytics Server (OAS), Oracle Business Intelligence (OBIEE), and PowerBI), to create dynamic, user-driven reports for multidimensional data analysis and online analytical processing (OLAP)
Demonstrated Expertise performing data engineering, migration, and modelling in a Cloud based data warehouse platform, using Snowflake, Python, Snaplogic, Apache Airflow, and AWS S3 containers (staging layer)
Demonstrated Expertise developing code to process large datasets in relational environments and improving data workflows and data availability for business operations

Responsibilities

Designs, implements, and maintains the organization’s database systems
Ensures the scalability, reliability, performance, and security of databases by performing database tuning and optimization techniques
Incorporates and streamlines test automation into software application builds, using Continuous Integration/Continuous Delivery (CI/CD) pipeline tools -- Jenkins and Maven
Writes and optimizes SQL queries and stored procedures, using SQL, PL/SQL, Python, and shell scripting languages for development of databases
Develops applications in a Cloud environment using AWS
Builds reports and dashboards in Oracle Business Intelligence tools and PowerBI
Creates and maintains database schema and objects (tables, views, indexes, and triggers) for easy access of database systems -- Oracle and Snowflake
Enhances the data integration platform using Extract, Transform, Load (ETL) technologies -- Informatica and Snap Logic
Implements and supports databases in an Amazon Web Services (AWS) Cloud Infrastructure environment and in AWS managed Databases
Monitors and optimizes database performance by implementing various database designs and modelling techniques
Designs and implements database systems to support business requirements
Translates the vision for divisional initiatives into business solutions by developing complex or multiple software applications
Defines and implements application-level architecture
Develops comprehensive documentation for multiple applications or subsystems
Establishes full project life cycle plans for complex projects across multiple platforms
Advises senior management on technical strategy and risk management strategies for projects
Mentors junior team members
Maintains the performance, availability, and security of the databases
Troubleshoots and resolves issues with databases and related systems, by continuously monitoring and optimizing database performance
Confers with data processing or project managers to obtain information on limitations or capabilities for data processing projects
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
Develops software system testing and validation procedures, programming, and documentation

Skills

SQL

PL/SQL

Python

Shell Scripting

AWS

Oracle

Snowflake

ETL

Informatica

SnapLogic

Jenkins

Maven

CI/CD

PowerBI

Oracle BI

Fidelity Investments

Investment management and financial services provider

About Fidelity Investments

Fidelity Investments offers a range of financial services and tools designed to help individuals manage their investments and stay informed about the markets. Their products include mobile applications and market monitoring tools that provide users with real-time market quotes, news, and trading capabilities. For example, the Fidelity Market Monitor for Glass delivers daily market quotes directly to Google Glass, while the Fidelity app for Windows Phone 8 allows users to access news and trading tools on their mobile devices. Additionally, features like the Watch List Visualization for iPad help users track stock price changes over time using a heatmap. What sets Fidelity apart from its competitors is its focus on integrating new technologies and user-friendly interfaces to enhance the investment experience. The goal of Fidelity Investments is to empower individuals with the information and tools they need to make informed financial decisions.

Boston, MassachusettsHeadquarters

1946Year Founded

$120,238.8MTotal Funding

DEBT_FINANCINGCompany Stage

Fintech, Financial ServicesIndustries

10,001+Employees

Benefits

Health Insurance

Mental Health Support

Hybrid Work Options

401(k) Retirement Plan

401(k) Company Match

Unlimited Paid Time Off

Parental Leave

Student Loan Assistance

Tuition Reimbursement

Risks

Loss of key personnel like Gita Bal may impact Fidelity's research capabilities.

Increased competition from Vanguard's new division could draw clients away from Fidelity.

Potential reputational risk from Bitcoin ETF outflows could affect Fidelity's offerings.

Differentiation

Fidelity Labs offers innovative beta products like Market Monitor for Google Glass.

Fidelity's mobile solutions are available on multiple platforms, including Windows Phone and iPad.

Fidelity's Open Limit Order Visualization provides unique insights into order execution proximity.

Upsides

Increased adoption of wearable tech could boost Fidelity's mobile solutions.

Growing interest in Bitcoin ETFs suggests expansion in Fidelity's digital asset offerings.

Rise of AI could benefit Fidelity's data analytics and AI-driven investment strategies.

Land your dream remote job 3x faster with AI

Try Jobo Free