Fidelity Investments Header
This job is expired.

Principal Data Modeler - OLTP

Merrimack, NH
Full-Time

Job Description

Job Description:

Principal Data Modeler - Data Center of Excellence

The Role

Fidelity Brokerage Technology is seeking a highly motivated Principal Data Modeler to join our Data Design Center of Excellence. You will provide data analysis and conceptual, logical and physical data model designs to support the various Agile projects with diverse scope in a fast-paced, multi-platform, highly integrated data environment. You will work closely with business and technical teams to drive the creation of scalable and documented data design solutions. You drive the adoption of enterprise standard modeling best practices. You partner with squads to deliver practical and resilient data model designs that meet business needs and are capable of easily adapting to future business requirements. In this role, you will:

  • Participate in helping to drive a Data Driven Culture.

  • Design and delivery of robust data models for large transactional applications.

  • Collaboration with team members, DBAs, architects, squad leaders, developers to create scalable data models.

  • Ensure that database designs and modeling standards are in alignment with Enterprise modeling best practices

  • Use creativity in helping to solve interesting and challenging design problems

The Expertise and Skills You Bring

  • 10+ year's of experience and a Bachelor's Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structures and data modeling

  • Understanding of different database platforms (e.g. Oracle, PostgresSQL CockRoachDB, NoSQL, Snowflake) with a focus on modeling for OLTP recordkeeping applications

  • Practical knowledge of data lineage from OLTP Recordkeeping to ODS to Data Lakes.

  • Understanding of modeling strategies (Relational, Dimensional, Unstructured).

  • Demonstrable experience with data modelling tools (e.g. SAP Power Designer, Erwin).

  • Experience in executing projects in an Agile environment.

  • Actively participate in requirements and analysis sessions with business and technical staff to analyze data requirements and recommend appropriate solutions

  • Delivery of physical data base design from logical models to physical models, including DDL scripts

  • Outstanding interpersonal and verbal and written communication skills and can collaborate and influence across all levels of the organization

  • Capable and adept at juggling multiple requests and projects at a time while meeting the various deadlines

The Team

The Data Design Center of Excellence works as a cohesive team delivering high quality, resilient designs to meet the data needs of the various Agile squads within our Fidelity Brokerage organization. Our CoE provides data modeling expertise, data analysis and transformation logic for reporting platforms, support for data scientists and analytics platforms, and maintains a robust inventory of design frameworks and standards. You will collaborate with the Agile squads, our team members, architects, DBAs, Squad Leaders and squad members to facilitate the design and maintenance of highly normalized data models. By demonstrating and promoting Fidelity and agile leadership behaviors, you sustain and evolve our innovative agile culture.

The base salary range for this position is $85,000-$179,000 per year.

Placement in the range will vary based on job responsibilities and scope, geographic location, candidate's relevant experience, and other factors.

Base salary is only part of the total compensation package. Depending on the position and eligibility requirements, the offer package may also include bonus or other variable compensation.

We offer a wide range of benefits to meet your evolving needs and help you live your best life at work and at home. These benefits include comprehensive health care coverage and emotional well-being support, market-leading retirement, generous paid time off and parental leave, charitable giving employee match program, and educational assistance including student loan repayment, tuition reimbursement, and learning resources to develop your career. Note, the application window closes when the position is filled or unposted.

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.

Fidelity's hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.

Certifications:

Category:

Information TechnologyPDN-9f5eba7b-c597-4a51-9b2a-77d654881caa

Job Description:

Principal Data Modeler - Data Center of Excellence

The Role

Fidelity Brokerage Technology is seeking a highly motivated Principal Data Modeler to join our Data Design Center of Excellence. You will provide data analysis and conceptual, logical and physical data model designs to support the various Agile projects with diverse scope in a fast-paced, multi-platform, highly integrated data environment. You will work closely with business and technical teams to drive the creation of scalable and documented data design solutions. You drive the adoption of enterprise standard modeling best practices. You partner with squads to deliver practical and resilient data model designs that meet business needs and are capable of easily adapting to future business requirements. In this role, you will:

  • Participate in helping to drive a Data Driven Culture.

  • Design and delivery of robust data models for large transactional applications.

  • Collaboration with team members, DBAs, architects, squad leaders, developers to create scalable data models.

  • Ensure that database designs and modeling standards are in alignment with Enterprise modeling best practices

  • Use creativity in helping to solve interesting and challenging design problems

The Expertise and Skills You Bring

  • 10+ year's of experience and a Bachelor's Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structures and data modeling

  • Understanding of different database platforms (e.g. Oracle, PostgresSQL CockRoachDB, NoSQL, Snowflake) with a focus on modeling for OLTP recordkeeping applications

  • Practical knowledge of data lineage from OLTP Recordkeeping to ODS to Data Lakes.

  • Understanding of modeling strategies (Relational, Dimensional, Unstructured).

  • Demonstrable experience with data modelling tools (e.g. SAP Power Designer, Erwin).

  • Experience in executing projects in an Agile environment.

  • Actively participate in requirements and analysis sessions with business and technical staff to analyze data requirements and recommend appropriate solutions

  • Delivery of physical data base design from logical models to physical models, including DDL scripts

  • Outstanding interpersonal and verbal and written communication skills and can collaborate and influence across all levels of the organization

  • Capable and adept at juggling multiple requests and projects at a time while meeting the various deadlines

The Team

The Data Design Center of Excellence works as a cohesive team delivering high quality, resilient designs to meet the data needs of the various Agile squads within our Fidelity Brokerage organization. Our CoE provides data modeling expertise, data analysis and transformation logic for reporting platforms, support for data scientists and analytics platforms, and maintains a robust inventory of design frameworks and standards. You will collaborate with the Agile squads, our team members, architects, DBAs, Squad Leaders and squad members to facilitate the design and maintenance of highly normalized data models. By demonstrating and promoting Fidelity and agile leadership behaviors, you sustain and evolve our innovative agile culture.

The base salary range for this position is $85,000-$179,000 per year.

Placement in the range will vary based on job responsibilities and scope, geographic location, candidate's relevant experience, and other factors.

Base salary is only part of the total compensation package. Depending on the position and eligibility requirements, the offer package may also include bonus or other variable compensation.

We offer a wide range of benefits to meet your evolving needs and help you live your best life at work and at home. These benefits include comprehensive health care coverage and emotional well-being support, market-leading retirement, generous paid time off and parental leave, charitable giving employee match program, and educational assistance including student loan repayment, tuition reimbursement, and learning resources to develop your career. Note, the application window closes when the position is filled or unposted.

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.

Fidelity's hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.

Certifications:

Category:

Information TechnologyPDN-9f5eba7b-c597-4a51-9b2a-77d654881caa

About Fidelity Investments

At Fidelity, since our founding in 1946, we have been dedicated to strengthening and security our clients’ financial well-being through exceptional service and innovative solutions. We empower over ~50 million people to achieve their most important financial goals, manage employee benefit programs for nearly 24,000 businesses, and support more than 16,000 wealth management firms and institutions with cutting-edge investments and technology. Our diverse business portfolio and independence provide us with a comprehensive view of the market and the stability to deliver long-term value for our customers. As the financial industry evolves and customer needs grow more complex, Fidelity continues to reinvent, innovate, and transform to meet the challenges of tomorrow’s financial landscape.
 

*Specifically serviced by our Clearing & Custody team within Fidelity Institutional

 

Fidelity TalentSource, is the in-house temporary staffing provider for Fidelity Investments. Unlike traditional staffing agencies, we are an internal business unit within Fidelity’s Talent Acquisition team, dedicated to recruiting talent from various backgrounds for roles in Fidelity’s regional and investor center locations. Our mission is to help you experience Fidelity’s diverse and inclusive workplace while expanding your skill set and professional network, with the ultimate goal of conversion to full-time employment as part of Fidelity’s long-term strategy. To learn more about temporary positions at Fidelity Investments, visit FidelityTalentSource.com.

Related Jobs

Apply For This Job
Principal Data Modeler - OLTP
Fidelity Investments
Merrimack, NH
Jul 12, 2025
Full-time
Your Information
First Name *
Last Name *
Email Address *
This email belongs to another account. Please use a diferent email address or Sign In.
Zip Code *
Password *
Confirm Password *
Create your Profile from your Resume
By clicking the Apply button, you agree to the terms of use and privacy policy and consent to receive emails from us about job opportunities, career resources, and other relevant updates. You can unsubscribe at any time.
Ace your interview with
AI-powered interview practice

Get comfortable talking to hiring managers, receive personalized feedback on areas for improvement, sharpen your ability to answer the most common questions, and build confidence in formulating strong responses on the spot. Click the button below to begin your three free virtual interviews!

©2025 International Association of Women.
Powered by TalentAlly.