Senior Data Engineer (Snowflake, MySQL, Python)

Fidelity Investments • Boston, MA

1d • $97,000 - $185,000

About The Position

Fidelity is seeking an expert Senior Data Engineer with a strong database background to improve data and deliver personalized customer experiences. The role is part of the organization’s digital transformation and involves working collaboratively on a fast-paced team to design, implement, and maintain data processes, platforms, and products. The position offers opportunities to innovate, advocate for effective use of software and data, and improve delivery.

The engineer will develop and deploy data solutions; analyze, debug, tune, refactor, and migrate legacy processes; build and maintain stored procedures and complex SQL queries; and create ELT pipelines using Python or other scripting languages. The role also involves designing single- and multi-tenant data solutions using database design and data modeling techniques, applying strong QA and testing practices, and working within an Agile framework. The team supports benefits-related microsites, tools, and other online solutions for Fidelity Workplace Consulting clients.

Requirements

• 5+ years of experience in Technology, including 3 years developing and deploying data solutions.
• Excellent written and verbal communication skills, including experience writing documentation.
• Strong collaboration skills for working with multiple teams.
• Ability to manage ambiguity and work in a fast-paced environment.
• Ability to organize work, manage priorities, and deliver project outcomes independently with minimal oversight.
• Systems analysis background, emphasizing legacy process decomposition, debugging, tuning, refactoring, and migrations.
• Solid understanding of data analysis concepts and associated tools, such as SQL, Python, and stored procedures.
• Extensive SQL experience.
• Experience building, maintaining, and tuning stored procedures and complex SQL queries.
• High proficiency and demonstrable expertise in QA and testing methodologies and concepts.
• Comfort working within an Agile framework.
• Hands-on experience with ETL or ELT, preferably Informatica for legacy applications.
• Experience with Python for building ELT pipelines or experience with other scripting languages.
• Experience with a CI/CD toolset such as Jenkins, Jenkinscore, uDeploy, Git, or GitHub.

Nice To Haves

• Knowledge of MySQL, SQLMI, or Snowflake.
• Experience with SnapLogic or Azure Functions.
• Hands-on experience with Azure or AWS cloud concepts and fundamentals.
• Experience building scalable and robust data solutions for websites using a range of technologies.
• Business Intelligence development experience with tools such as Tableau or Power BI.
• Development using DevAssist tools.

Responsibilities

• Develop and deploy data solutions.
• Analyze, decompose, debug, tune, refactor, and migrate legacy processes.
• Build, maintain, and tune stored procedures and complex SQL queries.
• Build ELT pipelines using Python or other scripting languages.
• Design and implement single- and multi-tenant data solutions using database design and data modeling techniques.
• Apply QA and testing methodologies to data solutions.
• Work collaboratively with multiple teams and contribute to the implementation, launch, and ongoing maintenance of benefits-related microsites, tools, and other online solutions.
• Use data and software effectively to improve delivery and customer experiences.

Benefits

• Comprehensive health care coverage.
• Emotional well-being support.
• Retirement benefits.
• Paid time off.
• Parental leave.
• Charitable giving employee match program.
• Educational assistance, including student loan repayment, tuition reimbursement, and learning resources.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed