Principal Data Modeler
Company: FIDELITY INVESTMENTS
Location: Merrimack
Posted on: July 13, 2025
|
|
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 Technology
Keywords: FIDELITY INVESTMENTS, New England , Principal Data Modeler, IT / Software / Systems , Merrimack, Northeast