Client Reporting Data Engineer

Mainz Brady Group; San Francisco (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Mainz Brady Group is seeking a technically strong Client Reporting Technical Analyst to support the technology and data behind end-to-end client reporting within a financial services environment. The role centers on SQL, data quality, reporting platforms, and production support, ensuring data flows from upstream systems to final reports.

The ideal candidate will have 3-7 years of financial services experience, hands-on SQL skills, experience with Seismic or Vermilion, and familiarity with data

Qualifications

• 3-7 years of financial services experience, ideally within a buy-side asset management environment.
• Strong hands-on SQL skills.
• Experience with client reporting platforms such as Seismic, Vermilion, or similar tools.
• Understanding of data pipelines, ingestion, transformation logic, data warehouses, and table/schema structures.
• Experience with Snowflake or similar cloud data warehouse environments preferred.
• Experience with Eagle PACE, Eagle SRM, or comparable fund accounting/security master platforms strongly preferred.
• Familiarity with investment data including performance, holdings, and characteristics.
• Python or similar scripting/automation experience preferred.
• Bachelor’s degree required.

Responsibilities

• Support the end-to-end client reporting workflow, including data sourcing, transformation, report generation, and distribution.
• Troubleshoot production reporting incidents, data anomalies, pipeline failures, and delivery exceptions.
• Use SQL to query and analyze complex datasets and identify root causes of reporting issues.
• Support data pipelines and understand upstream/downstream dependencies, transformations, schemas, and data lineage.
• Translate business reporting requirements into technical data and platform specifications.
• Support reporting platform upgrades, integrations, UAT, and other SDLC activities.
• Maintain data lineage, metadata, data dictionaries, and reporting documentation.
• Manage reporting enhancements, automation opportunities, and data quality improvements.
• Support ad hoc data analysis for client deliverables, regulatory reporting, and business initiatives.

Skills

SQL

Investment data

Python

Seismic

Vermilion

Snowflake

Data pipelines

Problem solving

Education

Bachelor's degree

Tools

Snowflake

Eagle PACE

Eagle SRM

Ataccama

Collibra

Seismic

Vermilion

Job description

Mainz Brady Group is seeking a technically strong Client Reporting Technical Analyst to support the technology and data behind end-to-end client reporting within a financial services environment. The role centers on SQL, data quality, reporting platforms, and production support, ensuring data flows from upstream systems to final reports.

The ideal candidate will have 3-7 years of financial services experience, hands-on SQL skills, experience with Seismic or Vermilion, and familiarity with data