Job Description:
PRINCIPAL DATA Modeler
The Role
As a Principal Data Modeler on the Data team, you'll get the lead and collaborate across Fidelity teams in a fun and dynamic environment to build Data modelling platform for Fidelity Digital Asset. You will work closely with product teams, data engineering teams, architecture, and business stakeholders to understand data requirements and translate them into conceptual, logical, and physical data models. Using AWS and/or on premises services, you'll help design, implement Data model for Analytical, operation and transaction platform. You will be responsible for the data modeling efforts in support Crypto Trading and model the various domains and entities in scope and enhance existing data models as the business evolves
The Expertise and Skills You Bring
- Bachelor’s or master’s degree in computer/data science technical or related experience
- 7+ years of experience hands-on relational, dimensional, and/or analytic experience. Python knowledge is a plus
- Strong SQL knowledge and work experience with databases such as Oracle, PostgreSQL, Snowflake, Teradata
- Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC
- Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
- Demonstrated, hands-on data modeling, ER diagram` and enterprise software design experience for OLTP (relational) and analytical systems
- Good knowledge of data modeling principles and standard methodologies including a good understanding of semantic data modeling concepts and multi-Fact model
- Ability to define data modelling standards and guidelines as well help teams adopt complex large-scale & global data driven implementations
- Strong experience in data modelling activities supporting history handling time series data warehousing & data transformations
- Ability to quickly grasp technological, business concepts, key domain and entities
- Strong verbal and written communication skills; experience communicating with engineers, architects and product management to explain technical and functional concepts
- Ability to assess the accuracy completeness and consistency of data models as well as maintaining relevant documentation
- Experience with Alation, Collibra to drive data cataloging and data lineage
- Strong understanding of data governance processes and metadata repositories
- Experience of working with Data Governance team to identify and capturing business and technical metadata associated with various data entities
- Experience and desire to work within a fast-paced environment with short release cycles and an iterative development methodology.
- Able to work on multiple projects/products simultaneously and comfortable working with minimal specifications.
- Excellent communication and documentation skills
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, we have been recognized by our employees as a top 10 Best Place to Work in 2024. 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.
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 all business days of every other week in a Fidelity office.
At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation, detailed in this document, and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.
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 Accommodation Team by sending an email to accommodations@fmr.com.