Principal Data Modeler at Fidelity Investments

Durham, North Carolina, 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 Modeler (or closely related occupation) modeling OLTP recordkeeping applications on database platforms -- Oracle, PostgreSQL and NoSQL
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 Modeler (or closely related occupation) modeling OLTP recordkeeping applications on database platforms -- Oracle, PostgreSQL and NoSQL
Demonstrated Expertise leading data discovery and design sessions in collaboration with development squads, Architects, and Database Administrators (DBAs) using Mural, Visio, Excel, Zoom, and Teams
Demonstrated Expertise designing fully normalized (3NF) relational data models using SAP PowerDesigner, Erwin, or ER/Studio within database platforms – Oracle and PostgreSQL
Demonstrated Expertise analyzing and profiling legacy data to create new, scalable, and resilient data designs to meet future business requirements using SQL query tools – Toad and SQL Developer
Demonstrated Expertise integrating partitioning and indexing in physical data models using SAP PowerDesigner, Erwin, or ER/Studio according to feedback from development squads, Architects, and DBAs; and testing and generating Data Definition Language (DDL) scripts in an Oracle or PostgreSQL sandbox to ensure quality of scripts before delivery to deployment pipelines

Responsibilities

Manages data requirements gathering and analysis sessions with business and technical staff to analyze data requirements and recommend appropriate solutions
Transforms logical models to physical models and generates and tests Data Definition Language (DDL) scripts
Implements modeling strategies – Relational and Unstructured -- using data modelling tools: SAP Power Designer and Erwin
Designs and creates OLTP recordkeeping data models using database platforms -- Oracle, PostgreSQL and NoSQL
Manages projects in an Agile environment
Facilitates the design and maintenance of highly normalized data models and maintains a robust inventory of design frameworks and standards
Coordinates multiple requests and projects at the same time while meeting various deadlines
Analyzes business data to develop conceptual, logical, and physical data model designs to support various Agile projects with diverse scope in a multi-platform, highly integrated data environment
Works closely with business and technical teams to drive the creation of scalable and documented data design solutions
Drives the adoption of Enterprise standard modeling best practices
Partners with squads to deliver practical and resilient data model designs that meet business needs and are capable of easily adapting to future business requirements

Skills

Data Modeling

Oracle

PostgreSQL

NoSQL

SAP PowerDesigner

Erwin

OLTP

DDL

Agile

Logical Modeling

Physical Modeling

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