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 platform for providing curated data from multiple sources. Prism enables 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 by business and technology teams across the firm.

The analyst will own technical analysis and delivery for key data domains and platform capabilities, drive the quarterly roadmap across business partners, and provide technical leadership and mentorship to analysts. The role combines hands-on data analysis and modeling, stakeholder engagement, delivery ownership, and production support, working closely with development and platform engineering teams. The position is based in Boston, Massachusetts, with employees working in the office four days per week and remotely one day per week.

Requirements

• 7 or more 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 and security-master data, and analytics such as DV01, duration, and returns.
• Ability to recognize unexpected investment-data results and investigate their 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 and notification patterns and batch scheduling concepts.
• 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 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 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 and 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 roadmap for the Prism platform, coordinating deliverables across business and technology partners.
• Define data requirements and guide enhancements to platform components, including data persistence and caching, notification and messaging, and metadata deployment and publishing processes.
• Partner 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 and 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, and investigate data and platform issues using SQL, Python, API queries, cloud data, and logs.
• Author 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.
• Identify and drive self-service and automation opportunities that reduce manual analyst effort.
• Use AI-assisted development and analysis tools to accelerate onboarding, testing, and support work, 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.

Benefits

• Retirement plan
• Health and wellbeing coverage
• Dental, vision, and 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
• Eligible employees may receive a discretionary Corporate Bonus and/or incentives

What This Job Offers

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