Lead Systems Analyst

Wellington Management • Boston, MA

1d • $90,000 - $180,000 • Hybrid

About The Position

Wellington Management is seeking a Lead Systems Analyst for Mosaic Prism, its enterprise-wide solution for providing curated data from various sources. Prism is a key part of the firm’s data platform, enabling users to query data as logical entities and navigate relationships along predefined paths. The team is responsible for the architecture, availability, and curation of Prism datasets, as well as platform resiliency, deployment tooling, and self-service capabilities used across the firm.

The Lead Systems Analyst will own technical analysis and delivery for key Prism data domains and platform capabilities, drive the quarterly roadmap across business partners, and provide technical leadership and mentorship to other analysts. The role combines hands-on data analysis and modeling, stakeholder engagement, delivery ownership, and production support, in collaboration with development and platform engineering teams.

The position is based onsite in Boston, Massachusetts, four days per week, with flexibility to work remotely one day per week. The base salary range is USD 90,000–180,000. Wellington offers salary, variable compensation, benefits, and potentially a discretionary corporate bonus and/or incentives if eligible. Benefits include a retirement plan; health and wellbeing coverage; dental, vision, and pharmacy coverage; a health savings account; flexible spending accounts; commuter program; employee assistance program; life and disability insurance; adoption assistance; back-up childcare; tuition/CFA reimbursement; and paid time off, including leave of absence, paid holidays, volunteer, sick, and vacation time.

Requirements

• At least 7 years of experience in the asset management or financial services industry.
• Strong hands-on understanding of investment management datasets and workflows, including positions, performance, reference/security-master data, and investment analytics such as DV01, duration, and returns; ability to recognize unexpected results and investigate causes.
• Excellent SQL skills, including multi-table joins, as-of/effective-date logic, and diagnosing discrepancies between data sources; strong knowledge of relational databases and familiarity with non-relational data technologies.
• Practical Python experience for data analysis, troubleshooting, or related technical work.
• Ability to read and write GraphQL and REST API queries for data access and investigation; service development experience is not required.
• Working familiarity with AWS S3, Athena, and CloudWatch/OpenSearch for read-level data access and log investigation.
• Understanding of messaging/notification patterns and batch scheduling concepts.
• Demonstrated experience independently leading technical initiatives, coordinating competing priorities across business and technology stakeholders, and mentoring junior team members.
• Excellent written and verbal communication skills, including the ability to represent the team with senior business and technology stakeholders.
• Ability and willingness to work effectively in a business-critical production environment, including production-support and escalation responsibilities.
• Ability to work independently and guide and direct the work of others.
• Ability and willingness to work in an energetic, fast-paced, team-oriented environment.
• Undergraduate degree in a related subject.

Nice To Haves

• Familiarity with Snowflake and Microsoft Fabric.
• Experience with metadata-driven data platforms and data federation or integration across multiple sources.
• Familiarity with cloud deployment strategies, including blue/green deployments, disaster recovery, and cloud migration.
• Experience using AI coding and analysis assistants, such as Claude Code or GitHub Copilot, including building reusable AI-powered tools or team automations.
• Experience with visualization tools such as Tableau.
• Understanding of modern source control tools such as Git and SourceTree, and CI/CD deployment pipelines.
• SQL query performance tuning experience.
• Ability to design, document, and support highly complex, interrelated systems and data processing pipelines.
• Experience with messaging/notification systems and batch job scheduling tools.

Responsibilities

• Lead technical analysis, design, and delivery of Prism data domains and platform capabilities, driving initiatives from requirements through production support.
• Own and drive the quarterly (PI) Prism platform roadmap, coordinating deliverables across business and technology partners.
• Define data requirements and guide enhancements to core platform components, including data persistence and caching, notification and messaging, and metadata deployment and publishing processes.
• Work with data producers, consumers, business stakeholders, and application teams to onboard datasets and design logical data entities, keys, and relationships; assess downstream impacts of source-system changes and guide analysts through complex requirements.
• Partner with Platform/Infrastructure engineering on deployment strategy, disaster recovery planning, and cloud migration initiatives affecting Prism.
• Serve as a production-support escalation point, take ownership during incidents, investigate data and platform issues using SQL, Python, API queries, and cloud data and logs, and maintain support playbooks, troubleshooting guides, and administrative tooling.
• Author and review Prism data-domain design and support documentation, and help establish team documentation and design standards.
• Coordinate with QA, analyst teams, and vendors to define test strategy and ensure smoke-test and regression coverage for new and changed capabilities.
• Identify and drive self-service and automation opportunities that reduce manual analyst effort.
• Use AI-assisted development and analysis tools to accelerate dataset onboarding, testing, and support, and build reusable AI tools or skills for other analysts.
• Mentor junior analysts, review their designs and documentation, and provide technical direction to analysts and developers to support delivery commitments and operational continuity.

Benefits

• Retirement plan
• Health and wellbeing coverage
• Dental coverage
• Vision coverage
• Pharmacy coverage
• Health savings account
• Flexible spending accounts
• Commuter program
• Employee assistance program
• Life and disability insurance
• Adoption assistance
• Back-up childcare
• Tuition/CFA reimbursement
• Paid time off, including leave of absence, paid holidays, volunteer, sick, and vacation time
• Salary and variable compensation
• Potential discretionary corporate bonus and/or incentives, if eligible

What This Job Offers

• Job Type: Full-time
• Career Level: Senior