Data Engineer, Analytics & Performance Insights

Fidelity Investments • Salt Lake City, UT

1d • Onsite

About The Position

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.

Requirements

• 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
• Python experience or a desire to learn
• Understanding of database design concepts and modeling techniques
• Data quality mindset and knowledge of techniques to ensure data quality
• Good understanding of AWS compute and database services
• Strong database programming skills in Oracle SQL and/or Snowflake SQL
• Familiarity with continuous integration pipelines and automated deployment tools such as Jenkins, etc.
• Passion and openness to learning new tools and developing with the latest technologies and frameworks.

Nice To Haves

• Prior experience with Alteryx or similar tools is helpful but not required
• Familiarity with Dev Assist supporting artifacts/assets is a plus

Responsibilities

• Support data architecture to enable business partners to improve the associate, leader and customer experience.
• Hydrate the data lake and build out data marts using structured and unstructured data to support operational metrics and analytics.
• Build out a data quality framework to ensure data is clean, complete, and accurate for near-time analytics and diagnostics.
• Ensure data is AI-ready for future use cases.
• Create and maintain infrastructure documentation and diagrams.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level