Senior Data Engineer (Python, SQL, Informatica)
Job Description:
Job Description:
Do you thrive on solving challenges and operating in a multifaceted setting where every single day brings new experiences? Are you a Python expert passionate about solving sophisticated problems and delivering innovative, end-to-end solutions that make a real impact? If yes, the Senior Data Engineer opportunity centered around Defined Contributions (DC) could mark a positive next phase in your career development!
The Role:
The Senior Data Engineer will support the business by working on highly sophisticated Defined Contributions data consulting projects demonstrating their technical and analytical strengths within python. We are looking for someone to join our great team of experts, who enjoy a fast-paced environment, and can provide quality work and an outstanding client and customer experience. Our group uses various service category databases, data warehouses, and other technical applications (i.e. Python, SQL, ETL, Snowflake) to identify, analyze and propose solutions to support DC consulting projects supporting our clients directly. The ideal candidate enjoys a challenge with rewarding work having direct client impact.
The Team:
The Fidelity Workplace Consulting Group is composed of over 600 professionals who advise clients on the management of their domestic benefits. We are a fast-growing business within Fidelity, providing a broad variety of services that touch on every area of benefits design, strategy, funding, communication, and delivery. While we focus on working with the Fortune 1000, we also work with Fidelity clients of all sizes. Data Consulting engages in data quality improvement efforts that span single and multiple product lines (i.e. Health and Welfare, Defined Benefit, Defined Contribution, Stock Plan Services and HR/Payroll) within the implementation and ongoing servicing client lifecycle.
Want more jobs like this?
Get jobs in Boston, MA delivered to your inbox every week.
The Expertise You Have and The Skills You Bring:
- 2+ years Defined Contributions Domain Knowledge/experience
- Minimum of 3+ years in Python, including sophisticated knowledge of Python features and solid experience with data manipulation and analysis using libraries, including Pandas
- Demonstrable experience in crafting and implementing ETL pipelines using Python, encompassing data extraction from various sources (APIs, databases, flat files), transformation logic, and loading into target systems.
- Sophisticated SQL expertise, including writing complex queries, optimizing performance, and working with stored procedures, views, and indexing strategies.
- Hands-on experience with relational databases such as SQL Server, MySQL, and/or Oracle.
- Experience with Informatica or other ETL tools, including integration with Python-based workflows and data pipelines.
- Strong capability to see the big picture and design end-to-end processes, from data ingestion to reporting and automation.
- Excellent debugging skills
Dynamic Working
Fidelity's hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.
At Fidelity, we are passionate about 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 creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associate for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com. Fidelity Investments is an equal opportunity employer.
Fidelity will reasonably accommodate applicants with disabilities who need adjustments in order to complete the application or interview process. Please email us at [email protected] if you would like to request an accommodation.
Certifications:
Category:
Information Technology
Fidelity's hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.
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.
Perks and Benefits
Health and Wellness
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Short-Term Disability
- Long-Term Disability
- FSA
- HSA
- HSA With Employer Contribution
- Fitness Subsidies
- On-Site Gym
- Pet Insurance
- Mental Health Benefits
- Virtual Fitness Classes
Parental Benefits
- Birth Parent or Maternity Leave
- Non-Birth Parent or Paternity Leave
- Fertility Benefits
- Adoption Assistance Program
- Family Support Resources
- Adoption Leave
Work Flexibility
- Flexible Work Hours
- Remote Work Opportunities
- Hybrid Work Opportunities
Office Life and Perks
- Commuter Benefits Program
- Casual Dress
- Snacks
- Company Outings
- On-Site Cafeteria
- Holiday Events
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Personal/Sick Days
- Leave of Absence
Financial and Retirement
- 401(K)
- 401(K) With Company Matching
- Company Equity
- Performance Bonus
- Relocation Assistance
- Financial Counseling
- Profit Sharing
Professional Development
- Tuition Reimbursement
- Promote From Within
- Mentor Program
- Shadowing Opportunities
- Access to Online Courses
- Lunch and Learns
- Internship Program
- Work Visa Sponsorship
- Leadership Training Program
- Associate or Rotational Training Program
Diversity and Inclusion
Company Videos
Hear directly from employees about what it is like to work at Fidelity Investments.