Client Reporting Technical Analyst

Role: Client Reporting Technical Analyst Employment Type: ContractLocation: San Francisco, CADescription: OverviewWe are seeking a technically proficient Technical Analyst to support the design, delivery, and continuous improvement of Client Reporting technology. This role will be an expert on the end-to-end client reporting data flow - from upstream data ingestion and pipeline management through to final report generation and distribution - ensuring accuracy, timeliness, and operational resilience across all reporting channels.The ideal candidate brings hands-on experience with reporting platforms like Seismic or Vermilion, a strong command of data pipelines and warehouse structures, and a working knowledge of the broader investment operations data ecosystem. This role is well suited for a self-starter who can independently diagnose data issues, partner with technology and business teams, and drive continuous improvement in a lean, high-ownership environment.Key Responsibilities Include• Subject matter expert on end-to-end client reporting workflow, from data sourcing andtransformation through report generation and distribution across institutional, intermediary,and internal stakeholders.• Develop deep familiarity with report templates, delivery schedules, and client-specific datarequirements across standard and custom reporting packages.• Manage and triage production report incidents, proactively identifying and resolving failures,data anomalies, or delivery exceptions prior to client impact.• Collaborate with stakeholders to translate business reporting requirements into technical dataand platform specifications.• Maintain a thorough understanding of the client reporting data flow - from source systems(vendor system, internal data warehouse) through ingestion, transformation, and final reportoutput.• Support and troubleshoot data pipelines feeding reporting platforms, including identifying rootcauses of data quality issues, mapping upstream data dependencies, and coordinatingresolution with data and platform teams.• Document data lineage, pipeline logic, and table/schema structures for client reporting datasets,contributing to a maintainable and auditable data environment.• Support platform upgrades, integrations, and UAT testing as part of the broader SDLC process.• Contribute to data governance practices including metadata documentation, data dictionarymaintenance, and lineage tracking within platforms such as Ataccama or Collibra.• Maintain and prioritize a backlog of reporting enhancements, automation opportunities, anddata quality improvements.• Provide hands-on support for ad hoc data requests and analysis in support of client deliverables,regulatory filings, and business initiatives.Qualifications3–7 years of experience in financial services, preferably within a buy-side asset manager supportingclient reporting, investment operations, or related data functions.• Demonstrated understanding of the end-to-end client reporting data flow, including datasourcing from accounting and operations platforms, pipeline transformations, and reportdistribution.• Proficiency in SQL and the ability to independently query, analyze, and troubleshoot complexdatasets across relational databases or cloud data warehouses (Snowflake preferred).• Working knowledge of data pipeline concepts, including ingestion patterns, staging layers,transformation logic, and table/schema design.• Strong analytical and problem-solving skills with a demonstrated ability to identify data issues,trace root causes, and drive resolution independently.• Experience managing or supporting technology projects within the SDLC framework.• Excellent communication and stakeholder management skills.• Demonstrated ability to take initiative, work independently, and hold themselves accountablefor delivering results in a lean, low-structure environment.• Experience with Eagle PACE, Eagle SRM, or comparable fund accounting and security masterplatforms strongly preferred.• Familiarity with Snowflake or similar cloud data warehouse environments, includingunderstanding of data models supporting performance, holdings, and characteristics, preferred.• Experience with scripting or automation (Python or equivalent) to support pipeline monitoring,report validation, or workflow automation preferred.• Bachelor's degree required