What are the responsibilities and job description for the Senior Data Engineer (Snowflake, MySQL, Python) position at Fidelity Investments?
Job Description
Senior Data Engineer
Note: Fidelity will not provide immigration sponsorship for this position.
The Role
At Fidelity, we love to use data to create incredible personalized customer experiences and develop solutions that help our customers live the lives they want. As part of our organization’s digital transformation, we have made significant investments in our innovative data capabilities to support our customer obsessed culture. We are seeking an expert Senior Data Engineer with a strong database background and passion for understanding and improving on our data to deliver outstanding customer experiences. You will be working in a collaborative team environment where you will have a wealth of opportunities to develop, innovate, advocate for how our software and data is best used, and improve our delivery. This is a fast-paced team that is passionate about designing, implementing, and maintaining a wide variety of processes, platforms, and products for our clients.
The Expertise And Skills You Bring
Fidelity Workplace Consulting (FWC) is composed of over 400 professionals who advise clients on the management of their domestic and global benefits. We are a fast-growing business within Fidelity, providing a broad range of services that touch on every area of benefits design, strategy, funding, communication, and delivery. We are reinventing the consulting experience for our clients through our dedication to responsiveness, expertise, and accuracy. While we focus on working with the Fortune 1000, we also work with Fidelity clients of all sizes. The Digital Solutions team is a shared service within FWC, made up of individuals who lend their skills and expertise towards the implementation, launch and ongoing maintenance of benefits-related microsites, tools, and other online solutions. For more information, please visit this link: https://www.fidelityworkplace.com/s/workplaceconsulting
Fidelity’s Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.
Certifications
Category:
Information Technology
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.
Senior Data Engineer
Note: Fidelity will not provide immigration sponsorship for this position.
The Role
At Fidelity, we love to use data to create incredible personalized customer experiences and develop solutions that help our customers live the lives they want. As part of our organization’s digital transformation, we have made significant investments in our innovative data capabilities to support our customer obsessed culture. We are seeking an expert Senior Data Engineer with a strong database background and passion for understanding and improving on our data to deliver outstanding customer experiences. You will be working in a collaborative team environment where you will have a wealth of opportunities to develop, innovate, advocate for how our software and data is best used, and improve our delivery. This is a fast-paced team that is passionate about designing, implementing, and maintaining a wide variety of processes, platforms, and products for our clients.
The Expertise And Skills You Bring
- 5 years in Technology with 3 years in developing and deploying data solutions
- Excellent written and verbal communication skills including experience writing documentation
- Excellent collaboration skills to work with multiple teams in the organization
- Ability to deal with ambiguity and work in fast paced environment
- Self-organized and capable of managing priorities and delivering project outcomes independently with minimal oversight
- Systems analysis background with an emphasis on legacy process decomposition and debugging/tuning/refactoring and migrations.
- Solid understanding of data analysis concepts and associated tools such as SQL, Python, Stored Procedure, etc.
- Experience building, maintaining, and tuning stored procedures, complex SQL queries.
- QA / Testing – must be highly proficient in QA and testing methodologies/concepts with a demonstratable level of expertise
- Comfortable working within an Agile framework
- Extensive experience with SQL required; knowledge of MySQL, SQLMI, Snowflake preferred
- Hands-on experience with ETL, ELT preferably on informatica for legacy applications; SnapLogic, Azure functions is a plus
- Experience with Python for building ELT pipelines or other scripting languages.
- A passion to design and implement single and multi-tenant data solutions using various database design and data modelling techniques.
- Experience with CICD toolset such as Jenkins, Jenkinscore, Udeploy, Git, GitHub.
- Hands-on experience with either 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, PowerBI, etc.
- Development using DevAssist tools
Fidelity Workplace Consulting (FWC) is composed of over 400 professionals who advise clients on the management of their domestic and global benefits. We are a fast-growing business within Fidelity, providing a broad range of services that touch on every area of benefits design, strategy, funding, communication, and delivery. We are reinventing the consulting experience for our clients through our dedication to responsiveness, expertise, and accuracy. While we focus on working with the Fortune 1000, we also work with Fidelity clients of all sizes. The Digital Solutions team is a shared service within FWC, made up of individuals who lend their skills and expertise towards the implementation, launch and ongoing maintenance of benefits-related microsites, tools, and other online solutions. For more information, please visit this link: https://www.fidelityworkplace.com/s/workplaceconsulting
Fidelity’s Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.
Certifications
Category:
Information Technology
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.