DBT Investment Data Engineer

Join to apply for the DBT Investment Data Engineer role at ExecutivePlacements.com. 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. THE ROLE In conjunction with the Investment Data Management Office, the Lead 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. What You Will Do 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 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 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. 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. Good interpersonal and communication skills with the ability to lead cross-team collaboration and partnerships across a variety of internal and external constituencies. Seniority Level Mid‑Senior level Employment Type Full‑time Job Function Information Technology Industries Advertising Services Referrals increase your chances of interviewing at ExecutivePlacements.com by 2x Get notified about new Data Engineer jobs in Boston, MA. #J-18808-Ljbffr