Fidelity Investments
Job Description:
The Role Institutional Wealth Management Services is seeking a highly motivated Data Modeler. You will provide data analysis and conceptual, logical and physical data model designs to support Agile Initiatives 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. This position can be located in Smithfield, Merrimack, or Westlake The Expertise and Skills You Bring 5+ years of experience and a Bachelors 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, Postgresql, CockRoachDB, NoSQL, Snowflake)
Experience in designing and implementing database structures with a focus on modeling for OLTP recordkeeping applications
Practical knowledge of data lineage
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 Value You Deliver 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 Team We operate as a cohesive team delivering high quality, resilient designs to meet the data needs of the various Agile squads within IWMS. We provide data modeling expertise, data analysis and transformation logic. Maintains a robust inventory of design frameworks and standards. You will collaborate with the Agile squads, our team members, Data and Solution 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 behaviors, you sustain and evolve our innovative agile culture. 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 Fidelitys 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.
The Role Institutional Wealth Management Services is seeking a highly motivated Data Modeler. You will provide data analysis and conceptual, logical and physical data model designs to support Agile Initiatives 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. This position can be located in Smithfield, Merrimack, or Westlake The Expertise and Skills You Bring 5+ years of experience and a Bachelors 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, Postgresql, CockRoachDB, NoSQL, Snowflake)
Experience in designing and implementing database structures with a focus on modeling for OLTP recordkeeping applications
Practical knowledge of data lineage
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 Value You Deliver 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 Team We operate as a cohesive team delivering high quality, resilient designs to meet the data needs of the various Agile squads within IWMS. We provide data modeling expertise, data analysis and transformation logic. Maintains a robust inventory of design frameworks and standards. You will collaborate with the Agile squads, our team members, Data and Solution 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 behaviors, you sustain and evolve our innovative agile culture. 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 Fidelitys 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.