Senior Data Engineer at Fidelity Investments

Job Description:

The FI Data Solutions team is seeking an experienced, highly motivated and skilled Principal Data Engineer to join our Fidelity Institutional Business Enablement Technology data squad in Smithfield, RI. The data infrastructure is going through significant growth and modernization, and this is an opportunity to take a leading role in shaping FI capability in this area. The work involves solution design, data analysis, innovation and collaboration while maintaining the operational and analytical capability in FI’s data platforms while testing, production rollout and quality execution on project activities in data lakes using Snowflake, AWS, and Python.

You will be responsible for providing leadership on a complex Territory Management Conversion & Client Infrastructure initiative that will deliver a strategic client and territory data experience that will support 2027 streamlined sales segmentation coverage models for our FI Sales clients.  You will be part of a dedicated data squad partnering with CRM Sales to execute on this Phase 2 CRM workstream including end-to-end design and integration of client hierarchies, territory logic, and segmentation rules while collaborating with CRM to provide a flexible and scalable workflow that unlocks long term efficiencies for our Sales partners.  Being part of this highly visible workstream, we will expect strong leadership and influence in driving timely, data-driven coverage planning while reducing manual intervention and improving alignment across platforms.

The ideal candidate will have a passion for data and fall in love with the problem at hand, working through systems analysis and team collaborations to solve it.

This position requires an independent thinker and collaborator, who demonstrates analytical thinking, active listening and champions continuous improvement.

The Team

This position will be part of a critical, newly formed data squad converting the existing Territory Management experience and client infrastructure while partnering with our existing Data Swarm (Bsharks & Tech Mavericks) and CRM Salesforce Delivery squads to form the data integration center for customer relationship management (CRM) within FI. We provide our CRM users with essential data for their day-to-day operations and support our clients.  In addition, we deliver CRM team data to operational and reporting platforms, while building lasting and insightful relationships with our consumers. Our team partners closely with the Fidelity Institutional (FI) Market Readiness Team, is innovative, diverse, passionate, self-driven and customer obsessed. This is a dynamic environment that operates using mature agile practices and principles. We stress customer-obsessed thinking and a creative culture!

The Expertise and Skills You Bring

• Bachelor’s or master’s Degree in a technology related field (e.g. Engineering, Computer Science, etc.) required with 10+ years of experience

• 6+ years of experience in Data Warehousing, Data mart concepts & implementations

• 4+ years of experience developing ELT/ETL pipelines to move data to and from Snowflake data store

• 4+ years of experience using AWS services such as EC2, IAM, S3, EKS, KMS, SMS, CloudWatch, CloudFormation, etc.

• 4+ years of experience in object-oriented programming languages (Strong programming skills required in Python or Java)

• Your passion for Data Analysis with the ability to navigate and master complex transactional and warehouse databases

• Hands-on experience on SQL query optimization and performance tuning is preferred

• Experience in job scheduling tools (Control-M preferred)

• Advanced SQL/Snow SQL knowledge is preferred

• Strong data modeling skills doing either Dimensional or Data Vault models

• Experience in Container technologies like Docker and Kubernetes

• Experience with DevOps, Continuous Integration and Continuous Delivery (Maven, Jenkins, Stash, Ansible, Docker)

• Experience in Agile methodologies (Kanban and SCRUM) is a plus

• Proven track record to handle ambiguity and work in a fast-paced environment

• Good interpersonal skills to work with multiple teams in the organization

The Value You Deliver

• Passion and intellectually curiosity to learn new technologies and business areas

• Exploring new technology products and using them to help our business needs

• Working on teams to improve efficiency

• Delivering system automation by setting up continuous integration/continuous delivery pipelines

Certifications:

Category:

Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles.

Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.