Lead Systems Analyst

Wellington Management•Boston, MA

1d•Hybrid

About The Position

Wellington Management is seeking a Lead Systems Analyst for its Mosaic Prism team. Prism is an enterprise-wide solution that provides curated data from multiple sources and enables consumers to query data as logical entities and navigate relationships along predefined paths. The team owns the architecture, availability, and curation of Prism datasets, along with 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 analysts. The role combines hands-on data analysis and modeling, stakeholder engagement, delivery ownership, and production support, in close partnership with development and platform engineering teams. The position is based in Boston, Massachusetts, with onsite work four days per week and flexibility to work remotely one day per week.

Requirements

At least 7 years of experience in asset management or financial services.
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 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 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 Prism platform roadmap, 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/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, and 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 for new and changed capabilities.
Identify and drive self-service and automation opportunities to 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.

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
Eligible employees may receive a discretionary corporate bonus and/or incentives
Comprehensive benefits package for employees and their families