Lead Investment Data Engineer

Lead Data EngineerAt 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 RoleIn conjunction with the Investment Data Management Office, the Lead Data Engineer contributes to a long-term strategic initiative to unify and harmonize our investment data. This initiative enables enhanced investment decision making, risk management and client reporting for our multi-asset platform by delivering consistent, timely, accurate and user-friendly data to investors, risk teams and clients.Are you a hands-on and detailed-oriented individual working on the cutting edge of financial instruments, investment data, and analytics? Are you interested in investment data strategies across a wide variety of traditional and alternative asset classes? Are you a thinker who enjoys devising innovative and flexible business solutions to meet emerging business needs?The MFS Investment Data Management Office is actively searching for a Lead Data Engineer to implement data engineering and analytics solutions. Primary responsibilities include full implementation and maintenance of data ingestion, data maintenance, data validation and data delivery of investment data. We are looking for someone who thrives in an agile, collaborative, team-based environment, working closely with technology peers across MFS, investment professionals and key vendor partners. This position offers the opportunity to shape the future of investment data at MFS.What You Will DoDesign, develop, and implement data pipelines to maintain unified data platform for the Investment Data Management Office(IDMO)Lead and participate in all development activities, develop and implement solutions to meet business requirements that align with program strategic objectivesResponsible for new and on-going development of data pipelines sourcing from internal and external sourcesDrive continuous improvement of data quality, resiliency, control, efficiency, and monitoringTroubleshooting complex system interactions to find the root cause to problemsPartner with platform lead to design, develop, implement and deploy new software components to investment data platformPartner with data architect to evaluate and finalize the unified data modelPartner with integration architect to upgrade and integrate data ingestion and data delivery tools with the unified data platformUpgrade and integrate transformation tool, data validation tool and orchestration tools with the unified data platform to implement data engineering, analytical engineering and data maintenance capabilities.Provide support during unexpected outagesWhat We Are Looking ForBachelor's degree in Computer Science or related disciplines.5-6+ years of experience in design, development and building data oriented complex applications.Minimum of 2-4 years of hands-on progressive experience from SQL to Advanced SQL.Experience working in data integration (ETL/ELT), data warehouse, data analytics architecture and sound understanding of design principles. Knowledge of and experience with Snowflake and other cloud native databases is highly preferred.Development Experience in Cloud based PAAS platforms like Microsoft Azure, Google GCP or Amazon AWS.Deep understanding of Agile SDLC, DevOps and Cloud technologies required, in addition to exposure to multiple, diverse technologies, platforms, and processing environments.Knowledge about various architectures, patterns such as unified data management architecture (UDM), data mesh architecture, event-driven architecture, real-time data flows, non-relational repositories, data virtualization, etc.Experience with building solutions in the financial services domain with an understanding of financial instruments, transactions, and positions, is desired.Good interpersonal and communication skills with the ability to lead cross-team collaboration and partnerships across a variety of internal and external constituencies.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 OfferGenerous time-off provided: including "Responsible time off" for many roles, paid company holidays when the US Stock Exchange is closed, plus paid volunteer timeFamily Focus: Up to 20 weeks of paid leave for new parents, back-up care program, dependent care flexible spending account, adoption assistance, generous caregiver leaveHealth and Welfare: Competitive medical, vision and dental plans, plus tax-free health savings accounts with company contributionsWellness Programs: Robust wellness webinars, employee assistance program, gym reimbursement through our medical plans, fitness center discounts and moreLife & Disability Benefits: Company-paid basic life insurance and short-term disabilityFinancial Benefits: 401(k) savings plan, Defined Contribution plan- 15% of base salary invested into the Plan, competitive total compensation programsMFS 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 talent_acquisition@mfs.com for assistance.MFS is an 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.