Principal Data Modeler - Alternative Investments
5 days ago• Merrimack, NH
Westlake, TX
Job Description:
Job Title Principal Data Modeler
The Role
FFIO (Fidelity Funds & Investment Operations) is actively seeking an experienced data modeler to help us deliver our next generation data models supporting evolving alternate investments business needs. You will be responsible for creating conceptual, logical and physical models, collaborating closely with business and engineering partners to drive scalable database designs that will enhance FFIO time to market.
- Deliver data modeling solutions for FFIO business and technology functions by partnering with business teams, functional architects, and other technical resources
- Inventory, develop, and maintain conceptual, logical, and physical data models
- Gather and analyze business data requirements to deliver well architected physical database structures
- Identify business critical gaps and discrepancies in database design and actively propose and implement remediation tactics.
- Define, champion, and govern data modeling standards and practices
- Manage organizational data model blueprint to provide reference and framework to the systems development efforts.
- Foster effective relationships with product managers, and technical leads
Want more jobs like this?
Get jobs in Merrimack, NH delivered to your inbox every week.

The Expertise and Skills You Bring
- Bachelor's or master's degree in a related technology field
- Strong understanding and experience with relational data modeling (Conceptual, Logical, & Physical)
- Hands on experience with data modeling tools such as Power Designer, Erwin, or ERStudio
- Solid understanding of principles, standard methodologies, best practices around data modeling/architecture
- Ability to write SQL to query and analyze data
- Financial investments domain experience and knowledge is preferred
- Results oriented with demonstrable ability to work independently
- Good analytical and interpersonal skills with ability to explain data structures to a non-technical audience
- General working knowledge of Cloud (AWS), Relational, NoSQL and Big Data technologies, techniques, and trends
- Experience with data governance and metadata management practices a plus.
The Team
The FFIO data modeling team partners with the project teams to deliver practical & resilient data model and database designs that meet business needs while adhering to key standards and methodologies. As part of the team, you will drive adoption of enterprise and standard methodologies, and promote changes in process, standards, or technologies when necessary.
Certifications:
Category:
Information Technology
Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles.
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.
Client-provided location(s): Merrimack, NH, Westlake, TX
Job ID: Fidelity-2118488
Employment Type: OTHER
Posted: 2025-09-30T23:40:57
Perks and Benefits
Health and Wellness
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Short-Term Disability
- Long-Term Disability
- FSA
- HSA
- HSA With Employer Contribution
- Fitness Subsidies
- On-Site Gym
- Pet Insurance
- Mental Health Benefits
- Virtual Fitness Classes
Parental Benefits
- Birth Parent or Maternity Leave
- Non-Birth Parent or Paternity Leave
- Fertility Benefits
- Adoption Assistance Program
- Family Support Resources
- Adoption Leave
Work Flexibility
- Flexible Work Hours
- Remote Work Opportunities
- Hybrid Work Opportunities
Office Life and Perks
- Commuter Benefits Program
- Casual Dress
- Snacks
- Company Outings
- On-Site Cafeteria
- Holiday Events
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Personal/Sick Days
- Leave of Absence
Financial and Retirement
- 401(K)
- 401(K) With Company Matching
- Company Equity
- Performance Bonus
- Relocation Assistance
- Financial Counseling
- Profit Sharing
Professional Development
- Tuition Reimbursement
- Promote From Within
- Mentor Program
- Shadowing Opportunities
- Access to Online Courses
- Lunch and Learns
- Internship Program
- Work Visa Sponsorship
- Leadership Training Program
- Associate or Rotational Training Program
Diversity and Inclusion
Company Videos
Hear directly from employees about what it is like to work at Fidelity Investments.