Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The Lead Data Engineer will contribute to a long-term strategic initiative to unify and harmonize investment data, enabling enhanced investment decision making, risk management, and client reporting. This role involves implementing data engineering and analytics solutions, including data ingestion, maintenance, validation, and delivery of investment data within an agile, collaborative environment.

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.
• Troubleshoot complex system interactions to find the root cause of 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.

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.
• Experience in developing and maintaining data models in dbt (Data Build Tool).
• 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.
• Applicants must be currently authorized to work in the United States on a full-time basis.
• This position is not eligible for sponsorship.

Skills

• dbt (Data Build Tool)
• Snowflake
• Microsoft Azure
• Google GCP
• Amazon AWS
• Agile SDLC
• DevOps
• Cloud technologies
• Unified data management architecture (UDM)
• Data mesh architecture
• Event-driven architecture
• Real-time data flows
• Non-relational repositories
• Data virtualization
• Financial instruments
• Transactions
• Positions
• AI technologies
• AI-assisted development
• Automation

Location

• Hybrid

Work Type

• Full-time
• Hybrid

Experience Level

• Lead
• 5-6+ years of experience
• 2-4 years of experience

Education Level

• Bachelor’s degree in Computer Science or related disciplines.

Salary/Compensations

• $110,000.00 - $158,500.00
• Competitive incentive bonus

Benefits

• 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 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

About the Company

• 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.

Equal Opportunity

• At MFS, we are dedicated to building a diverse, inclusive and authentic workplace.
• 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.
• Please see the Know Your Rights: Workplace Discrimination is Illegal document, linked for your reference.