Lead Systems Analyst

Wellington Management • Boston, MA

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

About The Position

The Lead Systems Analyst will own technical analysis and delivery for key Prism data domains and platform capabilities, drive the quarterly roadmap across multiple 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, working closely with development and platform engineering teams.

Mosaic Prism is Wellington’s enterprise-wide solution for providing curated data from various sources. It is a key component of the firm’s data platform, enabling consumers 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.

This position is onsite in Boston, Massachusetts, four days a week, with flexibility to work remotely one day a week. The base salary range is USD 90,000–180,000. Employees are eligible for salary, variable compensation, and benefits; other rewards may include a discretionary corporate bonus and/or incentives, if eligible.

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 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/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 effectively 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, to accelerate engineering and analysis work, 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 or SourceTree, and CI/CD deployment pipelines.
• SQL query performance tuning experience.
• Demonstrated 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 the 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, in partnership with development teams.
• 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 an escalation point for production support, 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 that reduce manual analyst effort.
• Apply AI-assisted development and analysis tools to accelerate dataset 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 to support delivery commitments and operational continuity.

Benefits

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

What This Job Offers

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