Software Engineering Sr. Data Engineer
Boston, NH - USA
Job Summary
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
In conjunction with the Investment Data Management Office the Senior 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 Senior 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 DO
- Design develop and implement data pipelines to maintain unified data platform for the Investment Data Management Office (IDMO)
- Create and maintain detailed technical design and architecture documentation to support development implementation and ongoing enhancement of data engineering solutions
- Develop and execute comprehensive unit tests ensuring thorough test coverage and clear documentation of test cases and results
- Lead and participate in all development activities develop and implement solutions to meet business requirements that align with program strategic objectives
- Responsible for new and on-going development of data pipelines sourcing from internal and external sources
- Drive continuous improvement of data quality resiliency control efficiency and monitoring
- Troubleshooting complex system interactions to find the root cause to problems
- Partner with platform lead to design develop implement and deploy new software components to investment data platform
- Partner with data architect to evaluate and finalize the unified data model
- Partner with integration architect to upgrade and integrate data ingestion and data delivery tools with the unified data platform
- Upgrade 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 outages
WHAT WE ARE LOOKING FOR
- Bachelors degree in Computer Science or related disciplines.
- Minimum of 5 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.
#LI-SS1
Base Salary Range: $98500.00 - $141500.00 This position is eligible for competitive incentive bonus.At MFS we believe in fair and transparent compensation. For that reason were including the salary range for this position. This range reflects our good-faith expectation forwhat well pay depending on the candidates experience training and addition to the salary we also offer significant and competitive incentive compensationbased on both individual and company performance. Other components of our Total Rewards Package include:
MFS contributes an amount equal to 15% of your base salary to your retirement account that is separate from the company -sponsored 401(k)
Education Assistance: MFS contributes $100 monthly up to $10000 lifetime maximum directly to loan provider
Education Assistance: Tuition reimbursement up to $8000 annually
Education Assistance: Access to discounted tutors and college coaches
Generous time off and fully paid leaves including 20-weeks for maternity 12-weeks for parental and caregiver leaves
Choice of medical and dental plans and an and an employer contribution into the Health Savings Account
Tax deferred commuter benefits & flexible spending accounts (medical & dependent care)
Wellness Programs: Robust wellness webinars employee assistance program with a focus on mental health subsidized fitness benefit via Wellhub (formerly Gympass) where you can workout at gyms studios and boutique fitness locations near you join virtual personal training sessions and access a wide variety of well-being apps
Our compensation philosophy is to pay competitively for talent while ensuring equity across employees performing comparable work. We are committed to transparency if you have questions about how we arrived at this range or what additional benefits and bonus opportunities come with the role well be happy to discuss them
#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 doesnt align perfectly we encourage you to apply - you might be just the right candidate for this role or others.
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 or email 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. Please see the Know Your Rights: Workplace Discrimination is Illegal document linked for your reference.
Required Experience:
Senior IC
About Company
MFS is ranked #79 on ENR's Top NYC Design Firm list and #16 Best Place to Work in NJ. MFS is an independent and innovative consulting engineering and construction management firm headquartered in South Plainfield, New Jersey. We share a total commitment to excellence both internally ... View more