Senior Client Reporting Data Analyst

Granite Solutions Groupe; San Francisco, Northern (CA, KY); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

excellent compensation

comprehensive medical, dental, vision,

company-paid life insurance

commuter benefits (pre-tax)

pre-tax 401K contributions

pet insurance, discount card

Job summary

Granite Solutions Groupe is seeking a Senior Consultant, Data Analysis to design, deliver, and continuously improve client reporting technology. You will own end-to-end client reporting data flow, from data ingestion to final report distribution, ensuring accuracy and timeliness for institutional, intermediary, and internal stakeholders.

The ideal candidate has hands-on experience with data pipelines, cloud data warehouses (Snowflake), and reporting platforms, and can diagnose data issues,

Qualifications

• Bachelor's degree required.
• 3–7 years of experience in financial services, preferably within a buy-side asset manager supporting client reporting, investment operations, or related data functions.
• Proficiency in SQL and the ability to independently query, analyze, and troubleshoot complex datasets 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.
• Experience with reporting platforms and end-to-end client reporting data flow.
• Excellent communication and stakeholder management skills.

Responsibilities

• Subject matter expert on end-to-end client reporting workflow, from data sourcing and transformation through report generation and distribution across institutional, intermediary, and internal stakeholders.
• Develop deep familiarity with report templates, delivery schedules, and client-specific data requirements 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 data and platform specifications.
• Maintain a thorough understanding of the client reporting data flow - from source systems through ingestion, transformation, and final report output.
• Support and troubleshoot data pipelines feeding reporting platforms, including identifying root causes of data quality issues and coordinating resolution.
• Document data lineage, pipeline logic, and table/schema structures for client reporting datasets.
• Support platform upgrades, integrations, and UAT testing as part of the SDLC.
• Contribute to data governance practices including metadata documentation, data dictionary maintenance, and lineage tracking.
• Maintain and prioritize a backlog of reporting enhancements, automation opportunities, and data quality improvements.
• Provide hands-on support for ad hoc data requests and analysis in support of client deliverables.

Skills

SQL

Data pipeline concepts

Snowflake

Python scripting

Stakeholder management

SDLC

Analytical thinking

Education

Bachelor's degree

Tools

Snowflake

Eagle PACE

Eagle SRM

Ataccama

Collibra

Job description

Granite Solutions Groupe is seeking a Senior Consultant, Data Analysis to design, deliver, and continuously improve client reporting technology. You will own end-to-end client reporting data flow, from data ingestion to final report distribution, ensuring accuracy and timeliness for institutional, intermediary, and internal stakeholders.

The ideal candidate has hands-on experience with data pipelines, cloud data warehouses (Snowflake), and reporting platforms, and can diagnose data issues,