Data Engineer, Analytics & Performance Insights

Do you enjoy supporting data architecture to enable business partners the ability to improve the associate, leader and customer experience? The Data Engineer, Analytics and Performance Insights supports the Brokerage Client Services Analytics organization by supporting the data infrastructure that makes those insights possible. This will involve hydrating the data lake and building out data marts using structured data and unstructured data to support operational metrics and analytics. The work will include building out a data quality framework to ensure that data is clean, complete and accurate enough to support near-time analytics and diagnostics across our channels and AI-ready for future use cases.

Bachelor’s Degree in Computer Science or related field

• 3-5 years of hands-on experience working with SQL or Data Engineering
• Solid experience in writing complex SQL queries on Oracle (PL/SQL) and Snowflake
• Hands-on experience with SQL performance optimization and tuning
• Experience working with large data sets
• Experience with ETL strategies, design, and development. Prior experience with Alteryx or similar tools is helpful but not required
• Python experience or a desire to learn
• Familiarity with Dev Assist supporting artifacts/assets is a plus
• You can create and maintain infrastructure documentation and diagrams
• You understand database design concepts and modeling techniques
• You have a data quality mindset and knowledge of techniques to ensure data quality
• You have a good understanding of AWS compute and database services
• You have strong database programming skills in Oracle SQL and/or Snowflake SQL.
• Familiarity with continuous integration pipelines and automated deployment tools such as Jenkins, etc.
• Passionate and open to learning new tools and developing with the latest technologies and frameworks.

The Data Engineer, Analytics and Performance Insights is part of Fidelity’s Brokerage group, specifically within the Strategy, Planning and Enablement Team. We provide holistic reporting and analytics support to the Brokerage Client Services organization. We are a leading provider of investment management, retirement planning, family conversations, portfolio guidance, brokerage, benefits outsourcing, and many other financial products and services. We believe in building relationships, not just in building sales or building our assets. After all, our clients will place their investments, their savings, and their futures in our hands. This is an important responsibility and that’s why we’ll surround you with amazing, supportive people and all the tools you need., 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.