Data Analyst, Finance Technology

• Develop a detailed understanding of how Fund Accounting data is created, enriched, transformed, reviewed, reconciled, approved, and consumed.
• Work with Fund Accounting, Data Governance, and Data Product Management to define business problems, intended outcomes, priorities, users, business rules, data ownership, and acceptance criteria.
• Identify sources of truth, data owners, business definitions, transformation points, downstream consumers, dependencies, controls, and process handoffs.
• Analyze current-state processes and data flows to identify manual work, duplicate logic, data issues, control gaps, and standardization opportunities.

• Translate Fund Accounting needs into clear business, data, integration, reporting, and broader consumption requirements for the appropriate delivery teams.
• Define field definitions, measures, calculations, dimensions, filters, hierarchies, business rules, mappings, acceptance criteria, and expected outcomes.
• Partner with Data Governance and Data Product Management on data ownership, definitions, quality expectations, lineage, control requirements, prioritization, and decision records.
• Develop source-to-target mappings, data dictionaries, process flows, requirements, and traceability artifacts in collaboration with the teams responsible for implementation.
• Frame requirements clearly enough for the Finance Technology Data Solutions Engineer, Enterprise Data Engineering, Centralized Reporting / BI, and application teams to design, build, test, and deliver solutions that meet business objectives.

• Understand the business question, intended consumers, decisions supported, frequency, level of detail, and delivery channel for each consumption need.
• Define requirements for dashboards, reports, extracts, downstream applications, operational workflows, analytics, and other ways Fund Accounting consumes data and derives value from it.
• Identify governed sources of truth and document measures, calculations, dimensions, filters, business rules, refresh expectations, control expectations, reconciliation needs, and validation criteria.
• Convey agreed business requirements to Centralized Reporting / BI, which owns the technical build and delivery of scalable dashboards and reporting solutions using governed data.
• Coordinate Fund Accounting review, business validation, UAT, release readiness, and post-production validation for reporting and other consumption solutions.

• Use SQL and structured analysis to profile data, compare sources, identify anomalies, trace records, quantify breaks, and support root-cause analysis.
• Perform field-level and aggregate analysis to distinguish source, transformation, reference-data, integration, and reporting issues.
• Partner with Fund Accounting, Data Governance, Data Product Management, engineering, and reporting teams to define validation rules, tolerances, exception categories, ownership, and remediation expectations.
• Develop and execute reconciliation, integration, regression, edge-case, reporting, and production-validation test scenarios as part of the broader delivery team.
• Create repeatable queries and validation packs that can be reused by the broader team.

• Act as the bridge between Fund Accounting business teams and Finance Technology while preserving important business and technical detail.
• Coordinate with Data Product Management, Data Governance, the Finance Technology Data Solutions Engineer, Enterprise Data Engineering, Centralized Reporting / BI, application teams, and delivery partners throughout the delivery lifecycle.
• Maintain traceability from the original business problem through requirements, design, testing, release, and validation of the delivered outcome.
• Communicate issues clearly, including affected users and data, business impact, evidence, decisions needed, and recommended next steps.
• Help convert recurring manual investigation into prioritized backlog items and governed, reusable, scalable data or consumption solutions.

• Strong SQL for profiling, joins, aggregations, reconciliation, anomaly detection, and root-cause analysis, preferably in SQL Server.
• Advanced Excel for structured analysis, including lookups, pivots, formulas, comparisons, and controlled validation workbooks.
• Experience defining business, data, reporting, and consumption requirements; mappings; measures; calculations; business rules; acceptance criteria; and test cases.
• Hands-on data-quality analysis, reconciliation, defect investigation, testing, business validation, and UAT.
• Ability to understand data models, ETL/ELT flows, APIs or file interfaces, reporting layers, and dependencies across source, data, and consumption layers.
• Ability to work effectively with Fund Accounting, Data Product Management, Data Governance, Finance Technology engineering, Enterprise Data Engineering, Centralized Reporting / BI, and application teams.

• Databricks, Python, PySpark, Power BI, Microsoft Fabric, Azure data services, or similar platforms.
• Fund Accounting, asset management, investor data, fund administrator, financial reporting, or investment operations experience.
• Working knowledge of accounting balances, transactions, capital activity, reference data, hierarchies, controls, and period-end processes.
• Experience defining requirements for dashboards, reports, extracts, downstream applications, operational workflows, or analytics.
• Exposure to delivery tooling, structured defect triage, release management, lineage, metadata, governance, and auditability concepts.

• Business, data, reporting, and consumption requirements are clear, complete, testable, and aligned to business objectives.
• Data issues are identified and resolved faster through repeatable analysis, clear evidence, and coordinated ownership.
• Reconciliation, testing, business validation, and UAT produce reliable delivery outcomes.
• Fund Accounting consumption needs are translated into governed, scalable solutions delivered through the appropriate Finance Technology, enterprise data, reporting, or application team.
• Strong collaboration, traceability, and handoffs are established across the broader data and reporting operating model.

There is no set deadline to apply for this job opportunity. Applications will be accepted on an ongoing basis until the search is no longer active.