Senior Data Engineer

Posted:
7/24/2024, 1:44:31 AM

Location(s):
Boston, Massachusetts, United States ⋅ Massachusetts, United States

Experience Level(s):
Senior

Field(s):
Data & Analytics

Workplace Type:
Hybrid

At MFS, you will find a culture that supports you in doing what you do best. Our employees work together to reach better outcomes, favoring the strongest idea over the strongest individual. We put people first and demonstrate care and compassion for our community and each other. Because what we do matters – to us as valued professionals and to the millions of people and institutions who rely on us to help them build more secure and prosperous futures.


THE ROLE

We are searching for an enthusiastic Senior Data Engineer to join our Investment Technology Team.  You will play a key role in shaping the future of investment data at MFS by designing, developing, and implementing data engineering and analytics solutions for our multi-asset platform.  This role offers the chance to leverage your expertise in investment data, cloud platforms, and data pipelines to contribute to a long-term strategic initiative to unify our investment data.

WHAT YOU WILL DO

  • Analyze and organize raw data from different sources (vendors, data delivery methods, etc.)

  • Maintain SQL databases.

  • Build data models and pipelines

  • Automate reports and processes to run with varying frequencies.

  • Monitor and debug processes and report the problem to the corresponding responsible parties.

  • Explore ways to enhance data quality, reliability, and efficiency

  • Develop analytical tools and programs

  • Collaborate with data scientists and architects on several projects

  • Perform unit tests and conduct reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performance.

  • Work with cross functional Agile teams and DevOps principles

WHAT WE ARE LOOKING FOR

REQUIRED:

  • Bachelor’s degree or equivalent experience in Computer Science, Finance, or related field.

  • Minimum 2-5+ years of related experience in Extract, Transform, Lead (ETL) and/or Extract, Load, Transform (ELT) processes.

  • Extensive experience working with database management languages (SQL, NoSQL).

  • Experience with object-oriented programing (OOP)/Scripting languages such as R or Python

  • Experience with cloud platforms (AWS, Azure, GCP) and data warehousing solutions (Snowflake, Amazon Red Shift, Google BigQuery, Azure Synapse).

  • Strong technical acumen, analytical and problem-solving skills, critical thinking skills

  • Ability to work across boundaries, building cross-organizational relationships.

  • Strong understanding of data modeling concepts (ERD, Dimensional Modeling, Data Vault) and data APIs (RESTful API).

  • Strong desire to expand your skills through self-study, hands-on learning, and formal instruction.

  • Strong interpersonal, communication (both written and oral) & analytical skills; must be team-oriented and deadline-driven.

PREFFERED:

  • Experience with data integration tools such as DBT and Fivetran/HVR

  • Experience in fixed income or financial services.

#MBLI

#LI-HYBRID

At MFS, we are dedicated to building a diverse, inclusive and authentic workplace. If you are excited about this role but your past experience doesn't align perfectly, we encourage you to apply - you might be just the right candidate for this role or others.

What we offer:

  • Generous time-off provided: including "Responsible time off" for many roles, paid company holidays when the US Stock Exchange is closed, plus paid volunteer time
  • Family Focus: Up to 20 weeks of paid leave for new parents, back-up care program, dependent care flexible spending account, adoption assistance, generous caregiver leave
  • Health and Welfare: Competitive medical, vision and dental plans, plus tax-free health savings accounts with company contributions
  • Wellness Programs: Robust wellness webinars, employee assistance program, gym reimbursement through our medical plans, fitness center discounts and more
  • Life & Disability Benefits: Company-paid basic life insurance and short-term disability
  • Financial Benefits: 401(k) savings plan, Defined Contribution plan- 15% of base salary invested into the Plan, competitive total compensation programs

MFS is a hybrid work environment (remote/onsite) unless otherwise stated in the job posting.

If any applicant is unable to complete an application or respond to a job opening because of a disability, please contact MFS at 617-954-5000 or email [email protected] for assistance. 

MFS is an Affirmative Action and Equal Opportunity Employer and it is our policy to not discriminate against any employee or applicant for employment because of race, color, religion, sex, national origin, age, marital status, sexual orientation, gender identity, genetic information, disability, veteran status, or any other status protected by federal, state or local laws. Employees and applicants of MFS will not be subject to harassment on the basis of their status. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited. Please see the Know Your Rights: Workplace Discrimination is Illegal document and Pay Transparency Nondiscrimination Provision, linked for your reference.