Senior Data Engineer

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.

• 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

• 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