Principal Data Engineer

Job Description:

Principal Data Engineer in Workplace Investing

Role

Fidelity's Workplace Investing Reporting and Analytics chapter is seeking a Principal Data Engineer to play a key role in improving and maintaining the Workplace Investing data warehouse which supports multiple key client applications including Reporting and Analytics.

This role is ideal for a developer who not only codes but provides design suggestions and recommendations. Works with technical partners, and assists developers and testers as needed. The role demands significant collaboration with members of various business and technology groups. Our engineering team is innovative, diverse, hardworking, and resolved. We work in a very dynamic agile environment.

Expertise in

• Bachelor’s Degree or equivalent experience in a technology related field (e.g., Computer Science, Engineering) required.
• 7+ years of hands-on experience in Data engineering, data warehousing and analytics technologies
• 10+ years of experience with Relational Databases in specific Oracle (Exadata preferred)
• 8+ years demonstrated experience with PL/SQL and complex queries
• 5+ years on Database Performance tuning and techniques
• 5+ years of demonstrated ability with ETL tools like Informatica and data movement design patterns
• 5+ years of experience with scheduling tools like Autosys or ControlM
• 3 + Experience in Shell scripting (K-Shell, Bash)
• Design and development of data loading pipelines into databases to support reporting platforms.
• Demonstrable understanding of data modeling and data structures
• Experience with DevOps, Continuous Integration and Continuous Delivery
• Your ability to collaborate with other technical and business minds across the firm.
• Understanding of Technology Lifecycle management standard methodologies
• Your experience in delivering projects in an Agile environment (Kanban and Scrum)
• Good understanding of financial services specifically in the plan sponsor & administration / Benefits & record keeping area.

The Skills You Bring

• Good technical design and analysis skill
• Ability to deal with ambiguity and work in fast paced environment.
• Superb interpersonal skills, both through written and verbal channels
• Excellent collaboration skills ability to work with multiple teams in the organization.
• Ability to understand and adapt to changing business priorities and technology advancements.
• Solid understanding and technology trends in implementing business applications.
• Phenomenal teammate and versatile

Nice to have

• Solid understanding of Oracle database architecture and internals.
• Experience with Python or/and Java
• Experience with Power BI
• Knowledge of Snowflake or any other DaaS (Data as a Service)
• Experience with business intelligence and analytics tools such as OBIEE, PowerBI or Tableau
• Experience in AWS, Snowflake, Airflow.

Company Overview

At Fidelity, we are focused on 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 crafting and championing a work environment that attracts the best talent and reflects our dedication to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their outstanding perspectives and experiences. For information about working at Fidelity, visit Fidelitycareers.com

Fidelity Investments is an equal opportunity employer.

Dynamic Working Associates are expected to be in-person in the office, currently it is one week every other week in a month (bi-weekly) which could potentially change.

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.