Technology
Principal Data Modeling Engineer
- Merrimack, NH
- Boston, MA
- Westlake, TX
Salary depends on a variety of factors including location and experience. Your recruiter will discuss with you.
Salary: listed in the job description
or discussed with your recruiter
Job Description:
Join a workplace where you can develop client solutions that utilize the latest technology while exceeding client expectations. Experience work that is challenging, produces talent and career growth and where no two days are the same. Where you will experience strong coaching and mentoring to aid you in reaching your goals as we support our client needs as an engaging team.
The Team
The Fidelity Workplace Consulting Group is comprised of over 300 professionals who advise clients on the management of their domestic benefits. Data Consulting is a fast-growing, revenue generating business within Fidelity, providing a broad range of direct-to-client services that touch on every area of benefits design, strategy, funding, communication, and delivery. While we focus on supporting the Fortune 1000, we also work with Fidelity clients of all sizes.
Data Consulting engages in data quality improvement efforts that span single and multiple product lines (i.e. Health and Welfare, Defined Benefit, Defined Contribution, Stock Plan Services and HR/Payroll) within the implementation and ongoing servicing client lifecycle.
The Role
The Principal Data Modeler designs, implements, documents the data architecture, and our data modeling solutions that will be used in direct-to-consumer consulting solutions. These solutions support projects involving business intelligence, data as service offerings, data cleaning, client data ingestion, data masking and data security and other business interests. Models developed should reduce data redundancy, streamline data movements, and improve WI Data Consulting information management. The Principal Data Modeler also may grow to perform data science responsibilities as requested by the organization. Principal Data Modeler will create table designs and structures as well as views, stored procedures, and materialized views.
Role Functions:
- Development of conceptual, logical, and physical data models (often large and complex) across multiple platforms and data tools (reporting, visualization, analytics, data transfer and longer-term data science)
- Leadership of and implementation of data model objects into our own Snowflake Environment
- Ability to learn and adapt to changes in data needs
- Optimize data query performance
- Work with the Data Engineering team to ingest client data sources.
- Partner with SMEs and Engineers to build flexible, scalable, and efficient client solutions for data.
- Review existing data models and work with SMEs to understand where models may need flexibility and which functions can be built as common.
- Partner with other enterprise modeling teams to ensure we are using existing capabilities where possible and customizing only where needed to optimize our custom development cost model.
Skills You Bring
- 2+ Years of Snowflake data modeling or similar cloud-based data modeling experience.
- Minimum of 6 years of data modeling, database table design/creation, data engineering experience.
- Experience writing stored procedures.
- Degree or equivalent in Computer Science, Information Technology or Data Modeling.
- Creatively solve sophisticated business data problems.
- Ability to enlist and extract sophisticated data requirements from SME resources quickly and effectively supplementing independent analysis
- Solid attention to Detail.
- Leadership/Training abilities to help expand and extend the data modeling skills across our practice.
- Ability to work Independently and in a fast-paced consulting fee-for-service environment.
- Eye for Cost/Benefit of technical solutions to balance between re-use and one-time quick-development needs.
- Enterprise Data design and Financial Data experience a plus
- Master Data Management/Data Cleansing Experience
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.
Company overview
At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want! We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com. Fidelity Investments is an equal opportunity employer. Fidelity will reasonably accommodate applicants with disabilities who need adjustments to complete the application or interview process.
Apply Now
All fields are required.
What tech makes you tick?
Benefits that adapt to everything life sends your way
401(k) with company match
Medical, dental, vision and prescription drug coverage
16-week maternity leave & 12-week parental leave
Student loan assistance
Fidelity is invested in you
Committed to Professional Development
At Fidelity, we are constantly adapting to the changing needs of our customers, new technologies, and better ways of working. And we empower our employees to do the same, with an emphasis on developing skills and connections that will help propel you forward in your career while being able to make an impact for Fidelity’s customers around the world.
Licenses & Certifications
- Pursue excellence in new coding languages or tech applications across a broad range of technical paths.
- Tuition reimbursement for online or in-person course work in pursuit of new certifications.
Continuing Education & Training
- Assess, build, and align your development plan through resources like our skill-building classroom and online courses.
- Video-based training for technology, leadership, management & more.
- Paid training with a facilitator who is dedicated to your onboarding and will track and evaluate your progress, giving you strategies to improve.
- A range of talent development programs to support career mobility.
Mentoring
- Utilize the skills of experienced leaders to enrich your career.
- Dedicated mentors to help you grow into new areas of Fidelity’s business as you develop new skills.
- An open atmosphere of knowledge sharing and collaboration.
- Opportunities to pay it forward, sharing the knowledge you develop and as you help others define how they want their career to take shape.
Web-Based Learning
- Online, video-based training that covers a broad range of technology, leadership, and management topics.
- Access to thousands of the latest and most relevant business books – all summarized in just a few pages.
- Train from your desk or the comfort of your home.
Our Commitment to Diversity and Inclusion
"Fidelity believes in, and is committed to, fair and equitable treatment for every associate and customer, and to creating a safe and respectful environment, in which everyone is treated with kindness, compassion and respect." Abby Johnson | Chairman and CEO Fidelity Investments
At Fidelity, we are committed to building an enduring culture of inclusion and belonging that will attract, develop and retain a diverse workforce.
Fidelity’s ten affinity groups are self-organized groups of employees with common interests in areas such as race, ethnicity, gender or sexual orientation, or who share similar interests based on similar sets of experiences.
These Employee Resource Groups and Special Interest Groups are models of inclusion for Fidelity. They’re also a powerful form of engagement and development and can provide a pathway to visible leadership roles. Our affinity groups make a large contribution on the business, helping to ensure our products and services are delivered in a welcoming and equitable environment.
- Over 22K employees participate in an affinity group.
- Over 1,400 affinity group members volunteered for Fidelity Cares in 2020.
- 74% increase in affinity group memberships over the last three years.
Giving Back to Our Communities
Throughout Fidelity, you’ll find a genuine commitment to social responsibility – where we strive to make an impact for customers, while also making an impact on the world.
Fidelity Cares
- Provides associates with opportunities to actively volunteer and share their talents.
- Hosts numerous company-wide volunteer events (in-person and virtual).
- Partners with nonprofit organizations to support our local communities.
- More than 12,000 associates donate time annually – from interns to SVPs.
- Impact includes refurbishing schools, donating books and supplies, and teaching financial literacy.
Fidelity Charitable®
- Created to make it easy for people to support charitable organizations they care about.
- Helped deliver $7.3 billion in donor-recommended grants to charity in 2019.
- Supported more than 300,000 unique charities around the world.
- Since its inception, more than $42 billion has been given to public charities.
