Software Engineering Sr. Data Engineer

About the role

The MFS Investment Data Management Office is actively searching for a Senior Data Engineer to implement data engineering and analytics solutions. This role involves designing, developing, and implementing data pipelines to maintain a unified data platform for the Investment Data Management Office (IDMO).

Responsibilities

• 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.
• Partners with platform lead to design, develop, implement and deploy new software components to investment data platform.
• Partners with data architect to evaluate and finalize the unified data model.
• Partners 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.
• 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.

Qualifications

• Hands-on experience in data engineering and analytics.
• Experience with data warehousing and data analytics.
• Experience with cloud-based platforms like Microsoft Azure, Google GCP, or Amazon AWS.
• Experience with data modeling and database design.
• Experience with data validation and data quality assurance.
• Experience with data integration and ETL processes.
• Experience with data visualization tools.
• Experience with data security and compliance.

Skills

• Data Engineering
• Data Analytics
• Cloud Technologies (Azure, GCP, AWS)
• Database Design and Management
• Data Integration (ETL/ELT)
• Data Warehousing
• Data Visualization
• Data Security and Compliance

Benefits

• Base Salary Range: $98,500.00 - $141,500.00
• Competitive Incentive Bonus
• Retirement Plan with Company Match
• Education Assistance Program
• Tuition Reimbursement
• Flexible Spending Accounts (Medical & Dependent Care)
• Health Savings Account
• Wellness Programs
• Choice of Medical and Dental Plans
• Commuter Benefits
• Employee Assistance Program
• Mental Health Support
• Discounted Fitness and Wellness Services

Pay

Base Salary Range: $98,500.00 - $141,500.00

Schedule

MFS is a hybrid work environment (remote/onsite).