Job Description:

Senior Data Modeler / Data Analyst – Data Center of Excellence

Fidelity Brokerage Technology is seeking a highly motivated Senior Data Modeler/Analyst to join our Data Center of Excellence team.    You will provide data analysis and logical/physical data model designs to support the various Agile projects with diverse scope in a fast-paced, multi-platform, highly integrated data environment.   

The Team

The Data 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 team provides data analysis and modeling expertise in the operational/transactional data platform, as well as data analysis and transformation logic for data lake / Snowflake reporting platforms. Our team also provides support for data scientists and analytics platforms. We maintain a robust inventory of design frameworks, standards and best practices.  You will collaborate with the Agile squads, our team members, architects and database administrators to facilitate the design and maintenance of highly normalized data models.

The Expertise You Have

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

Strong technical, data modeling, analysis and design abilities

Understanding of different database platforms (e.g. Oracle, DB2, NoSQL, Snowflake) and their usages (OLTP Recordkeeping, ODS, MDM, Warehousing and Data Lakes).

Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).

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

Experience in executing projects in an Agile environment.

The Skills You Bring

You are an experienced Data Modeler with outstanding interpersonal and communication skills and can collaborate and influence across all levels the organization.

You have a minimum of 7 years of dimensional and relational data modeling experience;  within the financial services industry is a plus

You are capable and skilled at juggling multiple requests and projects at a time while meeting the various deadlines for each

You have experience with database design, from requirements analysis to conceptual, logical and physical data model designs for transactional applications. 

You have strong working knowledge of data modeling tools, preferably SAP Power Designer

You are not afraid to challenge legacy design and seek opportunities to design better models. 

You are technically adept at learning new technologies, architectural methodologies and adapting our practices to support frequent changes in the data environment.

You have strong SQL skills and the ability to navigate complex transactional and reporting schemas

The Value You Deliver

Participating in helping to build a Data Driven Culture.

Designing and delivering robust data models for large transactional applications.

Delivering data mapping specifications for large reporting applications.

Collaborating with team members, DBAs, architects and subject area owners to create scalable data models.

Ensuring that database designs and modeling standards are in alignment with Enterprise Modeling best practices

Using creativity in helping to solve interesting and challenging design problems

Certifications:

Company Overview

Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients’ money.

Join Us

At Fidelity, you’ll find endless opportunities to build a meaningful career that positively impacts peoples’ lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees’ Choice Award(opens in a new tab), we have been recognized by our employees as a Best Place to Work in 2022. And you don’t need a finance background to succeed at Fidelity—we offer a range of opportunities for learning so you can build the career you’ve always imagined.

As a result of COVID-19, many of our associates are continuing to work remotely. When Fidelity employees eventually return to the office, our goal is for most people to work flexibly in a way that balances both personal and business needs with time onsite and offsite through what we’re calling “Dynamic Working(opens in a new tab).” 

We invite you to Find Your Fidelity at fidelitycareers.com.

Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.

Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Leave of Absence/Accommodation Team by sending an email to accommodations @fmr.com, or by calling 800-835-5099, prompt 2, option 2.