THE ROLEIn conjunction with the Investment Data Management Office, the Senior Investment Data Engineer contributes to a strategic initiative to unify and harmonize investment data across the organization. This initiative supports enhanced investment decision making, risk management, analytics, and client reporting for a multi-asset investment platform by delivering consistent, timely, accurate, and user-friendly data to investment professionals, risk teams, and clients.
Are you a hands-on and detail-oriented individual interested in financial instruments, investment data, and analytics? Do you enjoy solving complex data challenges and building scalable data solutions? Are you interested in working across a broad range of traditional and alternative asset classes while collaborating with business and technology teams in a fast-paced environment?
The Investment Data Management Office is seeking a Senior Investment Data Engineer to support the implementation and maintenance of modern data engineering and analytics solutions. This role will contribute to the development, enhancement, and support of investment data platforms and pipelines while partnering closely with data architects, platform engineers, investment teams, and vendor partners. This position offers the opportunity to grow technical expertise and contribute meaningfully to the future of investment data capabilities
WHAT YOU WILL DO- Develop and maintain data models in dbt (Data Build Tool) within Snowflake, implementing business logic and adhering to established data standards and architectural principles.
- Contribute to dbt projects by building modular, scalable, and well-documented transformation pipelines.
- Design, develop, and support scalable data pipelines and data warehouse solutions for reporting, analytics, and operational use cases.
- Participate in development activities and support implementation of solutions aligned with business and program objectives.
- Assist in improving data quality, resiliency, controls, monitoring, and operational efficiency across the investment data platform.
- Troubleshoot data and system issues, identify root causes, and support resolution efforts.
- Partner with senior engineers, platform leads, architects, and business stakeholders to support delivery of investment data solutions.
- Support integration of data ingestion, transformation, orchestration, and validation tools within the unified data platform.
- Contribute to enhancement of data engineering and analytical engineering capabilities across the platform.
- Provide operational and production support, including assistance during unexpected outages or incidents.
WHAT WE ARE LOOKING FOR- Bachelor's degree in Computer Science or related discipline.
- 3-5+ years of experience designing, developing, and supporting data-oriented applications and platforms.
- 2+ years of hands-on experience with SQL and advanced SQL concepts.
- Experience developing and maintaining data models using dbt (Data Build Tool).
- Experience working with data integration (ETL/ELT), data warehousing, and analytics architectures, with understanding of data engineering best practices and design principles.
- Experience with Snowflake and/or other cloud-native databases is preferred.
- Development experience with cloud-based PaaS platforms such as Microsoft Azure, Google GCP, or Amazon AWS.
- Familiarity with Agile SDLC, DevOps practices, CI/CD processes, and cloud technologies.
- Understanding of modern data architecture concepts such as unified data management, data mesh, event-driven architecture, real-time data flows, and data virtualization is a plus.
- Exposure to financial services, investment management, or investment data domains is preferred.
- Strong analytical, problem-solving, interpersonal, and communication skills with the ability to collaborate effectively across teams.
PREFERRED QUALIFICATIONS- Experience working within the asset management industry and investment data domain.
- Understanding of financial instruments, investment data, transactions, positions, and multi-asset investment platforms.
- Certifications in Snowflake, dbt, cloud data engineering technologies, or related data platforms are a plus.
- Interest in emerging AI technologies and understanding of how AI-driven tools can improve engineering workflows, operational efficiency, and analytics processes.
- Experience using automation or AI-assisted development tools to support continuous improvement initiatives is beneficial.
Applicants must be currently authorized to work in the United States on a full-time basis. This position is not eligible for sponsorship.
#LI-SS1
Base Salary Range: $98,500.00 - $141,500.00This position is eligible for competitive incentive bonus.
At MFS, we believe in fair and transparent compensation. For that reason, we're including the salary range for this position. This range reflects our good-faith expectation for what we'll pay depending on the candidate's experience, training and education. In addition to the salary, we also offer significant and competitive incentive compensation based 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 $10,000 lifetime maximum directly to loan provider
- Education Assistance: Tuition reimbursement up to $8,000 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, we'll be happy to discuss them
#LI-HYBRID
MFS is a
hybrid work environment (remote/onsite) unless otherwise stated in the job posting.
