Sr Data Analyst Advent Geneva

• Write complex SQL queries to extract, transform, and analyze large financial datasets.

• Develop and optimize stored procedures, views, and data models to support reporting and analytics.

• Perform deep-dive data analysis to identify trends, anomalies, and reconciliation breaks.

• Partner with data engineering teams to improve database performance and data architecture.

Data Validation & Reconciliation

• Analyze transactional, position, cash, and P&L data across multiple systems.

• Perform reconciliations between accounting systems, data warehouses, and downstream reporting platforms.

• Conduct root cause analysis for data discrepancies and implement long-term fixes.

Reporting & Business Intelligence

• Build and maintain automated reports and dashboards using SQL and BI tools.

• Translate business requirements into technical data queries and reporting solutions.

• Support financial, operational, and regulatory reporting processes.

Data Integration & Process Improvement

• Support ETL processes and data integrations between portfolio accounting platforms and other enterprise systems.

• Identify opportunities to streamline reporting workflows and automate manual processes.

• Maintain documentation for data definitions, transformations, and reporting logic.

Required:

• 4+ years of experience in a data analyst role with heavy SQL development.

• Advanced proficiency in SQL (complex joins, CTEs, window functions, performance tuning).

• Experience working with large relational databases (SQL Server, Oracle, or similar).

• Strong understanding of financial or investment data (transactions, positions, valuations, P&L).

• Experience working with Advent Geneva (required).

• Excellent analytical, troubleshooting, and problem-solving skills.

Preferred:

• Familiarity with ETL tools, data warehousing concepts, and data modeling.

• Experience with BI tools (Power BI, Tableau, etc.).

• Exposure to Python for data analysis or automation.