Senior Data Modeler & Data Analyst

Fidelity Investments Inc.; Galway; Hybrid; EUR 70,000 - 100,000; Full time

Benefits offered by this job

Hybrid work model

Remote work flexibility

Job summary

Fidelity Investments Inc. is seeking a Senior Data Modeler/Data Analyst to lead data modeling across operational and analytical platforms in Galway. You will work with business and technical teams to structure scalable data designs and ensure they align with enterprise standards.

The role requires analyzing source systems and data flows, building conceptual/logical/physical models, and collaborating across agile teams to deliver data artifacts on time while reducing data redundancy.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or equivalent experience.
• 5+ years’ experience with data design, analysis and development with emphasis on PL/SQL and data loading concepts.
• Demonstrated experience in: Data API design, PL/SQL, data warehouses, data modeling and data profiling.
• Experience analyzing operational systems, data flows and consumption patterns.

Responsibilities

• Engage with business and technology partners to understand requirements and analyze data gaps.
• Create conceptual, logical and physical data models for multiple subject areas.
• Produce physical designs for operational systems, data warehouses and data lakes.
• Document and present database solutions for product partners and approvals.
• Promote data API adoption and reuse across projects.

Skills

Data modeling

SQL/PLSQL

Data governance

Stakeholder comms

Agile development

Education

Bachelor’s or Master’s in Computer Science/IT

Tools

SAP PowerDesigner

PL/SQL tooling

Job description

Job Description

The Role

As a Senior Data Modeler/Data Analyst, you will work closely with business and technical teams to drive the creation of scalable and documented data design solutions. You will be responsible for understanding how business processes generate, consume and transform data across operational and analytical platforms. You will analyse source systems, data flows, integrations and business processes to develop conceptual, logical and physical data models that meet business needs and are capable of easily adapting to future business requirements.

Requirements And Analysis

The Expertise and Skills You Bring

• Engage with business and technology partners to understand the business requirements, analyze data gaps, and recommend appropriate solutions.
• Assess objectives, use cases, data requirements and specifications documents created by other analysts.
• Analyze operational systems and business processes to understand how data is created, transformed and consumed across the enterprise.
• Analyze and resolve major data issues that arise during the course of projects or in production environments.

Data Design

• You are an experienced enterprise data modeler who can define conceptual and logical data models, with strong definitions, to capture organizational data needs across multiple subject areas
• Create physical design from logical data models for different types of systems such as operational systems, data warehouses, data lakes and others
• Research to identify effective data designs, new tools and methodologies for data analysis
• Document and present database solutions to product partners for approval.
• Promote common data API adoption and reuse.
• Map Technical terms to Business terms in data catalog tool.

Technical Leadership

• Ensure technology decisions align with enterprise standards and strategy.
• Collaborate with DBAs, architects, subject area owners to create scalable data models.
• Find opportunities to utilize enterprise data model for new projects to minimize work and data redundancy

Education And Experience

• A Bachelor’s or Master's degree in Computer Science, Information Technology, or equivalent experience
• 5+ years’ experience with data design, analysis and development. Development experience weighted towards PL/SQL and data loading tool/concepts.
• Demonstrated experience in the following areas: Data API design and implementation, PL/SQL, data warehouses, data modeling and data profiling.
• Experience analyzing operational systems, understanding data flows and data consumption patterns.

Skills And Knowledge

• Demonstrable experience with SAP Power Designer or similar data modeling tool.
• Proficient analytical and problem solving skills
• Solid understanding of the database development process including analysis, design, coding, testing, problem resolution and planning, and full competency in all relevant coding environments, languages, tools, and platforms
• Good interpersonal skills and strong verbal and written skills to effectively communicate with technical and non-technical associates in the company
• Proven interpersonal skills, including the ability to work across the organization and interact/influence/negotiate optimally at all levels of management and peers.
• Experience working in cross-functional agile development teams.
• Understanding of Financial Services.

The Team

Asset Management Technology is seeking a Senior level candidate in the analysis and data modeling organization. The successful candidate will be responsible for leading analysis and data modeling across different projects with diverse scope and complex business and technical requirements in a highly integrated data environment. This role requires working under experienced leaders, for achieving organizational strategic data goals. You must be comfortable working in a fast paced and highly ambiguous agile environment where there is a focus on timely delivery of data models and other data artifacts.

AM Tech is a global organization, with technologists located across the United States, London, India, and Ireland. The team supports a broad range of functions within the Investment Management and Advisory domain, including Portfolio Management, Research, and Trading, by providing reliable, high impact technology solutions.

We are currently working in a hybrid model with some flexibility for remote working. However, Fidelity is gradually transitioning towards a full-time return to the office. We believe this will help strengthen our culture and enhance both the associate and customer experience. At present, this transition is expected from 2027 onwards, with no fixed timeline in place.

Category

Information Technology