MFS
DBT Investment Lead Data Engineer
Boston · Full-time
No sponsorship$110k-$159kDetected 16 hours ago
SQLSnowflakeAWSGCPAzureDevOpsdbtData AnalysisData EngineeringCommunicationCollaboration
About the role
- 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?
Responsibilities
- Develop and maintain data models in dbt (Data Build Tool) within Snowflake, implementing business logic and ensuring alignment with existing architecture and data standards.
- Manage and contribute to dbt projects, ensuring code quality, proper documentation, and alignment with modular, scalable design patterns.
- Design, build, and administer scalable data pipelines and a robust data warehouse to support reporting, analytics, and operational use cases.
- Lead and participate in all development activities, develop and implement solutions to meet business requirements that align with program strategic objectives
- Drive continuous improvement of data quality, resiliency, control, efficiency, and monitoring
- 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
Requirements
- Bachelor'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.
- 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.
- Experience with building solutions in the financial services domain with an understanding of financial instruments, transactions, and positions, is desired.
Nice to have
- Experience working within the asset management industry and investment data domain, with exposure to multi-asset investment platforms and related data ecosystems.
- Understanding of asset management concepts and knowledge of various financial instruments and products, including traditional and alternative asset classes.
- Industry certifications in Snowflake, dbt, cloud data engineering platforms, data warehousing technologies, or financial markets/investment operations are highly valued.
- Demonstrated interest in emerging AI technologies and an understanding of how AI-driven tools can improve day-to-day engineering processes, data quality, operational efficiency, and analytics workflows.
- Familiarity with leveraging AI-assisted development, automation, or data engineering best practices to enhance productivity and continuous improvement initiatives is a plus.
- Applicants must be currently authorized to work in the United States on a full-time basis.
- This position is not eligible for sponsorship.
- Knowledge of and experience with Snowflake and other cloud native databases is highly preferred.
Compensation
- MFS contributes an amount equal to 15% of your base salary to your retirement account that is separate from the company -sponsored 401(k)
- $110,000.00 - $158,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.
Benefits
- 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)
- 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
- 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.
Company info
- 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.
Equal opportunity
- 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.
Visa & Work Authorization
- Applicants must be currently authorized to work in the United States on a full-time basis.
This listing is sourced directly from MFS's careers page and normalized into a canonical job model.