Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Principal Software Engineer

AT Fidelity Investments
Fidelity Investments

Principal Software Engineer

North Smithfield, RI

Job Description:

Principal Data Modeler - RDBMS/DATA WAREHOUSING/OLAP/SNOWFLAKE/CLOUD
The Role
As a Data Modeler, the candidate will collaborate with collaborators and multi-functional teams, Architects, Tech Leads and senior development resources across our team, as well as other technical and business collaborators across the organization in a fast paced agile environment to understand data requirements and design appropriate data models that align with business needs . The candidate will also collaborate with business, technology and architecture teams across the company to design and develop our next generation data platforms using traditional/brand new/Cloud technologies, open source frameworks and cloud services. you will be responsible for contributing to the overall effort around defining the domain and data capabilities by analyzing business requirements, and developing solutions for the projects delivered by the Fidelity Wealth Technology Engineering team.

Want more jobs like this?

Get Software Engineering jobs delivered to your inbox every week.

Select a location
By signing up, you agree to our Terms of Service & Privacy Policy.

• Strong execution skills in a fast-paced environment using agile methodologies
• Ability to collaborate and partner with business domain leads, data scientists, product owners, enterprise architects and other functional leads to deliver world class data solutions.
• Define the overall data model for the Applications in the business unit, a data warehouse approach, and how data is structured, designed, and/or accessed
• Data modelling, Architecting, designing and helping engineering teams to build and support critically important platforms in data areas. (Databases, data marts, Datawarehouse, Cloud data warehouses)
• Contributes to standard practices for problem-solving approaches, tools, and processes.
• You will Analyze and manage technology cost drivers to ensure efficient scale and support of OLTP/OLAP capabilities including public cloud data technologies.
• Exploring new technology trends and demonstrating them to simplify our data ecosystem.
• Driving Innovation and guiding the teams to implement solutions with future thinking.
• Collaborating with internal and external teams to deliver technology solutions for the business needs

The Expertise and Skills You Bring
• Bachelor's or master's Degree in a technology related field (e.g. Engineering, Computer Science, etc.) required.
• 9+ years of data modeling experience
• Collaborate with stakeholders and cross-functional teams to understand data requirements and design appropriate data models that align with business needs
• Govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
• Experience with data modeling tools such as Power Designer
• Expertise in data modeling principles/methods including conceptual, logical & physical Data Models -dimensional and data vault
• Extensive hands-on data modeling ( Dimensional Modeling) , architecture and development experience on data integration patterns, relational and NoSQL databases, Event driven architecture and microservices.
• Expertise with Dimensional Modeling - Star Schema, SCD etc.
• Hands on experience on Dimensional Modeling, Snowflake Modeling, Data vault Modeling
• Enterprise scale expertise in data analysis, modeling, data security, data warehousing, metadata management and data quality.
• Evaluates databases and data models for inconsistencies and variances, ensuring data is represented correctly.
• Experience with data warehouses and big data platforms, Identify and resolve data model performance issues to optimize database performance and enhance overall system functionality.
• Hands on experience in building data solutions using external cloud (e.g. AWS) data applications and capabilities. Ability to evaluate, prototype and recommend open source and vendor technologies and platforms.
• Demonstrated technology and personal leadership experience in architecting, designing and building highly scalable data platforms.
• Experience with DevOps, Continuous Integration and Continuous Delivery technologies.
• Ability to effectively articulate and present ideas / technical design to appropriate audience.
• Innovation Attitude and Creativity
• Possess knowledge and understanding of specific Databases and languages: RDMBS (Oracle, PostgreSQL, Snowflake), Python, AWS (Glue, Lambda, SNS, SQS), Data orchestration technologies - ETL/ELT (Control-M, Snaplogic)

The Team
The Customer Data and Marketing Technology group within Fidelity Wealth organization is seeking a Principal Data Modeler to enable our application and data engineers to build and maintain large scale data processing systems for analytical and operational use cases. In this role, you will lean on a variety of experiences and technologies to develop innovative solutions, focused on the enablement of customer and prospect data attributes to drive solutions across the enteprise. This position is a critical element to delivering Fidelity's promise of creating the best customer experiences in financial services.

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. Please email us at accommodations@fmr.com or call 800-835-5099, prompt 2, option 2 if you would like to request an accommodation.

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 working model blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).

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.

Client-provided location(s): Smithfield, RI, USA; Westlake, TX, USA
Job ID: Fidelity-2097379
Employment Type: Other

Perks and Benefits

  • Health and Wellness

    • Health Insurance
    • Dental Insurance
    • Vision Insurance
    • Life Insurance
    • Short-Term Disability
    • Long-Term Disability
    • FSA
    • HSA
    • HSA With Employer Contribution
    • Fitness Subsidies
    • On-Site Gym
    • Pet Insurance
    • Mental Health Benefits
    • Virtual Fitness Classes
  • Parental Benefits

    • Birth Parent or Maternity Leave
    • Non-Birth Parent or Paternity Leave
    • Fertility Benefits
    • Adoption Assistance Program
    • Family Support Resources
    • Adoption Leave
  • Work Flexibility

    • Flexible Work Hours
    • Remote Work Opportunities
    • Hybrid Work Opportunities
  • Office Life and Perks

    • Commuter Benefits Program
    • Casual Dress
    • Snacks
    • Company Outings
    • On-Site Cafeteria
    • Holiday Events
  • Vacation and Time Off

    • Paid Vacation
    • Paid Holidays
    • Personal/Sick Days
    • Leave of Absence
  • Financial and Retirement

    • 401(K)
    • 401(K) With Company Matching
    • Company Equity
    • Performance Bonus
    • Relocation Assistance
    • Financial Counseling
    • Profit Sharing
  • Professional Development

    • Tuition Reimbursement
    • Promote From Within
    • Mentor Program
    • Shadowing Opportunities
    • Access to Online Courses
    • Lunch and Learns
    • Internship Program
    • Work Visa Sponsorship
    • Leadership Training Program
    • Associate or Rotational Training Program

Company Videos

Hear directly from employees about what it is like to work at Fidelity Investments.